Downloads  »  Active Query Builder Java Edition History

November 25, 2011

Active Query Builder Java Edition v.1.5.0.1100

Below is the list of fixes and improvements in Active Query Builder Java Edition v.1.5.0.1100.

+ The new row controlling toolbar is added to the leftmost column of 
  CriteriaListControl. You can control visibility of this column and it's state 
  by using the is/setRowControllerVisible() and is/setRowControllerExpanded() 
  properties.
+ The check box is added to the Grouping column header. It allows to toggle 
  the grouping for all criteria items at once.
+ The new get/setCreateWhereJoinsByDefault() property is added to all syntax 
  providers. The newly created link conditions will be added to the WHERE clause
  instead of creating of joins in the FROM clause.
+ The new SQLBuilder.BeginBuildSQLForNode, SQLBuilder.EndBuildSQLForNode, 
  BaseSQLBuilder.BeginBuildSQLForNode, BaseSQLBuilder.EndBuildSQLForNode events 
  are added to perform additional processing on building the SQL query text.
+ The new properties are added to LinkOptions property group: 
  get/setAddLinkedObjects(), get/setDeleteUnusedObjects(). The first property 
  instructs the component to add the necessary objects to join the newly added
  object with existing objects. For example, using the Northwind database, 
  by adding Orders and Products tables to the query, the [Order Details] table 
  will be added automatically and joins will be set according to the foreign 
  keys. The DeleteUnusedObjects property instructs the component to remove 
  objects from the query if their fields are not used in the query and these 
  objects are no longer used to link other objects.
+ The new is/setCreateLinksByIdenticalFieldNames() property is added. It may be
  helpful for the databases that does not foreig keys, but suppose to link
  objects in the query by identical field names.
+ The new UnionSubQuery.addLinksFromExpression() method is added.
+ The new methods are added to help iterating through sub-queries in the query:
  QueryBuilder.getSubQueryList(), QueryBuilder.getUnionSubQueryList(), 
  UnionGroup.getUnionSubQueryList().
+ The new GetProcedureParameters event is added to let provide procedure 
  parameter values without showing of the embedded dialog.
= SQLite: Loading of fields and foreign keys is made using PRAGMA queries.
= Formatting options for CTE sub-queries are added via the
  PlainTextSQLBuilder.get/setCTESubQueryFormat() property.
= LinkCreating and LinkCreated events will be also fired for links being 
  created automatically from foreign keys now.
= Default value of "Criteria for" for non-aggregated query columns is changed
  "For groups" (HAVING) to "For values" (WHERE).
- PostgreSQL: undocumented SUBSTRING function syntax "SUBSTRING('a','b','c')" 
  will being automatically converted to "SUBSTRING('a' FROM 'b' FOR 'c') during
  the parsing.
- Oracle: The bugs with "ORDER SIBLINGS BY" clause and "TRANSLATE" function 
  are fixed.
- Oracle: The bug when removing references to datasources from "CONNECT BY"
  clause. is fixed.
- MSSQL: The bug with "OPENQUERY" function is fixed.
= MSSQL: Definition of the "FOR XML" clause is updated according to the latest
  server version.
- MySQL: The missing built-in functions are added: COALESCE, GREATEST, LEAST 
  and INTERVAL.
- SQLite: Fixed list of aggregate and built-in functions.
- PostgreSQL: Parsing of logical expressions from criteria cells is fixed.
- Firebird: The "INT" alias is added for INTEGER type.
- Column aliases generation in ORDER BY is fixed.
- Metadata object names hash was not rebuilt after MetadataContainer assignment.
  Fixed now.
- The UnionSubQuery.setSQL() method did not remove the previous union sub-query 
  content. Fixed now.
- The QueryBuilder.clear() method is fixed.
- The bug with generating invalid SQL when object and database names are equal
  is fixed.
- The bug with adding derived table of CTE into the same CTE is fixed.
- The bug when "ORDER BY" is added to a query with miltiple UNIONs is fixed.
- A link might be attached to wrong datasource on the design pane in some rare 
  conditions. Fixed now.
= Spanish translation is updated.
= Performance optimizations are made, memory leaks are eliminated.
= Other minor bugfixes are made.

[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

You can always get the latest trial version of Active Query Builder Java Edition at the download page.

» Full Active Query Builder Java Edition history