RadzenDataGrid DateTime filtering fails with Npgsql and 'timestamp with time zone' fields

Radzen.Blazor Components
1

I’m having trouble with adapting a solution from this thread

RadzenDataGrid DateTime filtering fails with Npgsql and 'timestamp with time zone' fields · Issue #2315 · radzenhq/radzen-blazor

<RadzenDataGridColumn Property="CreatedOn" FilterProperty="CreatedOn" Title="@SR.Get("Created On")" Width="auto" SortOrder="SortOrder.Descending">
    <FilterValueTemplate>
        <RadzenDatePicker TValue="DateTime" Kind="DateTimeKind.Utc" DateFormat="dd.MM.yyyy"
                          Value="@(context.FilterValue)" Name="CreatedOn" />
    </FilterValueTemplate>
    <Template Context="item">
        @item.CreatedOn.Show("dd.MM.yyyy HH:mm")
    </Template>
</RadzenDataGridColumn>

I had to specify TValue="DateTime", however @bind-Name="CreatedOn" doesn’t work, there is no CreatedOn in the context.

The filter for CreatedOn is not sent to server with the code above.

I’m using a rather old version of Radzen 5.5.2

Thanks

2

Hmm .. the code in the example was not correct - here is the correct version:

<RadzenDataGridColumn TItem="PGServerTestDB.Models.TestDB.MyTable" Property="Time" Title="Time">
    <FilterValueTemplate>
        <RadzenDatePicker Kind="DateTimeKind.Utc" DateFormat="MM/dd/yyyy" style="display: block; width: 100%" @bind-Value="@(context.FilterValue)" Name="Time" />
    </FilterValueTemplate>
</RadzenDataGridColumn>

I’ve fixed also my original example.