Active Query Builder 2 ASP.NET Edition History

April 05, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.9

- The bug with validation of a query that contains a recursive CTE has been
+ The new QB.Web.CriteriaBuilder.Events.CriteriaBuilderChanged event lets
  check the state of the Criteria Builder control.
      function (event, args) {
        // checks if all conditions are valid 
        var isValid = args.criteriaBuilder.isValid(); 
= The Query Results demo projects have been improved.

March 24, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.8

+ The new QB.Web.Application.getProcedureParameters method has been added 
  to redefine default prompt for procedure parameters. It must accept the
  name of procedure name and callback function to return the parameters
  string. Sample:
  QB.Web.Application.getProcedureParameters = function(procName, callback) 
    var params = prompt("Specify params for " + procName);
+ The new Canvas.LinkColor property has been added to specify the color of
  link lines on the Design Pane.
= Dependencies in all MVC 5 demo projects are now targeted to the .NET 4.5
- The bug in the Metadata Structure Demo project has been fixed.

March 17, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.7

= Constant expressions aren't appended to the grouping list now.
- The cross-origin IFRAME access problem has been eliminated.
- The bug with displaying alternate names in dynamic tree structure while
  setting them during the construction of the tree has been fixed.

March 15, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.6

= Default prefixes aren't skipped now in item captions in the Database
  Schema View.
+ The new demo illustrating toggling of the UseAltNames property has been
  added for MVC 5 and Non-MVC (ToggleUseAltNames).
- The bug with resizing of Design Area in IE11 has been fixed.
- The 500 Server error on parsing a query with complex join expression has
  been fixed.

March 03, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.5

= MVC: The QueryBuilderControl.Init event can be replaced now with the Init
  method in inheritor of the new InitializeQueryBuilderAttribute attribute
  applied to the controller method. 
  All of the MVC demo projects are updated according to this change.
= The HttpCompressionEnabled and MultipleQueriesPerSession properties of 
  the QueryBuilderControl have been replaced with respective 'web.config'
  file options and marked as obsolete. The syntax for these options:
  <appSettings><add key="MultipleQueriesPerSession" value="True" />
+ The new delegates have been added to the SessionStoreItem:
  BeforeSqlParsing, AfterSqlGeneration. They allow to perform pre- and 
  post-processing of the SQL query text. The BeforeSqlParsing lets abort
  the parsing and return an error message to end-user.
+ The new demo projects have been made to illustrate changing of connection
  in runtime.
- The bug with the Linked Objects menu not adding new links to already
  existing objects, even if they utilize different relationships has been

February 17, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.4

- Aliases for duplicate objects weren't generated when using alternate names.
  Fixed now.

February 09, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.3

- The bug with the incorrect quotation of alternate names for fields 
  has been fixed.
- The QueryBuilderControl.OnDatasourceFieldRemoved event, the 
  OnCriteriaBuilderChanged and OnCriteriaBuilderError events of the
  CriteriaBuilder control haven't been fired. Fixed now.

February 02, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.2

+ The new QueryBuilder.MetadataLoadingOptions.AllowRecursiveVirtualObjects
 property has been made. Turning this option to True (default is False)
 lets interpret names found in SQL expressions of virtual 
 objects as the names of other virtual objects. Note that this denies 
 subsitution of real objects with same-named virtual objects.
- The bug with the join context menu has been fixed.
- The solution file of the Load Metadata Demo and some other demo projects
 has been corrected.

January 27, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.1

- The bug with searching in the Database Schema Tree has been fixed.
+ The new QB.Web.Application.TreeComponent.tooltipGetText method can be
  defined to set custom tooltip text for items in the Database Schema Tree.
  The Item object that is passed to this method has the following fields:
  caption (holds alternate name if UseAltNames is set to True), description,
  fullName, name, type (enum QB.Web.Enum.MetadataType), typeStr.

January 24, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.0

- The bug with datasouce popup menu not showing in IE has been fixed.

+ Ability to add new calculated fields by the end-user has been made. 
  Now users can add new fields to database objects and specify custom SQL 
  expressions for them. These can be fields intended to perform some 
  manipulations on real database object fields (concatenation, "if - then" 
  expressions, etc.) They can also be used to get values from lookup tables. 
  Of course, the end-user must have the necessary knowledge of SQL language, 
  so we recommend to turn this feature on only if you know that if will be 
  valuable for your end-users. 
  Setting the new QueryBuilderControl.EnableUserFields property to true 
  enables addition and removal of user-defined fields by the end-user. 

+ The new validateCondition and validateExpression methods have been added
  to validate values for the Expression and Condition grid cells.

+ The new MetadataContainer.ExportUserFieldsToXML and ImportUserFieldsFromXML
  methods have been added to save and restore user-defined fields to a file.
  They let keep the user's work between work sessions.

+ The new User Fields demo has been added to demonstrate the new functionality.

+ The new "AllColumns" value can be applied to the UseCustomExpressionBuilder 
  property of the Grid control. Setting it turns the possibility to edit values
  in both Expression and Condition column cells using the custom editor.
+ The new method QB.Web.Application.setUserData(data) has been added. The data
  passed to this method will be sent to the server within the next sync event.

Product Summary

 Active Query Builder WinForms .NET Edition:

 Active Query Builder WPF .NET Edition:

 Active Query Builder ASP.NET Edition:

 Active Query Builder Java Edition:

 Active Query Builder ActiveX Edition:

 Active Query Builder VCL Edition:



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