Hi i have this use case:
i got a filter named: Salary theres any chance to use operators inside text input >< = number like > = 1000 and it should query salary >= 1000. I know table have a filter toolbar, but im using server side pagination, so i cant use those filters, any chance i can use that directly to the text input?
Hey @agaitan026! There are a couple of options here.
- Filter the current table data that has been fetched already. This will use a JS query to filter based on the text input and does everything client side.
- Re-trigger the underlying data query with the text input filters applied.
For #1, something like this should work:
Clear Filter Script:
For #2 it depends on the data query and how filters can be applied to it, but likely something similar to parse the text input value.
I can use that function for only that filter salary? And keep the others as it?
That's an example of how to parse a text input and filter a specific column. You can modify it however you need to achieve the functionality you are looking for.