Advanced Filtering Not working

[SumitRoyParticipant]

Hi JQX,
I have a jqx data table with advanced filtering feature turned on, but one of my field is type of double

{text: 'Install TSN(Hrs/Cycles)', dataField: 'installTimeSinceNew', align: 'center', cellsAlign: 'left', columngroup: 'PartHistory', width: 200, cellsFormat: 'f2'},

now when I click on advanced filtering option instead of number comparing, standard string comparing options are coming in the combo boxes as
empty
not empty contains
contains
contains (match case)
….

which is supposed to be
equal
not equal
less than or equal

sample image is

[ChristopherParticipant]

Hi SumitRoy,

You need to set the type of the column to “number” in your “source” parameter in order for the filtering to be applied properly. Here is an example:
https://www.jseditor.io/?key=xb-datatable-fitlering

Best Regards,
Christopher

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts