EasyQuery · scenario

ADVANCED SEARCH

One query builder instead of a screen full of search fields.

Advanced search with EasyQuery

THE PROBLEM

"Can I search by this field too? And by these two, but only when…"

Your users need to search by many different parameters, in various combinations. The usual search form is a mess of controls, one per database field. It takes the whole screen and still doesn't cover the combinations people ask for, so each new request means a new field, a new query and a new release.

The EasyQuery interface is simple and intuitive: users build almost any combination of conditions they could wish for, on any field you allow, and you stop adding search fields.

The advanced search demo

WHAT YOUR USERS GET

  • Conditions in plain language: "Customer country is USA and Order date is in the last quarter"
  • AND / OR groups, nested as deep as they need
  • Their choice of result columns, sorting and paging
  • Export of the result to Excel, PDF or CSV

HOW IT FITS YOUR STACK

EasyQuery reads your Entity Framework DbContext and offers its entities and fields to the users, under the names you give them. You can hide fields, add lookups, and add hidden conditions of your own to every query. EasyQuery generates the SQL and runs it on your connection.

The UI is EasyQuery.JS in your Razor pages or MVC views, or in a React, Angular, Vue or Blazor frontend. There are WinForms and WPF versions too.

builder.Services.AddEasyQuery()
    .UseSqlManager()
    .AddDefaultExporters();
...
app.MapEasyQuery(options => {
    options.DefaultModelId = "nwind";
    options.ConnectionString = connectionString;
    options.UseDbContext<AppDbContext>();
});

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 search your own tables.

HAVE MORE QUESTIONS?

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