Build 2705

1. Support for PostgreSQL
2. Support for barcodes and QRcodes in the Report Designer
3. Report Preview in the Report Designer
4. Runs under Java 12 (see Notes below)

1. Rule Log Viewer improvements
   1. an integral part of the Control Panel
   2. ability to show timestamp, user name, business space name
   3. ability to find records by time difference
   4. ability to show SQL
   5. ability to show timer events
   6. ability to filter by user name and business space
   7. ability to export log for the specified business space and user
   8. LOG2 CONTEXT action displays attribute values
   9. Ability to use LOG2 CONTEXT in object rules (priorities can be used to display context before and after)
2. EXEC_SPF function - ability to use stored procedures as functions, for example:

   IF EXEC_SPF ('ContactNotesCount', 'MAIN', Customer.ID) = 4 THEN ... 

   (last parameter must be OUT, all others IN)

3. Ability to specify width and height for modeless windows
4. Ability to specify properties of popup windows (including width and height)
5. Multi-developer mode improvements:
   1. Ability for a developer to lock a business space version
   2. Ability to automatically copy a checked-out element into a development version
6. Support for encoding when importing and exporting data (both in standard commands and IMPORT and EXPORT actions)
7. Ability to automatically create application for Cloud deployment (see CreateBusinessSpaceServlet)
8. Ability to use tags when specifying attribute choices
9. Ability to specify values when defining attribute choices
10. Ability to specify document type and file when creating a new document template
11. Ability to specify matching relationship immediately after a new reference attribute is created
12. Ability to set badges to all menu types except tree
13. Custom queries are now supported in PICK FROM action (both mobile and non-mobile templates)
14. Add Reference, Add New Reference and other reference operations are now supported if references are shown as custom queries on a form
    Add Reference will pick from a custom query list. (both mobile and non-mobile)
15. Arbitrary CSS styles can now be used in item display rules
16. Ability to use tag expressions in item display rules
17. Reference attributes are displayed with a different color in the list of attributes
18. Ability to pick from the list of Font Awesome icons
19. Ability to specify alignment for query columns
20. Ability to drag and drop columns to be displayed when defining queries
21. EXEC_SQL action
22. Ability to specify column widths for standard queries in %
23. Ability to override default SQL type for object attributes (SQL Type in Advanced)
24. Ability to specify labels for left and right listboxes in the Swap Select widget
25. Ability to specify whether created matching attribute will be multiple allowed or not
26. Improved location of the Context Assistant
27. Ability to specify Title for DISPLAY MESSAGE and DISPLAY QUESTION actions
28. Ability to specify explicit queries for scheduler resources
29. “This date” starting option for scheduler supports tag expressions
30. Login through social media supports firstCommand and perpsective parameters

1. UDP no longer modify cross reference rules
2. If an attribute had choices and choices were translated, translated values were not shown in queries
3. It wasn't possible to add strings in queries and calculated columns
4. When an appointment was created from a timeline view, resource was not initialised
5. “Default” output for creation/editing processes in calendar didn't consider output of a content panel where calendar was in
6. If default operation is defined for a calendar it is executed even if there is no editing allowed for the calendar
7. Preview for calendars with timeline views didn't work properly
8. Content panel refresh sometimes didn't work properly
9. Removed the limitation of using 2 refence levels only in applicability conditions and presentation rules
10. Query grouped by date didn't display date properly
11. REST didn't handle URL-form-encoded POST requests properly
12. Sequences didn't work with Azure database
13. Pressing delete event on a calendar also invoked editing event
14. Multi-selectors and swap select were not marked with asterisk when required
15. Timing issue with custom forms

Instructions for people using Java 8 build but running Java12 environment:

1. Search for all occurrences of tools.jar in AwareIM directory - there should be a few.
2. Rename all of them to tools.jar.old
3. If running the old startupOptions.props remove “-Dendorsed” from Tomcat startup options