DataGrid Filter

Hi

Can someone direct me how to apply a filter for the data loaded into a DataGrid.
When editing the expression it does not allow me to add a Where clause like .Where(x => x.id > 10)

Currently the Data is linked to : ${getSitesResult}

Thanks

Xarion

Set the filter to expression ${FilterString}
FilterString = "id>=10";
Fire the data source method again and set the getsitesresult

HI Vinod

Currently I only have the following filter options when I click on the grid:

image

Add the filterstring in your datasource method
image

1 Like

LIke this?

Its working, thank you

Unfortunately doing this solution has stopped the search bar from working. How can I modify the filter statement to include what was typed. I dont see any action on the "onChange" event of the search toolbox.

Go back to the version were search worked, and add the new filter to the existing search filters in the query builder. Query builder (Blazor) (radzen.com)

set ${FilterString} to ${search}+${FilterString}

where ${search} is your previous search string.

I realised its actually lot easier, I saw that the filter was actually port of a bigger expression, then just added the TypeID filter at the end...

image

Thanks for the help @SloSuenos and @Vinod_Pillai

2 Likes