setFilters on legacy table does not work, but manually filtering does

Hello,

I am trying to filter a table using an event handler: below is the code for the event handler.

image

When running the code the table filter is registered but the table returns "no rows found". The filter produced through the event handler looks like below, which looks correct to me. And if I manually type in exactly the same, the filter will work and rows will show up.

image

I am aware that my data for the table is loaded in as string, even though it is set as decimal in the database. I have also tried float, where the data was loaded as such, but nothing seems to fix the problem.

image

I appreciate any help I can get to solve this :blush:

Hi @rikkesborup It looks like you need to use lessThanOrEqual instead of less than or equals as your operator

:crossed_fingers: Hope that resolves it!

For other operators, you can add it to the table using the filter UI, and then check the state for the table to see what the operator is called:
image