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 Blazor 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.


Why choose Syncfusion Blazor Query Builder?

Blazor Query Builder data binding

Seamless data binding

Bind data seamlessly with various local and remote data sources such as JSON, OData, WCF, and RESTful web services with the help of a data manager.

Blazor Query Builder exporting

Importing and exporting

You can import or export filter from or to the Query Builder in structured formats like JSON and SQL.

Blazor Query Builder responsiveness

Adapts to any resolution

Query Builder has a highly responsive layout and an optimized design for desktops, touchscreens, and smart phones. It works well on all mobile phones that use iOS, Android, or Windows OS.

Blazor Query Builder template designs

Create your own template designs

You can add checkboxes, sliders, and dropdown lists to the Query Builder using three different templates options.

Blazor Query Builder themes

Attractive, customizable themes

Cutting-edge design with several built-in themes, such as Fluent, Tailwind CSS, Bootstrap, Material, and Fabric. Utilize the online Theme Studio tool to customize themes easily.

Blazor Query Builder globalization

Globalization and localization

Enables users from different locales to use the component by formatting strings to suit preferences.


Blazor Query Builder Code Example

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

@using Syncfusion.Blazor.QueryBuilder

<SfQueryBuilder TValue="EmployeeDetails">
<QueryBuilderColumns>
    <QueryBuilderColumn Field="EmployeeID" Label="Employee ID" Type="ColumnType.Number"></QueryBuilderColumn>
    <QueryBuilderColumn Field="FirstName" Label="First Name" Type="ColumnType.String"></QueryBuilderColumn>
    <QueryBuilderColumn Field="TitleOfCourtesy" Label="Title of Courtesy" Type="ColumnType.Boolean" Values="Values"></QueryBuilderColumn>
    <QueryBuilderColumn Field="Title" Label="Title" Type="ColumnType.String"></QueryBuilderColumn>
    <QueryBuilderColumn Field="HireDate" Label="Hire Date" Type="ColumnType.Date"></QueryBuilderColumn>
    <QueryBuilderColumn Field="Country" Label="Country" Type="ColumnType.String"></QueryBuilderColumn>
    <QueryBuilderColumn Field="City" Label="City" Type="ColumnType.String"></QueryBuilderColumn>
</QueryBuilderColumns>
</SfQueryBuilder>

@code {
private string[] Values = new string[] { "Mr.", "Mrs." };
public class EmployeeDetails
{
    public int EmployeeID { get; set; }
    public string FirstName { get; set; }
    public bool TitleOfCourtesy { get; set; }
    public string Title { get; set; }
    public DateTime HireDate { get; set; }
    public string Country { get; set; }
    public string City { get; set; }
}
}

Data Manager Integration in Blazor Query Builder

Integration with Data Manager

Integrating the Data Manager control with the Query Builder control 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 the Blazor Query Builder using templates. Use these controls to customize the query builder.

Blazor Querybuilder with Header template

Header template

Users can define their own widgets to customize the elements such as and/or/not connectors and add rules/groups buttons using header template.

Blazor Querybuilder with column template

Column template

Users can define their own widgets to customize the entire column elements such as fields, operators, and values using rule template.

Blazor Querybuilder with Value template

Value template

Users can define their own widgets to customize the elements for values using values template.


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


Blazor Query Builder Summary View

Summary View

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


Import and export

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

Blazor Query Builder Import and Export


Blazor Querybuilder complex data binding

Complex data binding

Complex data binding allows users to create subfields within the main fields. This can be useful for representing hierarchical or multilevel data in a more organized and structured way. To create subfields, users can either specify the complex data in nested columns or specify a complex data source and separator.


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 Blazor Query Builder


Filtering in Blazor 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 Blazor Query Builder UI by customizing its default appearance and style using HTML or CSS.

Blazor Query Builder Appearance customization


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.




Other supported frameworks

Query Builder is also available in Angular, React, Vue, and JavaScript frameworks that are built from their own TypeScript libraries. Check out the different Query Builder platforms from the links below,

Supported browsers

The Blazor Query Builder works well with all modern web browsers such as Chrome, Firefox, Microsoft Edge, Safari, and Opera.

Supported browsers of Blazor Query Builder

Blazor Components – 85+ UI and DataViz 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 importing and exporting Query Builder data to and from structured JSON and SQL formats.
  • One of the best Blazor 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.
  • Extensive demos and documentation to learn quickly and get started with Blazor Query Builder.

You can find our Blazor Query Builder demo, which demonstrates how to render and configure the Query Builder.

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, 5 or fewer developers, and 10 or fewer total employees.

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

Our Customers Love Us

Having an excellent set of tools and a great support team, Syncfusion reduces customers’ development time.
Here are some of their experiences.

Rated by users across the globe

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
Live Chat Icon For mobile