Filtering in JQX Grid

[aneeshmmParticipant]

Hi Team,

Is it possible to load the data appearing in the filter list-box from an external data source other than the actual items existing in the grid for that column? We are using the excel like filtering.

Ex: Say we have a grid like shown below. In normal scenario the filter values for Fruits column would be a checkbox list with values ‘Apple’, ‘Orange’, ‘Pineapple’, ‘Apple Guava’
The requirement is to have ‘Apple’, ‘Orange’, ‘Pineapple’, ‘Guava’, ‘Grapes’, ‘Pomegranate’ (These values will be present in a JSON or Array format in the page)

Fruits Color

Apple Red
Orange Orange
Pineapple Yellow
Apple, Guava Green

Thanks,
Aneesh

[DimitarParticipant]

Hello Aneesh,

You need to set the column’s filteritems property. Here is an excerpt from the jqxGrid API Documentation about it:

filteritems – sets the items displayed in the list filter – when the “showfilterrow” property value is true and the filter’s type is “list” or “checkedlist”. The expected value is Array or jqxDataAdapter instance.

Best Regards,
Dimitar

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

[aneeshmmParticipant]

Thank you Dimitar… I’ll give it a try

[Author]

Posts