Active Query Builder 3 ASP.NET Edition v.3.2.4
+ The new "Properties" item has been added to context menus of Objects, Links and the Canvas itself (Query properties). + Possibility to catch error both on the server and client has been added. 1. The new BaseHandler.OnException event has been made. It allows overriding the message passed to the client. 2. The new AQB.Web.QueryBuilder.Events.OnError method allows informing the user about the error in another way. + The new property CriteriaBuilder.dateFormat allows changing the date display format. Default value: "dd.mm.yy". Possible values are listed here: https://api.jqueryui.com/datepicker/#option-dateFormat + The new DataSourceOptions.resizeMode property has been added to change the way the user can resize objects in the Canvas. Default value: "se" (bottom-right corner). Possible values are listed here: https://api.jqueryui.com/resizable/#option-handles - Criteria Builder: The bug with the bool fields type has been fixed. - The bug with displaying splitters in the Internet Explorer has been fixed. = Other minor changes have been made.
Active Query Builder 3 ASP.NET Edition v.3.2.3
+ The new VirtualDirectory option for the configuration file has been added. Setting it will override the autodetected value. + The message is displayed now on turning to the "Sleep mode" when the user enters a query that is not a SELECT statement. + The new demo project has been added to illustrate applying custom HTML layout to the web page and also presents the new version of HTML layout for mobile devices. - Crieria Builder now correctly handles conditions for strings with spaces. - The HideAsteriskItem property is applied correctly being set on the page for the Canvas control. - The bug with the columns width out of sync on changing the Query Columns Grid width has been fixed. - Handling of several Query Column List items with the same Expression has been fixed. = The AQB.Web.Core.addGridRow method now applies all properties of the passed GridRowDto object. = The GridComponent.setColumnWidth now accepts values in pixels and percents.
Active Query Builder 3 ASP.NET Edition v.3.2.2
+ Corporate version is now available for download and upgrade. + Demo projects for VB.NET are included in the installation package. = Autodetection of the used virtual directory has been made. You still can override it via the BaseHandler.VirtualDirectory property. - The bug with metadata filtration arising in some particular cases has been fixed. - Minor visual bugs have been fixed.
Active Query Builder 3 ASP.NET Edition v.3.2.1
! The Provider property of the QueryBuilderStore and QueryTransformerStore objects are available now in the Corporate version only. + The new Angular (https://angular.io/) demo project has been added. + Corporate version: The new CookieStorage demo has been added to illustrate the ability to save the query state on the client side (stateless server). + The new factory methods have been made to create the QueryBuilder along with the right syntax provider. + The AQB.Web.QueryBuilder.GridComponent object introduces the new Header property to control the grid header. It has the columnList property to store the information about grid columns. You can set the width of a grid column by calling the GridComponent.setColumnWidth(name, width) method to set the width of specific column in pixels. + Sub-queries markup has been improved: sub-query buttons are arranged in several rows. Switching between rows is possible with scroll buttons at the right. - The bug with incorrect identification of link direction has been fixed.
Active Query Builder 3 ASP.NET Edition v.3.2.0
+ New JavaScript client properties have been added to support cross-domain configurations: - AQB.Web.Host determines Active Query Builder handlers host address - AQB.Web.beforeSend allows adding custom headers to AQB handler HTTP requests. + Corporate version: The new IQueryBuilderProvider.SaveState property has been added to change the store behaviour on saving the state. It must be set to false if a storage returns a reference to the in-memory object which can be directly modified during the request. It must be set to true if a storage must save the component's state after it's modification. + Corporate version: The new Cross-domain demo project has been added to illustrate working with Active Query Builder handlers on a different host. It allows for an easy build of AQB Docker container. + The new AngularJS (https://www.angularjs.org/) demo project has been added. - Several bugs have been fixed.
Active Query Builder 3 ASP.NET Edition v.3.1.2
+ Corporate version: The new Cross-domain demo project which illustrates hosting of HTTP and Active Query Builder handlers on different sites has been added. + The new setting lets determine the location of Active Query Builder handlers in case of placing them into a virtual directory using standalone IIS server. You can define it in the Application_Start method using the BaseHandler.VirtualDirectory property in case of server-side rendering mode and in via the AQB.Web.virtualDirectory JavaScript property in the case of client-side rendering. + The new CriteriaBuilder.AutoLoad property prescribes to request the list of columns during the component initialization. + The new CriteriaBuilder.AutoSubscribe property instructs to subscribe to changes of the QueryBuilder component with the same id during the component initialization. + The new LogHandlerStateOnExceptions configuration option prescribes to write the serialized component state and request body to the log in case of unhandled exceptions arose during the processing of this request. + The new BeforeProcess and AfterProcess events have been added to AqbHandler and CbHandler objects to log the activity of handlers. + The new BaseHandler.Register() static method lets pre-initialize Active Query Builder handlers which is useful in multi-server environments. - IE9 markup fixes have been made. - The bug on touch-enabled Windows 10 systems in Chrome and Firefox has been fixed. - The bug with not displaying the Custom Expression Editor button without custom jQueryUI theme has been fixed. - The bug with too many brackets for columns that have spaces has been fixed.
Active Query Builder 3 ASP.NET Edition v.3.1.1
+ Client-side optimizations when working with a large number of fields in source tables and in the query have been made. = The ObjectTreeView.DefaultExpandMetadataType now expands the whole tree on setting it to the MetadataType.All value. + The new Query Results demo has been added to the CustomStorage demo project. = SQL Text Editor is now resizable by default. = The QueryBuilder.dispose and CriteriaBuilder.dispose methods are corrected. The new bool parameter instructs to clear the server-side instance as well. + The new QueryBuilder.LoadScript bool property disables loading of embedded javascript resource. Setting it to false requires manual addition of the aqb.client.js script to your web page. - The bug with not expanding the tree down to objects when objects are grouped by type has been fixed. - The bug with calculation of the link direction on the Canvas has been fixed. - The bug with dragging rows in the Query Columns Grid has been fixed. - Minor bugs have been fixed.
Active Query Builder 3 ASP.NET Edition v.3.1.0
+ The client now renders updates from the server faster. + The new demo projects illustrate the component's usage with WebPack, React and Electron. + Logging has been improved. Informational messages about the internal configuration problems are now written to the Output window in Visual Studio. + Corporate version: The ability to define custom storage for the QueryBuilder and QueryTransformer server-side objects to keep the component's state during the user work session and between sessions has been added. This ability allows not to rely on the ASP.NET session mechanism. + The new static classes have been introduced: QueryBuilderStore, QueryTransformerStore. + Get*, Create* and Remove* methods of the SessionStore object are marked as obsolete. They should be replaced with appropriate methods of the new *Store classes. + Corporate version: Ability to override the storage of server-side objects via the IQueryBuilderProvider interface has been added. + Corporate version: The new Custom Server-side Objects Storage Demo has been added to illustrate the usage of the new feature. - The bug with creating links to derived tables has been fixed.
Active Query Builder 3 ASP.NET Edition v.3.0.4
= The new client events AQB.Web.onQueryBuilderReady and AQB.Web.onCriteriaBuilderReady are added to replace the onApplicationReady event. = The QueryBuilder.Logger and AqbHandler.Logger properties have been renamed to Log. = All configuration properties (getters) that must be defined through the configuration file have been moved from the SessionStore class to the appropriate handlers (BaseHandler, AqbHandler, ResourceHandler). = Lots of minor fixes and improvements in HTML code and demo projects have been made. = Direct references to third-party assemblies have been replaced with appropriate Nuget packages where it was possible. = Batch metadata loading is now more intelligent to avoid delays on getting the list of fields for the first requested table. - The bug with restoring layout for non-existing elements has been fixed. - Computation of primary and foreign keys field lists has been fixed. - The bug with deserializing complex metadata structure has been fixed. - The bug with grouping database objects in the tree by types has been fixed. - Several visual glitches have been addressed. - Server memory leaks have been eliminated.
Active Query Builder 3 ASP.NET Edition v.3.0.3
+ The ability to edit text of sub-queries separately from the entire query has been made. Read the Knowledge Base article at https://support.activequerybuilder.com/hc/en-us/articles/360000148009 and review the Edit Sub-Query Text Demo project. + The new SqlEditor.TargetQueryPart property has been added. It accepts the Query, SubQuery and UnionSubQuery values. + The new QueryBuilder.ActiveUnionSubQueryChanged event has been added. + The new activeSubQuerySQL and activeUnionSubQuerySQL properties have been added to the AQB.Web.QueryBuider object on the client. + The new addNewNamedSubQuery, addDerivedTable, addUnionSubQuery methods have been added to the AQB.Web.QueryBuilder object to make possible execute these commands from JavaScript. + The new AQB.Web.QueryBuilder.dispose method destroys the QueryBuilder object both on the server and client. - The bug with displaying field name instead of column alias has been fixed. - The bug with the design pane context menu has been fixed. - Localization of the Properties forms has been fixed. - Z-index for some HTML elements has been corrected. = Resource packing and caching has been made. + The new configuration property EnableResourceCaching has been added.
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!