Grid filter row server side data

The Awesome Grid allows you to filter its data using editor elements inside a filter row in the header of the grid.
Filter components are textboxes by default but other editors like dropdowns, numerics, etc. and custom ones can be defined.

Filter row using server side data filtering, all the data filtering, sorting, paging is done on the server.
Clicking the grid reset button will also reset all the filters.
The Food Column filter DropdownList will load its data independently of the grid data request and because it has FilterNoReload it will do that only on the first grid load.
Country, Meals, and Chef Columns filters get their data from the Grid data result, so on each grid load (page, sort, filter change) their data will be updated, advantage being that we can limit the filter DropDownList items to only the ones present in the current grid data.

Demos/Grid/GridFilterRowServerSideDataController.cs

public async Task<IActionResult> LunchFilterGrid(GridParams g, LunchFilter filter)
{
    var query = mcx.Lunches
        .Include(o => o.Food)
        .Include(o => o.Chef)
        .Include(o => o.Country)
        .Include(o => o.Meals)
        .AsQueryable();

    var filterBuilder = new FilterBuilder<Lunch>
    {
        Filter = filter,
        Query = query
    };

    filterBuilder
        .StringFilter(nameof(LunchFilter.Person))
        .NumericOpFilter(nameof(LunchFilter.Price))
        .DateOpFilter(nameof(LunchFilter.Date))
        .Add(nameof(LunchFilter.Country), new FilterRule<Lunch>
        {
            Query = o => o.Country.Id == filter.Country,
            GetData = async q =>
            {
                return (await q.Select(o => o.Country).Distinct().ToArrayAsync())
                .Select(o => new KeyContent(o.Id, o.Name));
            }
        })
        .Add(nameof(LunchFilter.Chef), new FilterRule<Lunch>
        {
            Query = o => o.Chef.Id == filter.Chef,
            GetData = async q =>
            {
                return (await q.Select(o => o.Chef).Distinct().ToArrayAsync())
                    .Select(o => new KeyContent(o.Id, o.FullName));
            }
        })
        .Add(nameof(LunchFilter.Food), new FilterRule<Lunch>
        {
            Query = o => o.Food.Id == filter.Food,
            // no need for data,  Url set in the view for the Food DropdownListOpt
        })
        .Add(nameof(LunchFilter.Meals), new FilterRule<Lunch>
        {
            QueryFunc = () =>
            {
                var ids = filter.Meals;
                var count = ids.Count();
                return o => o.Meals.Count(m => ids.Contains(m.Id)) == count;
            },

            GetData = async q =>
            {
                return (await q.SelectMany(o => o.Meals).Distinct().ToArrayAsync())
                    .OrderBy(o => o.Id)
                    .Select(o => new KeyContent(o.Id, o.Name));
            },

            // get data after querying this time,
            // to filter the meals in GetData by previously selected meals
            SelfQuery = true
        });

    query = await filterBuilder.ApplyAsync();

    var gmb = new GridModelBuilder<Lunch>(query, g)
    {
        KeyProp = o => o.Id,
        Map = MapToGridModel,
        Tag = filterBuilder.GetGridData()
    };

    return Json(await gmb.EFBuildAsync());
}

Comments