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 Angular 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

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.

Data binding in Angular Query Builder


Data Manager Integration in Angular Query Builder

Integration with Data Manager

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


UI customization with templates

Add controls like Checkbox, Slider, and Dropdown List to to customize the Javascript Query Builder using templates.

Querybuilder with Header template.

Header template

Use the headerTemplate property to define header template which is used for customizing and/or/not operators and add rules/groups buttons using their own widgets.

Querybuilder with column template.

Rule template

Use the ruleTemplate property to define rule template which is used for customizing an entire column using their own widgets.

Querybuilder with Value template.

Value template

Use the template property to define value template which is used for customizing values using their own widgets.


Model binding

Model binding binds properties for the components used in field, operator, and value columns. To implement model binding, assign fieldModel, operatorModel, and valueModel properties in the QueryBuilder.

Querybuilder model binding.


Angular Query Builder Summary View

Summary View

The Angular Query Builder supports a summary view that outputs the filter query in SQL format.


Import and export

Supports importing and exporting Query Builder data to and from structured JSON and SQL formats.

Angular Query Builder Import and Export


Angular Querybuilder complex data binding

Complex data binding

Users can select an item from the hierarchical structure options list and create subfields for columns. Users can bind complex data in nested columns or specify a complex data source, providing the separator in the query builder.


Column binding

The column definitions are used as the data source schema in the Query Builder UI. This plays a vital role in rendering column values. The query builder operations, such as create or delete conditions and create or delete groups, are based on column definitions.

Column binding in Angular Query Builder


Filtering in Angular Query Builder

Filtering

Users can create a filter by adding or deleting conditions or groups. Users can get a created filter as SQL query, JSON, and data manager predicates.


Appearance customization

Change the look and feel of the Angular Query Builder UI by customizing its default appearance and style using HTML or CSS.

Angular Query Builder Appearance customization


Localization in Angular Query Builder

Localization

You can localize all the control’s strings in the user interface as needed and use the localization library to do so.


Touch-friendly and Responsive

Angular 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 responsive interface in Angular Query Builder


Built-in and customizable themes

The Angular Query Builder supports several built-in themes such as Material, Bootstrap, Fabric (Office 365), Tailwind CSS, 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 either by simply overriding SASS variables or using our Theme Studio application with ease.

Built-in themes in Angular Query Builder


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.

Angular Query Builder Code Example

Easily get started with Angular Query Builder using a few simple lines of HTML and TS code, as demonstrated below. Also explore our Angular Query Builder Example that shows you how to render and configure the Query Builder Component in Angular.

<div class=" control-section">
    <div id="querybuilder" class="row">
    </div>
</div>
import { QueryBuilder, ColumnsModel, RuleModel } from '@syncfusion/ej2-querybuilder';
import { employeeData } from './data-source';

    let columnData: ColumnsModel[] = [
        { field: 'EmployeeID', label: 'Employee ID', type: 'number' },
        { field: 'FirstName', label: 'First Name', type: 'string' },
        { field: 'TitleOfCourtesy', label: 'Title Of Courtesy', type: 'boolean', values: ['Mr.', 'Mrs.'] },
        { field: 'Title', label: 'Title', type: 'string' },
        { field: 'HireDate', label: 'Hire Date', type: 'date', format: 'dd/MM/yyyy' },
        { field: 'Country', label: 'Country', type: 'string' },
        { field: 'City', label: 'City', type: 'string' }
    ];
    let importRules: RuleModel = {
        'condition': 'and',
        'rules': [{
            'label': 'EmployeeID',
            'field': 'EmployeeID',
            'type': 'number',
            'operator': 'equal',
            'value': 1
        },
        {
            'label': 'Title',
            'field': 'Title',
            'type': 'string',
            'operator': 'equal',
            'value': 'Sales Manager'
        }]
    };
    let qryBldrObj: QueryBuilder = new QueryBuilder({
        width: '70%',
        dataSource: employeeData,
        columns: columnData,
        rule: importRules
    });
    qryBldrObj.appendTo('#querybuilder');

Other supported frameworks

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


Angular version compatibility

With continuous improvement in Angular versions, the Angular Query Builder is kept up to date to make it compatible with the latest version.




80+ ANGULAR UI COMPONENTS

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 Angular 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 Angular Query Builder.

We do not sell the Angular Query Builder separately. It is only available for purchase as part of the Syncfusion Angular suite, which contains over 80 Angular components, including the Query Builder UI. A single developer license for the Syncfusion Essential Studio for Angular 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 Angular Query Builder demo which demonstrates how to render and configure the Query Builder.

No, our 80+ Angular 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 80+ Angular 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

Using Syncfusion Angular and JavaScript controls makes front-end web development a piece of cake. Each component has many properties that can be configured as per your desire, methods that can be used to interact with the element, and a lot of events that trigger at different stages, which makes modifying your components according to the state of the application an easy task. Also, their support is amazing! They always offer a sample working project, which makes it very simple to solve your question about your code.
Carlos Rodriguez Garcia

Carlos Rodriguez Garcia

Vistatec

double quotes

We started using Syncfusion Angular controls for the Scheduler to offer our providers a way to schedule their availability and automate our administrative process to show availability and gaps in schedules. This helped us provide the best user experience and deliver care to our patients in a timely manner.
Tim Rankel

Tim Rankel

Senior Developer at MeMD

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