We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Trusted by the world’s leading companies

Syncfusion Trusted Companies

Overview

The ASP.NET MVC Query Builder is a rich and responsive UI for filtering large amounts of data by creating or editing conditions that can be combined with data visualization controls like DataGrid and Charts to view the filtered data. It outputs structured JSON filters that can be easily parsed to create SQL queries. It allows you to create conditions and group them using AND/OR logic.


Data Binding

ASP.NET MVC Query Builder can be bound to data from a variety of data sources in the form of a JavaScript object array collection. It auto populates the data source and maps the data to the appropriate fields.

Integration with Data Manager

Integrating the Data Manager control with the Query Builder simplifies communication with a data source and returns the desired result based on the provided filters.


Templates

Templates are used to create a custom user experience. Query Builder provides template support to integrate with other input components such as Dropdown List, AutoComplete , Checkbox, Slider, and others.


Summary View

ASP.NET MVC Query Builder supports a summary view that outputs the filter query in SQL format.

Import and export

Import and export Query Builder data to and from structured JSON and SQL formats.


Touch-friendly and Responsive

ASP.NET MVC Query Builder provides a responsive mode that gives an adaptive, redesigned UI appearance for mobile devices and a great user experience on all phone, tablet, and desktop form factors.

Touch-friendly and adaptive mobile user interface


Themes

The ASP.NET MVC Query Builder supports several built-in themes: Material, Bootstrap, Fabric (Office 365), and high contrast. The users can customize any one of these built-in themes or create new themes to achieve their own desired look and feel by either simply overriding SASS variables or using our Theme Studio application.


Web accessibility

  • Fully supports WAI-ARIA accessibility to work with screen readers and assistive devices.
  • Follows WAI-ARIA best practices for implementing keyboard interaction.
  • Follows WCAG 2.0 standards in design of the UI element visuals such as foreground color, background color, line spacing, text, and images.
  • Supports right-to-left (RTL) text direction for users working in right-to-left languages like Hebrew, Arabic, or Persian.

ASP.NET MVC Query Builder Code Example

Easily get started with ASP.NET MVC Query Builder using a few simple lines of C# code, as demonstrated below. Also explore our ASP.NET MVC Query Builder Example that shows you how to render and configure the ASP.NET MVC Query Builder Component.

@section ControlsSection{
    <div class=" control-section">
        @Html.EJS().QueryBuilder("querybuilder").Width("70%").Columns(col =>
   {
       col.Field("EmployeeID").Label("Employee ID").Type("number").Add();
       col.Field("FirstName").Label("First Name").Type("string").Add();
       col.Field("TitleOfCourtesy").Label("Title Of Courtesy").Type("boolean").Values(new List<string> { "Mr.", "Mrs." }).Add();
       col.Field("Title").Label("Title").Type("string").Add();
       col.Field("HireDate").Label("Hire Date").Type("date").Format("dd/MM/yyyy").Add();
       col.Field("Country").Label("Country").Type("string").Add();
       col.Field("City").Label("City").Type("string").Add();
   }).Rule(ViewBag.rule).DataSource(ViewBag.dataSource).Render()
    </div>
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using EJ2MVCSampleBrowser.Models;
using Syncfusion.EJ2.QueryBuilder;

namespace EJ2MVCSampleBrowser.Controllers.QueryBuilder
{
    public partial class QueryBuilderController : Controller
    {
        public ActionResult DefaultFunctionalities()
        {
            QueryBuilderRule rule = new QueryBuilderRule()
            {
                Condition = "and",
                Rules = new List<QueryBuilderRule>()
                {
                    new QueryBuilderRule { Label="Employee ID", Field="EmployeeID", Type="number", Operator="equal", Value = 1 },
                    new QueryBuilderRule { Label="Title", Field="Title", Type="string", Operator="equal", Value = "Sales Manager" }
                }
            };

            ViewBag.rule = rule;
            ViewBag.dataSource = EmployeeView.GetAllRecords();
            return View();
        }
    }
}

Other supported frameworks

The Query Builder component is also available in Blazor, React, Angular, JavaScript and Vue frameworks. Check out the different Query Builder platforms from the links below,




70+ ASP.NET MVC UI CONTROLS

Frequently Asked Questions

  • Easy to integrate with data visualization components like Grid, Charts, and more.
  • Best UI experience to create filters in the form of JSON and SQL query.
  • Supports a summary view that outputs the filter query in SQL format.
  • Supports importing and exporting Query Builder data to and from structured JSON and SQL formats.
  • Fully customizable to include other components like Checkbox, Slider, and Dropdown List using templates.
  • One of the best ASP.NET MVC Query Builder in the market that offers feature-rich UI to interact with the software.
  • Simple configuration and API.
  • Supports all modern browsers.
  • Mobile-touch friendly and responsive.
  • Expansive learning resources such as demos and documentation to learn quickly and get started with ASP.NET MVC Query Builder.

We do not sell the ASP.NET MVC Query Builder separately. It is only available for purchase as part of the Syncfusion ASP.NET MVC suite, which contains over 70+ ASP.NET MVC components, including the Query Builder UI. A single developer license for the Syncfusion Essential Studio for ASP.NET MVC suite costs $995.00 USD, including one year of support and updates. On top of this, we might be able to offer additional discounts based on currently active promotions. Please contact our sales team today to see if you qualify for any additional discounts.

You can find our ASP.NET MVC Query Builder demo here.

No, our 70+ ASP.NET MVC components, including Query Builder UI, are not sold individually, only as a single package. However, we have competitively priced the product so it only costs a little bit more than what some other vendors charge for their Query Builder UI alone. We have also found that, in our experience, our customers usually start off using one of our products and then expand to several products quickly, so we felt it was best to offer all 70+ ASP.NET MVC components for a flat fee of $995/developer. On top of this, we might be able to offer additional discounts based on currently active promotions. Please contact our sales team today to see if you qualify for any additional discounts.

No, this is a commercial product and requires a paid license. However, a free community license is also available for companies and individuals whose organizations have less than $1 million USD in annual gross revenue and five or fewer developers.

A good place to start would be our comprehensive getting started documentation.

Read independent,
authenticated reviews
on G2

Download Now Pricing

What do our customers say about us?

double quotes

Syncfusion controls contain almost everything a developer could ask for, saving us time and money. All backed up by unmatched support. Syncfusion controls are a developer's dream come true.
Kevin Kerr

Kevin Kerr

Kirk-Rudy

double quotes

I would highly recommend using Essential Studio and have found that the Syncfusion support team is one of the fastest I have worked with.
Georg Kukula

Georg Kukula

G&W Software Entwicklung GmbH

Transform your applications today by downloading our free evaluation version Download Free Trial

Awards

Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile