EasyQuery · scenario

DATA FILTERING

A filter bar over any list in your .NET app — filters your users set up themselves.

Data filtering with EasyQuery

THE PROBLEM

"Can you add a filter by…?"

Whenever you show a grid with more than a few rows, your users need to filter it. Usually you don't know exactly how: by customer, by date, by amount, by all three at once. So you guess, add a few filter fields, and wait for the next request.

Let them use EasyQuery and relax. Users add the conditions they need right above the list, press Apply, and the list shows what they asked for.

The data filtering demo

WHAT YOUR USERS GET

  • A compact filter bar over the list they already use
  • Conditions such as "Customer country is USA" or "Freight is greater than 100", in plain language
  • Any combination of conditions, applied with one click
  • Paging of the filtered result

HOW IT FITS YOUR STACK

The whole server side can be one call. MapEasyQuery adds the EasyQuery API, and UseEntity builds the data model from your entity class and applies the users' filters to your own Entity Framework IQueryable — so anything you already restrict in that query stays restricted.

No controllers, no SQL: EasyQuery turns the filter into LINQ.

builder.Services.AddEasyQuery();
...
app.MapEasyQuery(options => {
    options.Endpoint = "/data-filtering";
    options.UseEntity(manager => manager.Services
        .GetRequiredService<AppDbContext>()
        .Orders
        .Include(o => o.Customer)
        .AsQueryable());
});

RUN THE SAMPLE

The same scenario as a project you can open in Visual Studio and run on your machine:

Step by step: getting started with ASP.NET Core.

TRY IT ON YOUR OWN DATA

Get the sample for your platform, connect it to your database, and filter your own lists.

HAVE MORE QUESTIONS?

Don't hesitate to contact us; we are eager to assist with any inquiries.