Active Query Builder History v.1.26.34
= Automatic links creation has been improved: links are created only from
Parent to Child table or vice vera, but not both at the same time.
+ PostgreSQL: Support of materialized view, TOAST tables, and foreign tables
has been made.
+ Oracle: Support of the "AT TIME ZONE" clause has been added.
+ Firebird: Column name definition after alias in the FROM clause is
supported now.
+ IBM DB2: The ListAgg function is supported now.
+ IBM DB2: The QSYS2 tables are used now for fields loading if this scheme
exists. Several minor bugs have been fixed.
+ SQLite: Support for the IS operator ("expr IS expr") has been added.
- SQLite: The bug with not loading fields for a table being added second to
the query has been fixed.
- MS SQL Server: loading objects from non-default schemas for non-default
databases is fixed
- MS SQL Server: The DATEADD parser unambiguity has been fixed.
- MySQL: Parsing of DATE, TIME and DATETIME types as keywords has been
fixed.
Active Query Builder History v.3.3.1.1037
+ SQLite: Support for the IS operator ("expr IS expr") has been added.
= Automatic links creation for self-linked objects has been improved.
- The bug with re-applying metadata filters has been fixed.
- Minor bugfixes have been made.
Active Query Builder History v.3.3.1.1037
+ SQLite: Support for the IS operator ("expr IS expr") has been added.
= Automatic links creation for self-linked objects has been improved.
- The bug with re-applying metadata filters has been fixed.
- Minor bugfixes have been made.
Active Query Builder History v.3.3.1.1037
+ SQLite: Support for the IS operator ("expr IS expr") has been added.
= Automatic links creation for self-linked objects has been improved.
- The bug with re-applying metadata filters has been fixed.
- Minor bugfixes have been made.
Active Query Builder History 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 fixed.
Active Query Builder History v.3.3.0.1036
+ The new helper class Core.UserQueries that consists of static methods has been added to perform various manipulations with user queries, such as adding, saving, moving, renaming them. It also has the means to save and load user queries serialized in XML format. + The new MetadataLoadingOptions.AllowRecursiveVirtualObjects property allows specifying the mode of working with virtual objects. By default, referring to other virtual objects in the text of a virtual object is allowed. Such reference lets build a chain of objects to break complex queries in a series of simple ones. However, in this mode, you can't use the same-named physical object in a virtual object because of the emerging recursion. Setting this property to false prohibits creation chains of virtual objects, but allows to create virtual objects that substitute physical database objects. + The new SQLite metadata provider has been added. = The Query Structure demo project has been refactored. - Removal of unused objects from the query when the QueryBuilder.BehaviorOptions.DeleteUnusedObjects property is turned to True has been fixed.
Active Query Builder History v.3.3.0.1036
+ Now when the user selects the query editing command, the UserQueriesView.EditUserQuery event is triggered, in which the developer can save the current query before opening the new one, or he can open the user query in a new window, the way it's done in the updated Full-featured demo project. Also, the events are now fired on deleting, renaming and moving user queries between the folders. You can review all API changes in the release notes article. + The new helper class Core.UserQueries that consists of static methods has been added to perform various manipulations with user queries, such as adding, saving, moving, renaming them. It also has the means to save and load user queries serialized in XML format. = The updated Professional Full-Featured demo project illustrates the new functionality. + The data browsing UI is improved in the Full-featured demo project. It now uses the Query Transformer API to modify SQL queries. + The new MetadataLoadingOptions.AllowRecursiveVirtualObjects property allows specifying the mode of working with virtual objects. By default, referring to other virtual objects in the text of a virtual object is allowed. Such reference lets build a chain of objects to break complex queries in a series of simple ones. However, in this mode, you can't use the same-named physical object in a virtual object because of the emerging recursion. Setting this property to false prohibits creation chains of virtual objects, but allows to create virtual objects that substitute physical database objects. + The new SQLite metadata provider has been added. = The Query Structure demo project has been refactored. - Removal of unused objects from the query when the QueryBuilder.BehaviorOptions.DeleteUnusedObjects property is turned to True has been fixed. + WinForms DevExpress UI: Query Columns Grid has been remade with DevExpress controls.
Active Query Builder History v.3.3.0.1036
+ Now when the user selects the query editing command, the UserQueriesView.EditUserQuery event is triggered, in which the developer can save the current query before opening the new one, or he can open the user query in a new window, the way it's done in the updated Full-featured demo project. Also, the events are now fired on deleting, renaming and moving user queries between the folders. You can review all API changes in the release notes article. + The new helper class Core.UserQueries that consists of static methods has been added to perform various manipulations with user queries, such as adding, saving, moving, renaming them. It also has the means to save and load user queries serialized in XML format. = The updated Professional Full-Featured demo project illustrates the new functionality. + The data browsing UI is improved in the Full-featured demo project. It now uses the Query Transformer API to modify SQL queries. + The new MetadataLoadingOptions.AllowRecursiveVirtualObjects property allows specifying the mode of working with virtual objects. By default, referring to other virtual objects in the text of a virtual object is allowed. Such reference lets build a chain of objects to break complex queries in a series of simple ones. However, in this mode, you can't use the same-named physical object in a virtual object because of the emerging recursion. Setting this property to false prohibits creation chains of virtual objects, but allows to create virtual objects that substitute physical database objects. + The new SQLite metadata provider has been added. = The Query Structure demo project has been refactored. - Removal of unused objects from the query when the QueryBuilder.BehaviorOptions.DeleteUnusedObjects property is turned to True has been fixed.
Active Query Builder History v.2.13.4
- Aliases for duplicate objects weren't generated when using alternate names. Fixed now.
Active Query Builder History 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.
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!