Custom filtering

[Katashov DimaParticipant]

Hi!
I want to use your custom filtering. I use this code:

$('#jqxgrid').on('filter', function (event){
				var filterinfo = $('#jqxgrid').jqxGrid('getfilterinformation');
					for (i = 0; i < filterinfo.length; i++) {
						if(filterinfo[i].filtercolumn == 'bu') {//колонкa
							var filter = filterinfo[i].filter.getfilters();
							var value = filterinfo[i].filter.getfilters()[i].value;
						}
					}
					
});

$('#jqxgrid').jqxGrid(column[{ text: 'bu', datafield: 'bu', editable: true, cellsalign: 'center', align: 'center', cellsrenderer: cellsrenderer, pinned: true, filtertype: 'list', filteritems: ['1','0'] ])

How i can set names filteritems ? I want see list with [‘+’,’-‘], but values [‘1′,’0’]. How i can do this ?
Thank you.

[DimitarParticipant]

Hello Katashov Dima,

Do you mean that you want the list to appear as [“+”, “-“] but have actual values of [“1”, “0”]? Unfortunately, this cannot be achieved. What you can do is have cell values “1” and “0” which appear as “+” and “-“ (or vice versa) through cellsrenderer.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Katashov DimaParticipant]

Yes, i use cellsrenderer to take + and – in cells, but in mysql db they are 1 and 0. And filtering work after entering 1 or 0. I want to use custom filter list, which have [1,0] values but look like [+,-].

[DimitarParticipant]

Hi Katashov Dima,

Unfortunately, such functionality is not available.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts