Active Query Builder News

June 12, 2012

Active Query Builder 2 .NET Edition Beta is out!

The new long-awaited major version of Active Query Builder 2.0 is released for public beta testing now. It is available in the Customer's area for the customers of Standard and Professional .NET Subscriptions who have their subscription in active state.

Important note: There are many breaking changes in this release and for now it can not be installed together with the old version, so you'll have to install the new and old versions in turn. A better way is to use a virtual machine for testing.

What's new in Active Query Builder 2.0?

• Visual changes
• Hiding the Sub-query Tabs above the Design Pane is possible now.
• The Database Schema Tree is capable to display database object fields now.
• The Add Object Form lets search for database objects.
• Now it's possible to hide the Design Pane and build queries without it.
• Swapping the Query Structure Tree and the Database Schema Tree with each other is possible now.
• API Changes
• QueryBuilder properties are reorganized into several options groups.
• Metadata Container is completely reworked to eliminate the need for pre-loading of metadata. All the necessary information about database structure is loaded on demand now. Container is capable to store all possible types of artefacts, such as linked servers, packages, custom aggregates, etc.
• Metadata Structure object is made to abstract from the physical structure of the database when displaying objects in the Database Schema Tree.
• The new Metadata Container and Structure editor allows you to setup the database objects representation for the end-user the way you like.
• The list of used database objects and fields (QueryStatistics) can be obtained now for most of the query objects: sub-queries, datasources, query column list expressions.
• The last but not the least: the property reference is avaialble for most parts of the component.

More detailed description of the new features will be given in the Knowledge Book soon. The Load Metadata and the Metadata Structure demo projects illustrate some aspects of the new functionality.

The currently available version lacks the SQL Text Editor, the Expression Editor and metadata providers for some database servers. They will be added in the next builds.

» All Active Query Builder news