How can I filter RadzenGrid advanced with condition "or"?

Radzen.Blazor Components
1

Hi,
I watched https://blazor.radzen.com/datagrid-multiple-selection, but didn't get the answer.
How can I filter RadzenGrid with advanced filter with condition "or" ?
I need this condition "where LastName='Davolio' or Firsname='Andrew' ". I need to see 2 Employees in the grid.

2

Hi @Lina_Kalibatiene,

You can select it from the fltering menu:

image
image1920×1080 309 KB

5

But your condition "where LastName like 'D' or LastName like 'O' ". You filter is in the same field.
It's not the same when "where LastName='Davolio' or Firsname='Andrew' " I need to filter in different fields.

6

You are right. This is not possible in the current version however I've just pushed new property for the DataGrid that can be used to specify the logical operator between columns:

<RadzenGrid LogicalFilterOperator="LogicalFilterOperator.Or" ...

image
image1920×1080 215 KB

It will be released with our update tomorrow.

1 Like