loadstate with filter problem

[Chad RandallParticipant]

I have a small problem. When loading a grid state, and there is a filter as “>200”, the filter textbox is loaded with “200” (with GREATER_THAN behind). The filter appears to work fine. But when another filter is changed, the original is now set to “EQUALS”, probably because the textbox was set to “200” instead of “>200”.

Grid with “Excel” filters on top {showfilterrow: true}
set filter1 (number) to “>200” (textbox)
savestate
loadstate
filter1 shows up as “200”, but filter is working like GREATER_THAN
“okay” up to this point, as the correct data is shown
set filter2 to “X”
filter1 now works like “EQUAL” 200.

I did not try this with “<200” or “<>200”, but I suspect the same problem occurs.

[DimitarParticipant]

Hello Chad Randall,

We suggest you set the column’s filtertype to ‘number’ and select the filter condition from the dropdown next to the filter input. This way, the issue will not occur.

Best Regards,
Dimitar

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

[Singh_kiatecParticipant]

Hi Team,

I am using angular and the load state works perfectly fine with dropdown filter and text but not with the date range . Am i missing something?

Screen shot
https://pasteboard.co/JwwSZYe.png

jqwidgets version : 10.1.5

Example of state object.
columns: {levering: {…}, organisation_uuid: {…}, bruger_uuid: {…}, navn: {…}, brugernavn: {…}, …}
filters:
filtercondition0: “GREATER_THAN_OR_EQUAL”
filtercondition1: “LESS_THAN_OR_EQUAL”
filterdatafield0: “levering”
filterdatafield1: “levering”
filteroperator0: 0
filteroperator1: 0
filterscount: 2
filtertype0: “datefilter”
filtertype1: “datefilter”
filtervalue0: “20-10-2020 00:00:00”
filtervalue1: “20-10-2020 23:59:59”
leveringoperator: “and”

Thanks in advance.

[HristoParticipant]

Hello Singh_kiatec,

Please, take a look at this example:
https://stackblitz.com/edit/github-3htnn5?file=src/app/app.component.ts

Best Regards,
Hristo Hristov

jQWidgets team
https://www.jqwidgets.com

[Author]

Posts