Active Query Builder 2 ASP.NET Edition History

August 18, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.14

- The Edit Sub-query icon wasn't shown for Common Table Expressions. Fixed
- Displaying the structure of complex queries in the Sub-query navigation
  bar has been corrected.
- The bug in Criteria Builder with setting "is between" operator for date
  fields has been fixed.
- MetadataLoadingOptions.IncludeFilter/ExcludeFilter: filtration by object
  type only has been fixed.
- The QueryBuilder.LayoutSQL property now accepts empty strings without
- Correct column prefix now emitted for UDFs and stored procedures without

July 14, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.13

- The bug with resising of datasource on Design Pane has been fixed.
= Diagnostic error message is now shown if there's no access to the session store.
= MS SQL Server: List of keywords has been updated.

July 04, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.12

- The CopyLocal property is now set to True for all references to Active 
  Query Builder properties in the demo projects.
- The bug with loading of multiple unnamed foreign keys has been fixed.

June 16, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.11

! Default location of JS and CSS files has been changed. The JS and CSS
  directories must reside in the directory of the web page or the parent
  control, formerly - in the server root folder. As before, you can 
  override the default settings as needed. Please refer to the Quick Start
  Guides for details.
- The error appeared in the JavaScript console in IE on deleting a datsource
  has been fixed.
- The bug with the Undefined parameter in the callback of refreshSql method
  called after the session expiration has been fixed.
- The bug with quotation of incorrect SQL expressions with double quotes
  instead of apostrophes has been fixed.
+ The "Alternate names" demo for MVC5 has been added.

May 17, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.10

= The "object.*" item is added now to the query on dropping an object to 
  the Query Columns Grid.
- The bug with an object added to the query twice on dropping it between 
  the Design Pane and the Query Columns Grid has been fixed.
- The bug with incorrect displaying of fields in the search results in the
  Database Schema Tree has been fixed,
- A memory leak on the client has been eliminated.

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

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: