Dropdowm column and filter

[alexzMember]

Hi,

I’ve a problem filtering dropdown column. Column has valueMember and displayMember, filter works by valueMamber, but I want it to work by displayMember, which is visible to the user. Same applies to the sort. Is it possible fix somehow? Any help appreciated, thanks!

[Peter StoevKeymaster]

Hi alexz,

In jqxGrid the Filter, Sort, Edit and Grouping work by the column’s ‘datafield’ setting. The column does not have displayMember nor valueMember settings. If you set properties of a column’s editor, they will be valid only for the editor.

Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[alexzMember]

Thanks for prompt reply, but do you have any workaround? It’s quite common, if you have dropdown control it’s value is integer and text is visible to the user. It’s counter-intuitive when you have to sort or filter this column by value you do not see.

[Peter StoevKeymaster]

The sorting and filtering is by the column’s datafield. The cell values depend only on the column’s datafield as well. The dropdown is displayed only when the cell is in edit mode.

Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts