The ASP.NET MVC Query Builder is a user interface for filtering large amounts of data by creating or editing conditions that can be combined with data visualization controls like Grid and Charts to view the filtered data. It outputs structured JSON of filters that can be easily parsed to create SQL queries. It allows you to create conditions and group them using AND/OR logic.
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 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.
Query Builder 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.
Query Builder provides responsive mode that gives adaptive redesigned UI appearance for mobile devices and best user experience on all phones, tablets, and desktop form factors.
The ASP.NET MVC Query Builder supports several built-in themes such as 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 either by simply overriding SASS variables or using our Theme Studio application with ease.