Invoke data source method using IN operator with string values as a filter

Hi ,
How to filter the data with a string list when invoking a data source method .

The operations are limited in the list of the designer, using Blazor.

Check title column in these demos:
https://blazor.radzen.com/datagrid-odata
https://blazor.radzen.com/datagrid-loaddata

@enchev Does any of these examples pre-filter the data with a list of string values ?

I'm using the designer . , just want to data to be fetched with only values matching "A", "B" of a database field value.
Skipping after fetching the data is not what I'm looking for.

Tried using Ienumerable pageproperty. and contains like this ( but not working).
image

image

Error: No applicable method 'Contains' exists in type 'String'

@enchev : Sorry : have to change the title of the topic.
I ment Invoke data source method using IN operator as a filter for getting the data from database.

The only other option I can offer you except already posted is to filter like this:

Hi @enchev ,
Does this work with string collections ? hing the error : No applicable method 'Contains' exists in type 'String'.

Would be nice to have more options out of the box to query the data .

Thank you

2 Likes