Filtering for columns displayed using cellsrenderer is not happening in jqxGrid

[satheesh.r11Participant]

When i tried to use filtering for jqx grid, the below things happen
1) Filtering works fine for columns which are displaying data directly from json object.
2) Filtering is not working for columns which are displayed using cellsrenderer.

Please provide suggestion for doing filtering for columns which uses cellsrenderer for displaying data.

[Peter StoevKeymaster]

Hi satheesh.r11,

Filtering, filters the Cells by their Data Values, not by what HTML is displayed within the cells. “cellsrenderer” overrides the display, but it does not override the cell values.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[jignyasaParticipant]

Is it possible to have a work around for this issue?
Say the datasource itself will have the modified value or something. Or any other way how i can use the visible cell value for filtering?

Thanks,
Jignyasa

[Peter StoevKeymaster]

Hi Jignyasa,

The filtering works by Cell Value, not by HTML. That’s how it works.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[jignyasaParticipant]

Hi,
Thanks for the response.

Yes, i understood that cell value dictates the filter functionality. So it is possible that, when I’m defining the data source, I apply some modification to it, so that it becomes the cell value? As I do not want to change the base json.

eg:

var source =
{
localdata: data.countData,
pagesize: 20,
datafields:
[
{ name: ‘Subject’, type: ‘string’ },
{ name: ‘Counttype1’, type: ‘number’ }, // say some modification here so that it applies to the field and is actually considered cell value.
{ name: ‘counttype2’, type: ‘number’ },
{ name: ‘AFoundCount’, type: ‘number’ },
{ name: ‘BFoundCount’, type: ‘number’ },

],
datatype: “array”
};

OR if the filter functionality can be customized for only particular columns?

Thanks,
Jignyasa

[Peter StoevKeymaster]

Hi Jignyasa,

Why would you modify the source object? The filtering works with the data loaded through the data adapter. Look at the online filtering demos, please.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts