DropDownDataGrid - How to enable filter on more than one column

Thomas_Adrian · May 31, 2024, 1:03pm

I do not seem to be able to filter based on values in more than one column.
I have tried different combinations with AllowFiltering and AllowFilteringByAllStringColumns

what is the trick to enable filtering based on more than one column.
lets say I have "1" in column 1 and "Acme" in column 2, I want to use "1" or "Acme" to filter

go to Blazor DropDownDataGrid Component | Free UI Components by Radzen
go to the Define multiple columns

korchev · May 31, 2024, 1:17pm

Hi @Thomas_Adrian,

Filtering works only in string columns. Are your columns string or are they numeric?

Thomas_Adrian · May 31, 2024, 1:18pm

have you tried it on the links I provided?
I have tried to add 1 int column and 2 string columns and only one of the string columns is filterable

when I talke to GPT AllowFilteringByAllStringColumns="true" means that it only filter by string columns, but I have tries to set that to false and also remove it without success

korchev · May 31, 2024, 1:21pm

Here is what I see in our demo:

multiple-columns

I can filter by values in all string columns.

Thomas_Adrian · May 31, 2024, 1:37pm

ok, thank you for your gif.

I need to investigate more, maybe my problem is because I have swedish characters and some rows are empty, or that I have too much data. it was about 10.000 rows. or maybe it does not work if one of the columns is an int

I get a circute error if I move to last page in dialog and back again.

thanks again, at least now I know it should works.