Active Query Builder  »  News  »  Active Query Builder ASP.NET Edition News

Active Query Builder News

March 29, 2016

Active Query Builder ASP.NET Edition 2.11 introduces redesigned sub-query navigation bar.

We're glad to announce the new version of Active Query Builder ASP.NET Edition. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area.

What's new in the Active Query Builder ASP.NET Edition 2.11 since version 2.10?

  • The Sub-query Navigation Bar is re-designed.
  • New design and icons are applied.
  • Chinese (Taiwan) translation is added.
  • Support for resizable layout is added. Read this article for details.
  • Size is shown in the field type for fields in datasources on Design pane.
  • Criteria Builder: Select lists for month and year are added to the dropdown editor for date values.
  • Criteria Builder: The new "Clear" button is added.
  • The new SQL Syntax Highlighting Demo (using CodeMirror text editor) is added.
  • The new ObjectTreeView.DefaultExpandLevel property is added. It determines to which level the tree should be expanded at start. Setting it to a higher value may slow down the initialization in case of retrieving metadata from live database connection.
  • The new ObjectTreeView.SortOrder property that determines ascending or descending order is added.
  • The new event QB.Web.Application.GridComponent.CustomEditControl is added to override the default cell editor type.
  • Oracle: Data type computation in SQL expressions is made.
  • Recognition of IN clauses and date literals in expressions is improved.
  • Other minor bug fixes and improvements are made.
» All Active Query Builder news

Comments by Disqus:

News

Tweets

Screenshots

Join Types

Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.

Unions and Sub-queries

Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.

Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.


Active Query Builder Screenshots

Social networks