RadzenDataGridColumn enum filter not working without single quotes

Radzen.Blazor Components
1

I'm using a custom data grid column filter template with dropdown that is an Enum type. The filter string for LoadDataArgs looks like 'Status eq CheckedOut'. My web api throws an error trying to map CheckedOut as a property and not an enum value. If I surround CheckedOut in single quotes, it works just fine.

According to OData specifications, the enum value in the filter string should be surrounded by single quotes. Is this custom code I need to write to do this from in the blazor app or does the data grid component provide some sort of extension method to do this?

Status is the property on the model for the data grid. CheckedOut is the Enum name.

Here's the column component code.

<RadzenDataGridColumn TItem="StudyVersionViewModel" Property="@nameof(StudyVersionViewModel.Status)" Title="Status" FilterValue="@FilteredStatus">
         <FilterTemplate>
                        <RadzenDropDown @bind-Value="@FilteredStatus" Style="width:100%;" TValue="VersionStatus?"
                                        Data="versionStatus"
                                        AllowClear="true" TextProperty="DisplayName" ValueProperty="Status" />
         </FilterTemplate>
</RadzenDataGridColumn>

Request query string
image

Other filter types (string, int) work just fine.

Let me know if you need to know anything else.

2

Hi @Griff,

Fix for this will be released later today!

1 Like
3

Thanks for the quick reply. Looking forward to the update!

4

It’s already released.

5

Thanks, Enchev for the update. Which nuget package do I need to update? I updated to latest Radzen.Blazor nuget package (4.7.10), but I'm still seeing the issue. Do I need to change my code in any way for this fix to know the type of the column?

6

Yes, this is the package and here is the fix:

You can attach the source code of Radzen.Blazor to your project to debug why it fails.

7

Thanks, @enchev. I see the Filter from LoadDataArgs has not changed.
image

The ToODataFilterString extension method is still returning the same string as well.

image
image940×59 7 KB

Even though I see that in the ColumnsCollection, the FilterPropertyType IsEnum flag is set to true.
image

Any ideas?

8

Maybe if it's nullable enum this will help:

Have you tried to debug it as I suggested?

9

Ah, I see. Let me try

10

@enchev I found the problem. The FilterPropertyType is also coming back as numeric for the Enum type, so the IsNumeric condition is being met first. When I switch the conditions locally, the Enum filter was returned correctly, and my API call went through successfully.

image

The IsNumeric method is returning true because GetTypeCode returns Int32 for Enum.

See this https://stackoverflow.com/questions/124411/using-net-how-can-i-determine-if-a-type-is-a-numeric-valuetype/31709198#31709198

11

Thanks @Griff! We will publish update tomorrow!

1 Like
12

@enchev What's the status of this fix? I see 4.7.11 was released with an OData enum filtering fix. Does that address this issue?

13

Hey @Griff,

You can monitor commits and what is included in the release:

14

@enchev I see thanks. Looks like it is addressed. Thanks. I'll verify.

15

@enchev Verified the issue has been fixed. :+1: