How to fill filterrow with all possible values for that specific column

[pingalaParticipant]

Hi there,

I’m using jqxGrid integrated with a PHP script, via JSON. I’ve implemented the filters, orders, paging and have added the filterRow on a couple of columns.

Now my problem is that the filterRow contains only the values from the current page while I want it to show the value from the whole dataset. I understand this might not be possible due to the way the system is designed, however is there a way to preLoad a specific filterRow with a certain query ?

For instance I’ve a grid with a list of users, showing ID – Name – Permission – Email
I’ve the filterRow on the Permission column which will contains a specific list of strings (permission table in the dbase which doesn’t change much over time and it’s quite short). I would like the filterRow to show all possible permissions and not only the one showing on the first page of the grid so if I select one it will filter the whole dataset based on it.

I hope I’ve explained this clearly. If not ask away.

Thanks

[DimitarParticipant]

Hello pingala,

You can achieve this by populating the column’s filteritems property, as in the demo Filter Row & Custom List Items.

Best Regards,
Dimitar

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

[pingalaParticipant]

Hi Dimitar,

thanks for your fast response. It worked perfectly!!

Cheers
T.

[Author]

Posts