DropDownDataGrid: Filtering over multiple columns

Radzen Studio Blazor Server
1

I was looking for filtering over multiple columns in a DropDownDataGrid control and found this posting:
DropDownDataGrid with multiple columns - Radzen IDE (Blazor server-side) - Radzen

The name of this property implies that only string columns can be searched. I have a lookup table that shows "Customer ID" (a number) and "Customer Name" (a string) columns. Is there a way that I can use this control to search on both for "Customer Name (works)" and/or "Customer ID" (does currently not work)?

Thanks for your ideas!

2

Searching string on numbers is not possible.

3

Ok, thanks. I was hoping I could do some kind of casting the number to string but you seem to use EF in the background for the search operation so this will certainly not work. Anyway, thanks!