In the below Northwind example, there is one row per Order, comma separating the Product Names in a second column. How could I go about filtering on the Product Names?
For example, searching "Chang" would filter down to the 44 Orders that have Chang as one of the Products included in the order. However the Products column would still list all other Products included in that Order.
@page "/datagrid-conditional-template"
@using RadzenBlazorDemos.Data
@using RadzenBlazorDemos.Models.Northwind
@using Microsoft.EntityFrameworkCore
@inherits DbContextPage
<RadzenExample Name="DataGridConditionalTemplate" Heading="false" Documentation="false">
<RadzenText TextStyle="TextStyle.H5" TagName="TagName.H3">Orders</RadzenText>
<RadzenDataGrid AllowFiltering="true" AllowPaging="true" AllowSorting="false"
FilterPopupRenderMode="PopupRenderMode.OnDemand" FilterCaseSensitivity="FilterCaseSensitivity.CaseInsensitive"
Data="@orders" TItem="Order" ColumnWidth="200px">
<Columns>
<RadzenDataGridColumn TItem="Order" Property="OrderID" Title="OrderID">
</RadzenDataGridColumn>
<RadzenDataGridColumn TItem="Order" Title="Products">
<Template Context="order">
@foreach (var orderDetail in order.OrderDetails)
{
<div>@orderDetail.Product.ProductName</div>
}
</Template>
</RadzenDataGridColumn>
</Columns>
</RadzenDataGrid>
</RadzenExample>
@code {
IEnumerable<Order> orders;
protected override async Task OnInitializedAsync()
{
await base.OnInitializedAsync();
orders = dbContext.Orders
.Include(o => o.OrderDetails)
.ThenInclude(od => od.Product)
.ToList();
}
}
