Dropdowndatagrid loads all the records

Radzen Studio Blazor Server
21

Thank you Vladimir! It is working now

BTW, the filtering for the enums in the datagrid is almost useless as a numeric control is displayed. However, usually the enum fields are the most important ones to filter by.

Is there any chance to implement a dropdown for filtering enums (using Enum.GetValues and EnumGetNames you can easily fill the dropdown).

If not, if you can create:

  • A virtual method in RadzenGridColumn where you put the default code for Type/Format inference for the RadzenGrid Grid cascading parameter
  • A virtual method In RadzenGrid that you call from BuildRenderTree to render the filter for column types you do not support.

That would allow the user to customize the filters without much effort on your side.

22

In the next version you will be able to do like this:

@page "/datagrid"

<RadzenExample Name="DataGrid">
@if (employees == null)
{
    <p><em>Loading...</em></p>
}
else
{
    <RadzenGrid Data="@(employees.Where(e => e.TitleOfCourtesy == currentTOC))" 
                AllowFiltering="true" AllowPaging="true" AllowSorting="true" TItem="Employee" ColumnWidth="200px">
        <Columns>
            <RadzenGridColumn TItem="Employee" Property="ID" Title="ID" />
            <RadzenGridColumn TItem="Employee" Property="Name" Title="Name"/>
            <RadzenGridColumn TItem="Employee" Property="TitleOfCourtesy" Title="Title Of Courtesy">
                <FilterTemplate>
                    <RadzenDropDown @bind-Value="@currentTOC" TextProperty="Text" ValueProperty="Value" Style="width:100%"
                                    Data="@(Enum.GetValues(typeof(TitleOfCourtesy)).Cast<TitleOfCourtesy>().Select(t => new { Text = $"{t}", Value = t }))" />

                </FilterTemplate>
            </RadzenGridColumn>
        </Columns>
    </RadzenGrid>
}
</RadzenExample>

@code {
    public enum TitleOfCourtesy
    {
        Ms,
        Mr,
    }

    public class Employee
    {
        public int ID { get; set; }
        public string Name { get; set; }
        public TitleOfCourtesy TitleOfCourtesy { get; set; }

    }

    IEnumerable<Employee> employees;
    TitleOfCourtesy currentTOC;

    protected override async Task OnInitializedAsync()
    {
        employees = await Task.FromResult(Enumerable.Range(0, 10).Select(i =>
            new Employee
            {
                ID = i,
                Name = $"Name{i}",
                TitleOfCourtesy = i < 5 ? TitleOfCourtesy.Mr : TitleOfCourtesy.Ms
            }));
    }
}

image
image.png1920×1080 108 KB

23

Thank you very much Vladimir!!!

24

Here is the demo with just released update of Radzen.Blazor:
https://blazor.radzen.com/datagrid-filter-template

25

Great!. I'm impatient to try it!

26

Vladimir, it looks like the hierarchical datagrids are broken:

Look at the column filters. They are shifted one position to the left.

The filter template seems to work fine. However, in your example, you were binding to an external variable. What I really want is to create a derived class from RadzenGridColumn to handle all enum filtering automatically, even if I have to create the FilterTemplate using a RenderTreeBuilder. In order to do that, I want to filter by the column's FilterValue. As the FilterValue is of type object, it does not go well binding it to other controls with properties that are not of object type.In that case, I have to split the @bind-Value attribute in the two parts:

<FilterTemplate Context="data">
   <OptionalEnumField TEnum="BusinessPartnerStatus" Value="@((BusinessPartnerStatus?)data.FilterValue)" ValueChanged="@((args) => OnEnumFilterChanged(data, args))" ShowLabel="false" />
</FilterTemplate>

The OptionalEnumField component sets up a RadzenDropDown with the enum data.

And the implementation of OnEnumFilterChanged is:

protected async Task OnEnumFilterChanged(RadzenGridColumn<BusinessPartnerDto> column, BusinessPartnerStatus? value)
{
    var col = column as RadzenGridColumnEx<BusinessPartnerDto>;
    if (col != null) {
        col.SetFilterValue(value);
        col.Grid.Reload();
    }
}
</FilterTemplate>

I had to subclass the RadzenGridColumn to add the SetFilterValue method because assigning the FilterValue directly gives me this warning and it didn't work:

Component parameter 'FilterProperty' should not be set outside of its component

But having the SetFilterValue method in the RadzenGridColumn would be better:

public void SetFilterValue(object value)
{
    FilterValue = value;
}
27

Hierarchical grid will be fixed as for the filter template for columns this is the best we can offer for now.

28

Vladimir, the current filter templates are great as they're now. I was able to create my EnumGridColumn that does automatic filtering without any coding in the datagrid that uses them.

The only thing I missed was the SetFilterValue method in the RadzenGridColumn, for an usage that does not imply creating your column derived from RadzenGridColumn, but that is an easy thing to overcome.

29

Hello Vladimir,

the same project fails in Radzen Blazor 2.18.6 when you select an item from the RadzenDropdownDatagrid:

'''
[2020-12-17T15:02:57.176Z] Error: System.NotSupportedException: Unable to cast the type 'BlazorRadzenTests.Country' to type 'System.Object'. LINQ to Entities only supports casting EDM primitive or enumeration types.
at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.ValidateAndAdjustCastTypes(TypeUsage toType, TypeUsage fromType, Type toClrType, Type fromClrType)
at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.GetCastTargetType(TypeUsage fromType, Type toClrType, Type fromClrType, Boolean preserveCastForDateTime)
at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.CreateCastExpression(DbExpression source, Type toClrType, Type fromClrType)
at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.CastMethodTranslator.Translate(ExpressionConverter parent, MethodCallExpression call)
at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.SequenceMethodTranslator.Translate(ExpressionConverter parent, MethodCallExpression call, SequenceMethod sequenceMethod)
at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.TypedTranslate(ExpressionConverter parent, MethodCallExpression linq)
at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TypedTranslator1.Translate(ExpressionConverter parent, Expression linq) at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq) at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.Convert() at System.Data.Entity.Core.Objects.ELinq.ELinqQueryState.GetExecutionPlan(Nullable1 forMergeOption)
at System.Data.Entity.Core.Objects.ObjectQuery1.<>c__DisplayClass41_0.<GetResults>b__1() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
at System.Data.Entity.Core.Objects.ObjectQuery1.<>c__DisplayClass41_0.<GetResults>b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func1 operation)
at System.Data.Entity.Core.Objects.ObjectQuery1.GetResults(Nullable1 forMergeOption)
at System.Data.Entity.Core.Objects.ObjectQuery1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__31_0() at System.Data.Entity.Internal.LazyEnumerator1.MoveNext()
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Radzen.DataBoundFormComponent1.get_View()
at Radzen.DropDownBase1.SelectItem(Object item, Boolean raiseChange) at Radzen.Blazor.RadzenDropDownDataGrid1.OnRowSelect(Object item)
at Microsoft.AspNetCore.Components.ComponentBase.CallStateHasChangedOnAsyncCompletion(Task task)
at Radzen.Blazor.RadzenGrid`1.OnRowSelect(TItem item, Boolean raiseChange)
at Microsoft.AspNetCore.Components.ComponentBase.CallStateHasChangedOnAsyncCompletion(Task task)
at Microsoft.AspNetCore.Components.RenderTree.Renderer.GetErrorHandledTask(Task taskToHandle)
'''

30

I already told you that we can't help without a reproduction. Opening new threads or reviving old ones won't do any good.

31