I am working on an application that the client has just added additional filter criteria beyond what grid filter provides.
I believe I might be able to do this using the example here Create Filter Widgets with Multiple Filter Criteria | Kendo UI Grid for jQuery | Kendo UI for jQuery (telerik.com) - maybe. I'm using ASP.Net Core 5 Razor pages so sometimes examples don't always work.
All of the fields (except for a couple that are date fields) are char or text type columns in the database. The client wants to be able to use functions like "greater than", "in", and "Is one of". (I know greater than is not going to give them what they think) but the In condition or the Is One of condition they say are needed.
The filter now for 2 items is not enough.
For example, they need to filter for several POs at once - as you might do with a sql query SELECT * FROM tableaname WHERE fieldname in ('po1', 'po1', 'po3', 'po4') as an example. none of the data is sequential so the need for "IN" or "IS ONE OF" filtering conditions.
Is this possible?
How would it be coded and handled on the backend?
Are the available filters documented somewhere here on the site?
Can we use wild cards in the filter value? As when the search condition may vary inside the string and not with the start or end with characters?