Active Query Builder  »  SQL Query Builder

SQL modification for easy data browsing

Change grouping and sorting, and apply filters and pagination to a query

  • Changing the view of result SQL query data

    It's standard for any data browsing tool to have the ability to change sorting, apply additional filters and pagination to the query result data, and calculate totals. Active Query Builder enables these features without loading the entire dataset on the client.

    It provides a special API to modify the given SQL query while taking into account the structure of the query and limitations of the particular SQL syntax. Commands applied to the query can be saved and restored afterwards.

    You can learn more about the QueryTransformer API in this article: How to change sorting, add filters and limits, and apply aggregations to a query.

  • Visual SQL filter builder

    Active Query Builder includes SQL Filter Builder - a handy control for applying filters to resulting query data visually in a tree-like form. The SQL Filter Builder represents the WHERE clause, close to the natural language. It retrieves a list of query output columns from the given query to enable type-safe editing of filter values.

    SQL Filter Builder connects to the QueryTransformer object and provides two-way synchronization. If you add filters programmatically, they'll appear in the visual control, so you can allow for custom ways of adding filters to improve the user experience.

    SQL filter builder

Related articles of the Knowledge Book:
Detailed information about Active Query Builder:




We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks