grid checkedlist filter and inner join

[deanosParticipant]

Hi,
I’m building a simple lead system with jqxgrid which contains the following columns:
name | fname | country | phone …

my problem is that the data of the country column comes from a Junction table, when i filter with the checkedlist, it sends the country name instead of the ID.
is there any way to store key and value?
i couldn’t find an answer here (i tried using ‘formatData’ with no success).

Another problem is that i need to get all checked countries as string, for example: uk,usa,ru.
instead i get filtervalue0:”uk”,filtervalue1:”usa”,filtervalue2:”ru”…
with “AND” operator which in this case “IN” operator is needed (ןn terms of performance).

Thank you very much.
Dean

[Peter StoevKeymaster]

Hi dean,

Unfortunately, there’s currently no option to store key and value in the CheckedListFilter. Also it’s not possible to get the checked items as String. The Grid adds all filter value parameters in the same way. For changing the Grid’s formatting, you can use only the formatData callback function of the dataAdapter and to get the filtering information, you can use the getfilterinformation method.

Best Regards,
Peter Stoev

[Author]

Posts