Question Can't make dynamic filter based on Query. Filter on radzen data grid ?

[ahmedaziz]

I work on blazor server side .asp.net core 7 . I face issue I can't return data after filter from list on Radzen data grid

First I create radzen data grid on razor page

<RadzenDataGrid @ref="myDataGrid"  AllowColumnPicking="true" FilterMode="FilterMode.Simple" AllowFiltering="true" PageSizeOptions="@PagingOptions" FilterCaseSensitivity="FilterCaseSensitivity.CaseInsensitive"

                                                data="@databaseData" >

second I create list that receive data after filter

private IEnumerable<CopyExcelDatabaseClass> databaseData = Array.Empty<CopyExcelDatabaseClass>();



    public class CopyExcelDatabaseClass

    {

    

        public string databaseName { get; set; }

        public int ServerID { get; set; }

        public string ServerName { get; set; }

        public string Severity { get; set; }





    }

third function is filter list based on dynamic condition get it from myDataGrid.Query.Filter

public void getListDataAfterFilter()

{

 var query = myDataGrid.Query.Filter;

 var filteredList = databaseData.Where(query).ToList();

}

this statement return condition Filter from radzen data grid after write filters

var query = myDataGrid.Query.Filter;

return below filter condition

(databaseName == null ? "" : databaseName).ToLower().Contains("Menna".ToLower()) and (serverity == null ? "" : serverity).ToLower().Contains("Mon".ToLower())

I try to get result from above and it worked fine

var filteredList = databaseData.Where(item => item.databaseName.Contains("DB_U")).ToList();

but issue it static and I need it dynamically meaning based on condition filter Query.Filter

 

[Skydiver]

But this code already does it dynamically from the data grid:

var query = myDataGrid.Query.Filter;
var filteredList = databaseData.Where(query).ToList();

 

[ahmedaziz]

But this code already does it dynamically from the data grid:
so what this mean and How to solve issue please

 

[Skydiver]

It means that you are already doing what you are trying to achieve: dynamically getting the query filter.

 

[ahmedaziz]

No
on here
var filteredList = databaseData.Where(query).ToList();
i need to filter list databaseData based on condition on query variable and after that return list of data filtered

 

[Skydiver]

And that is exactly what is happening on that line of code.

i need to filter list databaseData

Which is what

databaseData.Where(...)

based on condition on query variable

which is what this does:

databaseData.Where(query)

and after that return list of data filtered

which is what this does:

var filteredList = databaseData.Where(query).ToList();

 

[Skydiver]

Oh. I see now. You never mentioned that the code doesn't compile. Or at least I'm guessing it doesn't compile based on the Radzen documentation regarding Query.Filter returning a string.

Time to learn about C#'s expression trees:

Expression Trees

Learn about expression trees. See how to compile and run code represented by these data structures, where each node is an expression.

learn.microsoft.com