I have a scenario where an API I'm using is only able to filter by one column at a time. So either name, or email, or phone number, stuff like that.
How can I prevent multiple filters being set at the same time?
I tried binding a mousedown handler to the filter button in the filter menu and iterating over the existing filters to set them to an empty string. Something like this, which I found here on the forums:
This triggered several ajax calls though with filters like "Name~undefined~''".
Is there a better way to handle this scenario?