Javascript Query Builder jQuery conditions builder UI for SQL filter


features query builder UI

  • provides user-friendly web UI for building complex filters, ad-hoc SQL database queries, user-defined conditions.
  • can be easily integrated into any web application.
  • outputs simple JSON structure that can be easily parsed on the server-side and translated into SQL query or MongoDb filter.
  • built-in editors: textbox, dropdownlist, datepicker. Supports custom field editors.
  • easy to extend and support: simple JS code, only dependency is jQuery.
  • FREE and open source: MIT license.

examples typical usage scenarios

  • Basic:
    • how to configure condition builder for specific fields
    • how to get state (JSON structure) and set state
    • compose SQL WHERE condition by builder JSON state
  • ASP.NET server-side integration (MVC, MVC Core, WebForms):
    • parse JSON state on the server-side and translate it to the SQL query with NReco.Data library.
    • parse JSON state on the server-side and translate it to MongoDb filter

download and pricing

quick purchase process

  • 1 Choose a package
  • 2 Pay online 2Checkout.com is a worldwide leader in online payment services
  • 3 Download the package

NReco Query Builder is a simple way to add advanced user-defined filter to the list, data grid or summary report.

how to use

var $builderElem = $('#queryBuilder'); //div
$builderElem.nrecoConditionBuilder({
  // fields metadata
  fields : [
    {
      name: 'company',
      caption: 'Company',
      renderer: { name: 'textbox' },
      conditions: [{ text: 'like', value: 'like' }]
    }
  ]
});
Have a question? Feel free to ask.

query builder demo

Get query state JSON Get SQL WHERE condition

more components

  • PivotData Toolkit for .NET

    .NET components for manipulating multidimensional dataset (in-memory data cube) without OLAP server, aggregating huge datasets, calculating data for pivot table / chart reports, ASP.NET pivot table builder control.

  • PivotData Microservice

    .NET Core app that provides web API for PivotData Toolkit functionality: create pivot tables & charts by SQL/MongoDb databases, export to JSON/CSV/Excel/PDF. Can be used as backend for web pivot table builder.