Baan Query Tool Release Notes

1.   Enabling lock mechanism per query and per user, where each user can modify different queries in the same time

2.   You can use a group by option for a field using functions such as: sum, avg, min, max and count

 

Offset result - define the position of the result field by setting the offset (Left or Right) and the distance in characters

Text before field - You can add sort fields values as variables: SORT1, SORT2, SORT3, SORT

New Features:

• Formulas - You can now use formulas in your queries. Formulas can include simple arithmetic between 4 different fields. The different parts of the formula can be query columns, numbers or a result from different formulas.
• Column Choice - You can now choose which fields from the query fields will appear in the report, and not necessarily columns that were chosen in query.
• Column Width - Define a column width for each one to override the default
• Column Alignment - Left, Right, Center or leave blank for default
• Column Layout - All columns in report can be represented in any format layout that is supported in the system. As an example, the date 13-12-2010 can be shown as 13-12-2010 or as Monday, December 13, 2010.
• Entering date fields in a Baan-like style in the printing form. You can use "+" (for current day) or "+30" (for 30 days from today) and 12-12 (for December 12, current year).
• Organizing Queries feature was added so you can have the queries in the order you prefer.

• Introduced Run-Only Session - Possibility to run queries written by other users.
• Defining a device and device parameters (Output File), per query
  
  
• Possibility to hide the print form so that query is generated directly by pressing on "print result". Could be useful when automating queries.
• Printing "Wide" reports, to work with Baan limitation of 255 characters. The new version includes a possibility to run reports through a "Wide" device. When this device is used, report output is produced through ASCII files and not through the regular spool device, and therefore can support any number of characters. Supported "devices" for this option are ones where the 4GL program is otccom2win66 (or higher) or ttstpconv (B2Win 6.6 or the standard device ASCIF) � Otherwise, Standard and Wide devices work exactly the same.
• Enabling the multi-select and select all feature for choosing columns to go into the query.
• With the possibility to hide the print form and to pre-define the output device, you can run queries in a job.

A new and improved version of Baan Query Tool is now available with the following features:

1. "Clear Default" and "Save Default" buttons in the print form.
2. Zoom to fields in the print form (From-To)
3. Added the option to let the user choose which fields to include in the print form (From-To) and which ones will appear on the report layout only.
4. Three different zoom options for finding a Baan table:
   1. Zoom to all tables in company.
   2. Search for a table (using free text)
   3. Zoom to already used tables � useful when fine-tuning an existing report.
      
      
      
      
5. Sort the report according to certain fields.
6. Running the report in command line - The parameter is the query code displayed in BaanQ main window.
7. Using Outer Join, working according to some Baan and ERP Ln limitation.
8. Rename column titles � and not working with default names only.
9. Handling text fields.
   
   
   
10. Handling array fields.