Active Query Builder  »  SQL Query Builder

SQL modification for easy data browsing

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

  • Changing the view of result SQL query data

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

    It provides the specialised API to modify the given SQL query taking into account the structure of the given query and limitations of 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, limits and apply aggregations to the query.

  • Visual SQL filter builder

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

    SQL Filter Builder gets connected to the QueryTransformer object and provides two-way synchronisation. If you add some 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