Query Filter

Radzen.Blazor Components
1

Hello I am using a search box to search/load a grid using the IQuery method. I want to load a table using a foreign key and I want to to be able to search through the table. I tried the Data method but it is returning data I do not need. I am attempting to do the following but I am not getting any results back.
Any ideas would be great.

          Query query = new Query()
          {
              Filter = $@"Session_Schedule_FK || i => i.Employee_Name.ToLower().Contains(@0)"
              FilterParameters = new object[] {  args.Session_Schedule_PK, search}
          };
2

You have two parameters however you are using only the first (@0) however your first parameter is not the search string.

3

OK. So would a better implementation be the following:

          Query query = new Query()
          {
              Filter = $@"i => i.Session_Schedule_FK.ToString().Contains(@0) ||
                                (i.Employee_Name.ToLower().Contains(@1)"
              FilterParameters = new object[] {  search = args.Session_Schedule_PK.ToString() , search}
          };

I thought this would work but it did not