Hi, I have a grid which displays the state names in a column. I want to have a filter on that column that will filter based on the state code. The state code comes from a reference data. Please advice.
Below is my stackblitz link:
https://stackblitz.com/edit/react-byhjeb-oe3mkm
If I type in "md", maryland and states which startswith 'md' should be filtered.
3 Answers, 1 is accepted
Hello, Arun,
Thank you for your example.
As the Grid filter row can work only with a single filter per column, I can suggest adding the second filter just before rendering.
This can be achieved by taking the filter value to see if it matches the reference data and if it does to add an extra filter field.
I updated the example to showcase this:
https://stackblitz.com/edit/react-byhjeb-xf7lc5?file=app%2Fmain.jsx
I hope this is helpful.
Regards,
Stefan
Progress Telerik
Rank 1
Hi Stefan,
thank you for the example. It works as expected. But if I try to filter on other columns, it fails. Can we add this filter Functionality only for the particular column? Please advice.
Hello, Arun,
I tested the example when filtering by another column and it was working as expected.
As the filter logic is or this will filter data if the name is "Maryland" or the ID is 3.
Let me know if I missed something.
Regards,
Stefan
Progress Telerik