.&1|?" {}:+dt 4BEn!3_${EjTb144{Gjb}hI_ƏQ .;։M 3#f&oföΫ(A~"~JmCOqbErl89-T<&̩r#H8zN|48<CA`W&)Brz5[y-ģL7͌2!UX *SSN{)Xjw(#er?7Su {J"lh4Թł;"2@r By;l>Y#_̇)!ܰC liu|fL0G+>.$Xe)4)M.)f[7 D@\+5x-Bj/E%C2Na_Dt}@tse J N5[y-ģL7͌2!UyߖiN؝1"gt=KB,+?gs;(Yw2m *])6"Jֻ 5AyYA=Fӿam)ZXQxKOBYL8FP("d= =a~vK&&L[{XᎯ"Óbt?'jq6 TQ͙|ѓw-$B j&9)ֈK1UCD{s0y(RںܭW?go6&\bEH$$1=3 *yckheMW5&wqbDdOPjBH[ymαfObUC0(!jJCcYiuDv_/A|#4/]]qmU/ͳTKM}'x2Oil`%bcx;GbDFR*ojDQ e#C>8FP("d]jA4e>S'Z&G}@tse J N5[y-ģLɀk7DZ  (QC.3RD`(lWP<`E9۫p8ǜ_eYQ0v9om<@{$]U" O UX YmMݴuӽO`*ZEpl9ŕַbG8u5!dcȕZ1W@d7ߌ!4=ZG9~=u<8 %0U%B+CSluyuffN!xoqh)iTHH̪LESNV\\:̎ۼ ͪҪ4IFd7xOQh|yg/#CQzt&y%; d!]kەai=?{70"p鿚5,)+LG߅jς8Xq}cDբ LJH"/gWՑ"a@fAm7\* / fz[ 扲D>G={S1^aBՂ[ }WmZrl|QY:f܉}v 8+.2$ Tz?#Z?z]JF/} ӶqI)ҾoӞG  Etg+7s:ѲԖ ?diꥵP5*}Hx tC>"iݸUgKMc<@v=Qmgf\-6Fʢw%8=;"N\1tdHAOx\(;(ubG8u5!dcȕZ1W@d7ߌ!4)[(=#~)cikN8v.y,JST[DOL=Eߩoze9Ƅ=)cwcPQ 4T07׵T/$݁@}Tʭ$M.}{6%tc OjׅM u `Fm=^%g ѻ5VVݒ {}vC?\b)K&R^sE1t$.9gؾ0_x. =Ve )l(uWVPr`۰ZilCN1 EtgvָeI+d]!ŸW_ 05i?G᷽h]a_7q>Ҙ 'ӇPK1Ǣ #;{t7X܀\p:٢.m83wlkvFS*T8s&[7^b݇ȬՕdP&ĭkgp2aMP pΜ9(ZrK@2Gr ; -N,'\Z=bXC(RפHE;L!j{=QrXT)5+*,η5)4m;fS)<گ\U-5)%*U&u,=YYpt&tUkOIrkvo:AhN򚶅SrT6jSd:Ot<1%<[\$@g~@nUvYtcA2>]JF/} ӶqI)0^= F+i Etgr5 2Y$^r;} ?G᷽h]@6rt(@SālB7CSFb# w`\̹$~mk@O%#GeM'T>O"0Wx1)oO]BO8dS^ "7"-cFCĶP30A 6knÙ O :kN 1oBI"BeT-$j A}f,GIؒG l^8nn&,`\fʱwƏE5մ=>6#*dIP|)ޠvuLݸA8nn&,`\fT,C6dVY3=┳pF8sA1eo>15x;2"YV35t7ƨ(感/:Ʊ9$SޭAϛ]_GA nͻ"BeTaptk`SYr quA: nV=_ 8nn&,`\fv~r[pJSX0qBjD8DBP ؄"g p6bMh|s~s 'string' }, { name: 'Title', type: 'string' }, { name: 'HireDate', type: 'date' }, { name: 'BirthDate', type: 'date' } ], hierarchy: { keyDataField: { name: 'EmployeeID' }, parentDataField: { name: 'ReportsTo' } }, id: 'EmployeeID', localData: employees }; var dataAdapter = new $.jqx.dataAdapter(source); // create Tree Grid var columns = [ { text: 'First Name', dataField: 'FirstName', width: 160 }, { text: 'Last Name', dataField: 'LastName', width: 160 }, { text: 'City', dataField: 'City', width: 120 }, { text: 'Country', dataField: 'Country' } ]; $("#treeGrid").jqxTreeGrid( { width: 550, source: dataAdapter, sortable: true, ready: function () { $("#treeGrid").jqxTreeGrid('expandRow', '2'); }, columns: columns }); $("#columnName").jqxDropDownList({width: 100, selectedIndex: 0, autoDropDownHeight: true, source: ['First Name', 'Last Name', 'City', 'Country'] }); $("#sortOrder").jqxDropDownList({ width: 100, selectedIndex: 0, autoDropDownHeight: true, source: ['Ascending', 'Descending'] }); $("button").jqxButton(); $("#sort").click(function () { var columnIndex = $("#columnName").jqxDropDownList('selectedIndex'); var sortOrder = $("#sortOrder").jqxDropDownList('selectedIndex') == 0 ? 'asc' : 'desc'; $("#treeGrid").jqxTreeGrid('sortBy', columns[columnIndex].dataField, sortOrder); }); $("#clear").click(function () { $("#treeGrid").jqxTreeGrid('sortBy', null); }); });
Settings
Column:
Sort Order: