Access DataGrid rows after filters are applied

Hi.
I'm building an "Export-to-excel" method using Radzen in a Blazor WebAssembly app, and I cannot access the rows after filters are applied. Is there any way of doing this? Or perhaps accessing the filters as Linq Expressions (I only found them as string)?

The data (Model) comes from an API call.

Some code:

<RadzenSplitButton Text="Export" Click="@((args) => OnExportBtnClick(args))" Icon="account_circle" >
    <ChildContent>
        <RadzenSplitButtonItem Text="Excel" Value="1" Icon="account_box" />
        <RadzenSplitButtonItem Text="csv" Value="2" Icon="account_balance_wallet" />
    </ChildContent>
</RadzenSplitButton>
<RadzenGrid @ref="thegrid" AllowFiltering="true" FilterCaseSensitivity="FilterCaseSensitivity.CaseInsensitive" AllowPaging="true" PageSize="4"
            AllowSorting="true" Data="@Model" TItem="TheEntity" ColumnWidth="200px" RowDoubleClick="@(args => OnRowDoubleClick(args))">
    <Columns>
        <RadzenGridColumn TItem="TheEntity" Property="UniqueId" Title="UniqueId" Filterable="false" />
        <RadzenGridColumn TItem="TheEntity" Property="Name" Title="Name" />
        <RadzenGridColumn TItem="TheEntity" Property="Email" Title="Email" />
        <RadzenGridColumn TItem="TheEntity" Property="LifeCycleStatus" Title="Life Cycle Status" />
    </Columns>
</RadzenGrid>


@code {
    [Parameter] public IEnumerable<TheEntity> Model { get; set; }
    private RadzenGrid<TheEntity> thegrid { get; set; }

    public void OnExportBtnClick(RadzenSplitButtonItem item)
    {
        var theList = thegrid.Data; // same as Model
        var theFilter = thegrid.Query.Filter; // the filter as sting

    }
}

You can use .View - check the first column footer in this demo:
https://blazor.radzen.com/datagrid-footer-totals

2 Likes

Thank you! Problem solved.

I wonder why the View property wasn't listed here: https://www.radzen.com/documentation/blazor/datagrid ...

Thanks for pointing it - we will add it.