.&1|?" {}:+dt 4BEn!3_${Eڞtڹċ.5[o=))Pmi8#fG[\տ"W%CφP{_`[2_KDžDOB^6K•&kKaa,N60~A+Q,:! uWhCEsMxЃQ] X'Տ/] k\,%v*Oq캻9d4"݆[@T";0yFwoGW4?qB֬|_ŭ1&^[cT * )̠PhF-8Ea^=e\% p@IFR!h> R^%X)}@tse J N5[y-ģL7͌2!UyߖiN؝1% > RJ=KB,+?gs;(Yw2m *])6"Jֻ 5AyYA=Fӿ dx~j}&BZPUu g]Dk{;(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&wqbDdOPhZ[1\mUH&M|X?ِ$3L?#bck+˕ušoUME V*@kf:}I׷ϙcpLB"TF(ʶ^#>qQI^ZNAsqɾ:3u`{:Wl n+{HE iNJY܋bUC0(!jJCcYiuDv_/A|#4/]]qmU/ͳTKNJ@xkS&QɢG5^A-yLfiB)=S]+93-@M(uHmn(M9 4tܭeyW8lʌ,2RʶG,;Z0X '{5[y-ģL7͌2!UyߖiN؝1ߋ4Qru,Ȱs-}@tse J N5[y-ģL7͌2!UyߖiN؝1aFM$'X\ׄڴ8z?.+q2]aovwE~]>!fT#SC4Ao@&\bEH$$1=3 *yckheMW5&wPJ3@52dbUC0(!jJCcYiuDv_/A|#4/]]G vA0 -po1s{=KtG{Uv2w NV&ڷC璢qȿsB*LIeYA `aCqe`gW^~؁f<"h dn=l8t6'343N m7$^8nn&,`\ff= S:PM'QN< ͡>cư~>Rah4"MudDN4)0\Whq0SX0qBjD8DBP ؄"g p6bMh|P]&Z꿏\X^/2Df,mR! 0o j=Gl]2G\L$ j~JQ3^kɚ Ag~8҃#Y Ym!\8nn&,`\fӄH7D@aF0ůD3NPYFU}7ϛ]_GA nͻ7գ?LBh;i' gh&6E2l-@1 V|h8`mܻ[jy%%^ 7 {*A،M3·  j,V+v*~h&6E2l-@1 V|h,VnXKf5'#_W+J=FAzG0[ j,V+v*~|YDL >, Ķ"wGk>W w|@X5dlǜ;*|6pOP2 MT Qn*0ĿTP\@R*^#t쮊ܧ1=B-$6̹GتxE>"C׹:x{^Bm25U5Ůڑ[ou 3N S 0 za SOns܅1R)VnCydmpor>Cet%gլ. q 0-tFYKKGd~^5yG¹;bh^iG|:D&GQUSt| Zc*̵dJa9[qVaEEqY[&hЮ9}HV܂ÒƢr>7hFLdW{ϒG6þ#Pz|xMq8aZ(7#C Wſ{gnKҹՄh|ߠzraCDQU:ЗW:&\ޖK> Y6ꚡ^yHXBb!txq4׻ 苫u eVػYMgi:仗4_ziW^Bq<`+uD8DBP ؄"ge qJ,)zem\^ Nc\_Iؐn+)e ͜;zqf~4|~Z=T xuj4 \@fq VVFfo ınҏn5 Q ^YeVMz records depending on the selected column. var updateFilterBox = function (datafield) { var filterBoxAdapter = new $.jqx.dataAdapter(source, { uniqueDataFields: [datafield], autoBind: true }); var uniqueRecords = filterBoxAdapter.records; uniqueRecords.splice(0, 0, '(Select All)'); $("#filterbox").jqxListBox({ source: uniqueRecords, displayMember: datafield }); $("#filterbox").jqxListBox('checkAll'); } updateFilterBox('firstname'); // handle select all item. var handleCheckChange = true; $("#filterbox").on('checkChange', function (event) { if (!handleCheckChange) return; if (event.args.label != '(Select All)') { handleCheckChange = false; $("#filterbox").jqxListBox('checkIndex', 0); var checkedItems = $("#filterbox").jqxListBox('getCheckedItems'); var items = $("#filterbox").jqxListBox('getItems'); if (checkedItems.length == 1) { $("#filterbox").jqxListBox('uncheckIndex', 0); } else if (items.length != checkedItems.length) { $("#filterbox").jqxListBox('indeterminateIndex', 0); } handleCheckChange = true; } else { handleCheckChange = false; if (event.args.checked) { $("#filterbox").jqxListBox('checkAll'); } else { $("#filterbox").jqxListBox('uncheckAll'); } handleCheckChange = true; } }); // handle columns selection. $("#columnchooser").on('select', function (event) { updateFilterBox(event.args.item.value); }); // builds and applies the filter. var applyFilter = function (datafield) { $("#jqxgrid").jqxGrid('clearfilters'); var filtertype = 'stringfilter'; if (datafield == 'date') filtertype = 'datefilter'; if (datafield == 'price' || datafield == 'quantity') filtertype = 'numericfilter'; var filtergroup = new $.jqx.filter(); var checkedItems = $("#filterbox").jqxListBox('getCheckedItems'); if (checkedItems.length == 0) { var filter_or_operator = 1; var filtervalue = "Empty"; var filtercondition = 'equal'; var filter = filtergroup.createfilter(filtertype, filtervalue, filtercondition); filtergroup.addfilter(filter_or_operator, filter); } else { for (var i = 0; i < checkedItems.length; i++) { var filter_or_operator = 1; var filtervalue = checkedItems[i].label; var filtercondition = 'equal'; var filter = filtergroup.createfilter(filtertype, filtervalue, filtercondition); filtergroup.addfilter(filter_or_operator, filter); } } // add the filters. $("#jqxgrid").jqxGrid('addfilter', datafield, filtergroup); // apply the filters. $("#jqxgrid").jqxGrid('applyfilters'); } // clears the filter. $("#clearfilter").click(function () { $("#jqxgrid").jqxGrid('clearfilters'); }); // applies the filter. $("#applyfilter").click(function () { var dataField = $("#columnchooser").jqxDropDownList('getSelectedItem').value; applyFilter(dataField); }); });
Choose Column: