Release Notes
- Former user (Deleted)
- Thomas Swindells
- Gary Parden
PhixFlow new features and fixes are described in the release notes. Each release has a version number with the format X.Y.Z, for example 7.9.3. Numbers ending in zero, for example, 7.9.0, indicate a major release with significant changes. If Z is 1 or more, it indicates a minor release that contains security updates and bug fixes.
This page includes the release notes for:
Search for release note content:
Release 9.0.15
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.15. This page describes the improvements and fixes in this version.
Installing or Upgrading to PhixFlow Version 9.0.15.
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.14 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.14. on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version you are upgrading.
Special Upgrade Instructions
No new special upgrade instructions. Please review the instructions for previous versions.
Schema Changes
A schema change is required for this PhixFlow release. Please follow the upgrade instructions to install the schema files.
Bug Fixes
DEV-16674 - Resolved blank screen sometimes occurring when opening system console.
DEV-16949 - Fixed regression with displaying legacy Form Views.
DEV-16966 - When a view has been configured to only allow CSV files to be exported it now correctly exports as CSV format.
Release 9.0.14
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.14. This page describes the improvements and fixes in this version.
Installing or Upgrading to PhixFlow Version 9.0.14.
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.14 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.14. on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version you are upgrading.
Special Upgrade Instructions
In version 8 grid rows were alternating by default (white/grey). This is no longer the default since version 9. To enable alternating colours the 'Grid Row Style' and 'Grid Alternate Row Style' can be configured at the system level.
In version 8 grid cells had borders by default. This is no longer the default since version 9. Cell borders can be created by setting the top border on row styles and a right border on column styles
In version 8 grid rows were highlighted in green when the mouse hovered over them. This is no longer the default since version 9. can be created by setting the top border on row styles and a right border on column styles
In order to preserve the 8.3 Grid styling the User needs to set the following Styles:
Grid Row Style:
height: 18px
borderRight: 1px solid #d3d3d3
Grid Alternate Row Style:
Background Colour: #e6e6e6
Row Selection Style:
Background Colour: #07e51c
Grid Row Hover Style:
Background Colour: #22FF37
Schema Changes
A schema change is required for this PhixFlow release. Please follow the upgrade instructions to install the schema files.
Improvements and New Features
DEV-16390 - Add ability to define a 'Grid Alternate Row Style' to apply to 'even' rows in grids. This can be set at the system, application or individual grid level.
DEV-16386 - Add ability to define a 'Grid Row Hover Style' to apply when the mouse is over a row in a grid. This can be set at the system, application or individual grid level.
Bug Fixes
DEV-16387 - Fixed problem with an error being displayed while editing a Screen containing Views with Table Action Menu Items
DEV-16391 - Minimize button now appears on screen windows by default.
Release 9.0.13
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.13. This page describes the improvements and fixes in this version.
Installing or Upgrading to PhixFlow Version 9.0.13.
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.13 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.13. on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version you are upgrading.
Special Upgrade Instructions
None.
Schema Changes
A schema change is not required for this PhixFlow release.
Improvements and New Features
DEV-14575- The PhixScript hash function will now handle secret values. A new expandSecrets(value) function has been added, this takes a single string parameter and will expand any secret tokens into their values.
Bug Fixes
- DEV-15917 - Fixed issue where a lookup pipe in a Table Record Action returned the same results for all records updated; now the pipe filter conditions are correctly re-evaluated for each record updated. Note that the problem did not happen when an explicit lookup() function was used.
- DEV-16004 - Table actions now respond to cancellation by the user; new record sets are marked as incomplete.
- DEV-16007 - Fixed rollback not working when “Only allow restricted task plan run permission users” is ticked
Release 9.0.12
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.12. This page describes the improvements and fixes in this version.
Installing or Upgrading to PhixFlow Version 9.0.12.
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.12 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.12. on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version you are upgrading.
Special Upgrade Instructions
None.
Schema Changes
A schema change is not required for this PhixFlow release.
Improvements and New Features
DEV-15891 - Context Variables can now be used in exporter Input Multiplier expressions.
DEV-15893 - Quick Filters on grids in property editors are now case independent by default.
Bug Fixes
DEV-14515 - The Record ID and Log File ID columns have been removed from log message exports to MS Excel.
DEV-15806 - Fixed the problem with copying data from grids including hidden columns.
Release 9.0.11
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.11. This page describes the improvements and fixes in this version.
Installing or Upgrading to PhixFlow Version 9.0.11.
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.11 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.11. on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version you are upgrading.
This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow.
Special Upgrade Instructions
None.
Schema Changes
A schema change is required for this PhixFlow release.
Improvements and New Features
DEV-14482 - There is a new 'Copy selected records to the clipboard' right-click option for grids which allows users to copy data and paste it into MS Excel.
DEV-14565 - The Cancel Task privilege is now included in the Administrator role on system installation
DEV-15341 - When you push data to a database exporter it will now not only export data from the push pipe but will also export data from any pull pipe connected to that exporter.
DEV-15687 - Upgraded jQuery library to 3.7.0.
Bug Fixes
DEV-12601 - Combined line and bar charts with X-attribute of type Date or DateTime now display correctly.
DEV-14253 - Resolved issue with filtering on card components backed by relational stream views.
DEV-14454 - HTML grid cells now correctly don't include HTML tags in tooltips.
DEV-15156 - Any HTTP Collectors using expressions within HTTP Headers have been automatically updated with the new syntax. Manual verification is recommended.
DEV-15161 - Fixed a problem with some CSS properties not adding 'px' suffix automatically.
DEV-15178 - Fixed importing configuration sometimes ignored a change to the parent Table of a Table Action.
DEV-15251 - Resolved the issue with tooltips on graphs not closing after clicking outside the message.
DEV-15283 - System Console is no longer visible for users without the required 'View System Console' permission.
DEV-15327 - Permissions have been corrected to allow modification of the "Only allow restricted login permission users" setting.
DEV-15397 - Improved run time for actionflows that include analysis actions.
DEV-15443 - Adding a user group to a user that already has that user group will no longer generate an audit record.
DEV-15485 - By default, MySql and MariaDB JDBC drivers read all query results into memory before returning them to the calling code. This can result in excessive java memory consumption, and failure through running of memory completely.
In order to avoid this, we recommend that all MariaDB JDBC Urls specify 'defaultFetchSize=2000'. E.g.
<property name="url">
<value>jdbc:mariadb://localhost/phixflow?defaultFetchSize=2000</value>
</property>
DEV-15504 - UID field is now populated correctly on Create Forms when default mappings are being used and it has not explicitly been marked as the primary key.
DEV-15644 - Fixed issue whereby Actions, Task Plans, Views etc. were never cleared from the records of objects used, hence were always recompiled on startup even if no longer used.
DEV-15722 - When copying or importing, user groups no longer maintain their associations with users that exist in the target instance.
Release 9.0.10
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.10. This page describes the improvements and fixes in this version.
Installing or Upgrading to PhixFlow Version 9.0.10.
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.10.on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.10. on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version you are upgrading.
This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow.
Special Upgrade Instructions
None.
Schema Changes
A schema change is not required for this PhixFlow release.
Improvements and New Features
DEV-15042 - Task Plans can now contain a mix of Action flow tasks and other tasks.
DEV-15243 - Macros now have access to _out, _inputMultiplier and _outputMultiplier
Bug Fixes
DEV-15128 - Resolved: deleting a keystore secret caused the secrets cache to fail, resulting in incorrect responses from the keystore until a restart was performed.
DEV-15205 - Dragging a foreign key attribute on a view will now only create a drop down on the related table's display name attribute when the view is already relational. Relational views can't currently be used to back pipes. This change ensures that it is possible to have a pipe backed by a view containing a foreign key attribute.
DEV-15228 - Grid download data now correctly shows file type option.
DEV-15232 - jsonToXml enhanced to ensure it always generates permitted xml node names. Illegal characters are substituted with their hex code
Release 9.0.9
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.9. This page describes the improvements and fixes in this version.
Installing or Upgrading to PhixFlow Version 9.0.9
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.9 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.9 on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version you are upgrading.
This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow.
Special Upgrade Instructions
None.
Schema Changes
A schema change is not required for this PhixFlow release.
Improvements and New Features
DEV-12943 - Save actions and View actions now pass through all attributes of the input record.
Bug Fixes
DEV-15069 - Ensure that action flows triggered by task plans are correctly marked as failed on error.
Release 9.0.8
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.8. This page describes the improvements and fixes in this version.
Installing or Upgrading to PhixFlow Version 9.0.8
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.8 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.8 on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version you are upgrading.
This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow.
Special Upgrade Instructions
None.
Schema Changes
A schema change is required for this PhixFlow release.
Improvements and New Features
DEV-14520 -Rollback operations now limit the number of detailed info messages generated
DEV-14684 - Pressing enter when typing in a single-line string field on a screen will trigger the OnChange and form data change events. An example use case for this change is the ability to type in a search field and press enter which will cause the search criteria to apply to a filter.
DEV-14754 - Performance improvements for aggregated relational views.
Bug Fixes
DEV-14582 - Fixed run-time conflict with versions of security jar files which caused intermittent import/export issues
DEV-14721 - CSS Properties are now being re-evaluated after changing values on a screen.
DEV-14738 - Improved UI for Button Component's Action Method and Action Type.
DEV-14827 - Context parameters are now correctly passed between multiple analysis runs when run by a push pipe.
Release 9.0.7
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.7. This page describes the improvements and fixes in this version.
Installing or Upgrading to PhixFlow Version 9.0.7
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.7 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.7 on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version you are upgrading.
This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow.
Special Upgrade Instructions
None.
Schema Changes
PhixFlow requires no major product schema changes for this release.
Improvements and New Features
DEV-12864 - The hash() function has been updated so that in addition to the existing MessageDigest (see Hash Functions docs.oracle.com/.../StandardNames.html#MessageDigest). It also now supports the following categories of algorithms:
- Ciphers (See encryption docs.oracle.com/.../StandardNames.html#Cipher)
- MAC (See HMAC docs.oracle.com/.../StandardNames.html#Mac)
- Signature (See signing docs.oracle.com/.../StandardNames.html#Signature)
The Base64 encoder now supports a JWT mode which is URL encoding without Padding (the "==" is not added to the encoded results). These changes provide expressions with the ability to generate JWT tokens of different formats.
DEV- 14525 - Enhancement to allow a single Task Plan to contain both analysis and rollback tasks. This supports the scenario where a rollback is required before an analysis is executed.
Bug Fixes
DEV-14490 - On Change handlers will now correctly run for drop downs and true false fields.
DEV-14535 - Copying a template to a layout component will now rewire any actionflow output mappings to the target form.
Release 9.0.6
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.6. This page describes the improvements and fixes in this version. This major release includes some important changes.
Installing or Upgrading to PhixFlow Version 9.0.6
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.6 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.6 on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version you are upgrading.
This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow.
Special Upgrade Instructions
None.
Schema Changes
PhixFlow requires no product schema changes for this release.
Improvements and New Features
None.
Bug Fixes
DEV-14483: Fixed the issue of date-pickers picking the wrong month for some time zones.
Release 9.0.5
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.5. This page describes the improvements and fixes in this version. This major release includes some important changes.
Installing or Upgrading to PhixFlow Version 9.0.5
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.5 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.5 on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version you are upgrading.
This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow.
Special Upgrade Instructions
None.
Schema Changes
PhixFlow requires product schema changes for this release.
Highlighted Bug Fixes
DEV-14369 - DatePickers now send the selected date regardless of the timezone.
DEV-14370 - 'Select first row by default' flag now correctly causes formatting rules to evaluate when a screen is loaded.
Improvements and New Features
DEV-13215 - You can no longer have two users with the same username.
DEV-13926 - Support for namespaces added to the XMLtoItems() attribute function.
DEV-14291 - Added the option "use raw url" to HTTP Collectors and HTTP Exporters. When ticked the URL will not have any escaped characters decoded, the URL is used in its raw form.
Release 9.0.4
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.4. This page describes the improvements and fixes in this version. This major release includes some important changes.
Installing or Upgrading to PhixFlow Version 9.0.4
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.4 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.4 on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
- This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow.
Highlighted Bug Fixes
DEV-8521: It is now allowed to filter on the action summary column of audit summary and audit detail grids.
DEV-12817: Fixed occasional problem with selecting text not always working correctly.
DEV-13175: Improved error message from calculate action when an attribute is of the wrong type.
DEV-13609: Fixed performance regression test with cached lookups when compared against 8.3 cached lookups.
DEV-13645: Filters with the condition contains, starts with or ends with will now correctly match underscore and percent symbols.
DEV-13903:Actionflows on kanban card containers will now correctly update the kanban value and kanban display value when dropped on empty space
DEV-13967: Tooltips for html formatted view attributes will now be formatted correctly.
DEV-14083: PhixFlow no longer errors when a view uses 2 streams and the data range is set to Latest and the stream contains a local attribute
DEV-14242: Form fields on cards can now have a backing attribute set correctly from a property editor.
DEV-14245: Resolved regression preventing some users from changing their passwords.
Improvements and New Features
DEV-14220: New attribute functions have been added, refer to the help pages for full details:
- zipExtract(zipContents, filename, [charset) - extracts the file with the given name using the given charset
- zipListFiles(zipContents) - returns a list of filenames in the zipfile
- changeCharset(byteString [, charset]) - treats the input string as binary and attempts to convert it to the specified charset (autodetecting if none is specified).
Release 9.0.3
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.3. This page describes the improvements and fixes in this version. This major release includes some important changes.
Installing or Upgrading to PhixFlow Version 9.0.3
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.3 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.3 on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
- This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow.
Highlighted Bug Fixes
This release includes the following fix:
DEV-7873: Resolved an issue where you could get a Stack Overflow error if you called a macro with different numbers of parameters on a single stream or two streams running at the same time.
DEV-13909: File Collector and Http Collector sometimes failed to identify records to import based on XPath settings.
Release 9.0.2
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.2. This page describes the improvements and fixes in this version. This major release includes some important changes.
Installing or Upgrading to PhixFlow Version 9.0.2
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.2 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.2 on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
- This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow.
Special Upgrade Instructions
If you are upgrading from 9.0.0 please check that the migration script from 8.3.20 to 8.3.21 has been run. If it has been run there will be a column export_file_formats_enum
in table stream_view
. If this column does not exist you must run the 8.3.20 to 8.3.21 migration script before running the 9.0.0 to 9.0.1 migration script.
Improvements and New Features
DEV-9798: Users can now override the font size on a grid using grid row styles.
DEV-9923: Users can now add styles directly on the editor for grid attributes.
DEV-12898: Users can now access the list of templates using the screen toolbar.
DEV-13401: Font has now changed for all expressions to Roboto Mono.
DEV-13553: Added "Max Duration" to task plan under "advanced". value must be blank or a positive integer. When a value is entered the task plan will be automatically cancelled after running for a number of minutes equal to the max duration.
Added "Earliest start" and "Latest end" to task plan under "advanced". value must be in the format hh:mm e.g. 06:30. If one is set then the other must be set as well. When both are set the task plan can only be run after the start time and will end automatically at the end time if still running.
Highlighted Bug Fixes
This release includes the following fixes:
DEV-13234: Multiple connectors are now automatically curved on Workflow Models.
DEV-13288: Relational Drop Down fields will now have the drop down sorted alphabetically
DEV-13421: Dragging streamsets from the stream set grid to another stream will now correctly copy those stream sets over to the new stream.
DEV-13495: Object (buttons, event handlers, drop targets) are now hidden for users who don't have permission to run the assigned action.
Release 9.0.1
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9.0.1. This page describes the improvements and fixes in this version. This major release includes some important changes.
Installing or Upgrading to PhixFlow Version 9.0.1
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.1 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.1 on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
- This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow.
Special Upgrade Instructions
If you are upgrading from 9.0.0 please check that the migration script from 8.3.20 to 8.3.21 has been run. If it has been run there will be a column export_file_formats_enum
in table stream_view
. If this column does not exist you must run the 8.3.20 to 8.3.21 migration script before running the 9.0.0 to 9.0.1 migration script.
Improvements and New Features
DEV-13131: It is now possible to remove a backing table from a Kanban board.
DEV-13248: Component mappings are now known as Component Alias. The editor for this has been moved to the 'Advanced' section in the Screen, button, card component and view component editor properties.
DEV-13331: Previously extra escaping was required for backslashes in http collector bodies and other places. For instance to include the string "\n" in the output it would need to be escaped as "\\\\n".
For all new applications this extra level of escapes is no longer required and a single level of escaping the backslash is needed "\\n".
As this may have a detrimental impact on existing apps or packages a setting has been added "Back slashes must be escaped in expressions", For existing apps this will be set to true, for all new apps this defaults to false.
DEV-13348: Tab headers are no longer provided for the 4 key areas of PhixFlow. They will be directly accessible via the header menu.
DEV-13379: Actionflow mapping screens now allow Input Connection Point and Output Connection point lists to scroll independently.
DEV-13398: External User Group Mapping Prefix field was added into the System Configuration. This change the {mappingValue} variable with user group name if the user enters {mappingValue} variable to the External Login Groups field in the User Group.
DEV-13432: When looking at stream sets the action icons are no longer within the three dots menu and are instead on the menu bar.
DEV-13464:Updated the error message when attempting to create a form with no default form component set
DEV-13473:On Views users now have a 'custom' default data range option. If this is selected the user can enter a number of periods to use.
DEV-13494: A new getFields method has been added, this will return a list of the field/attribute names for Records. If assigned to a temporary variable these names can then be used in expressions using the syntax in.$fieldname.
Highlighted Bug Fixes
This release includes the following fixes:
DEV-11701: Actionflows can now be correctly moved between Packages and Applications.
DEV-12342: Task Plans no longer run invalid actionflow configurations.
DEV-13343: Corrections have been applied to the PhixFlow GUI to ensure reliable responsive behaviour on smaller monitors.
DEV-13347: The System Configuration settings for displaying the tabs button and whether tabs are displayed by default is only applicable to Application Mode.
DEV-13371: It is now not possible to create multiple connection point attributes with the same name.
DEV-13377: Improved import to allow repository objects to be imported when the package or application does not existin the target instance.
DEV-13438: New relationship connectors between tables in an ERD are now added to all ERDs containing the related tables..
DEV-13444: Workflows can now correctly display all actionflows including those nested in tabs components.
DEV-13487 Resolved issue in 9.0.0 where count would sometimes return the wrong result.
Release 9.0.0
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 9. This page describes the improvements and fixes in this version. This major release includes some important changes.
Major New Features and Changes
Version 9 has introduced a host of exciting new features, full details of which can be found using the link below.
Several changes have been introduced as part of the Version 9.0 improvements, these will affect both PhixFlow Designers and PhixFlow Application users. Full details can be found using the link below.
Major New Features and Changes
Template Package
The new Serene Grey Template Package has been released as part of version 9.0.0. This includes an extensive set of templates for screen building with items grouped into logical collections within the palette. To find out more see: Template Packages.
Terminology Changes
The following terminology has been changed in PhixFlow to make the concepts easier to understand.
Previous Term | New Term |
---|---|
Dashboard | Screen |
Stream | Table |
Stream Attributes | Attributes |
Stream Item | Record |
Stream Set | Recordset |
Stream View | View |
Stream Action | Table-Action |
Stream Item Action | Record-Action |
Driver Class | Database Driver |
In the system console, he initiator type will now be recorded as Table rather than Stream. This means if you are monitoring the logs for this value the system will require and update.
Installing or Upgrading to PhixFlow Version 9.0.0
To install a new PhixFlow instance:
- Check System Requirements and Compatibility for details of the PhixFlow system requirements and update any dependencies.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.0 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Check System Requirements and Compatibility for changes to the system requirements or supported database versions. For example, you may need to upgrade your database or Java version.
- Please email support@phixflow.com if you are planning to run PhixFlow 9.0.0 on an unsupported database version.
- Ensure you have a backup of the database before upgrading PhixFlow.
Follow the Upgrading PhixFlow steps. It is important to complete Step 8, in which you apply any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
- This release includes changes that affect the PhixFlow database. After upgrading, remember to republish the PhixFlow data as described in Step 10 of Upgrading PhixFlow
Upgrading Step 8: Special Upgrade Instructions
Create new PhixFlow configuration files:
- You must create new versions of the following configuration files in your
../webapp/WEB-INF/classes
directory:logback.xml
phixflow-datasource.xml
phixflow-instance.xml
phixflow-logging.xml
phixflow-login.xml
phixflow-secret.xml
To do this:
Rename your existing configuration files, for example by adding a
.bak
suffix.Follow the Install the PhixFlow Webapp instructions for creating a new file from the "
.example"
files provided.Copy the individual values from your existing configuration files and paste them into the new files.
Avoid copying entire XML blocks into your new configuration files, as you may overwrite a section of the configuration file that PhixFlow requires.
Discontinued Features
The following are now deprecated/out of support:
DEV-10300 The option to open the small popout palette has been removed. This is due to extended palette functionality being present in the docked version of the palette.
Changes to Privileges
New Privileges
Users | Logging | Styles | Other |
---|---|---|---|
Add and Delete Users from a User Group | Enable System Logging | Create Style | Create Applications |
Create Users | View System Logging Configuration | View Style | Download Unlimited Data |
Modify Users | Modify System Logging Configuration | List Style | Edit configuration |
Delete Users | Modify Style | Cancel Tasks | |
Delete Style | |||
Add these to administration roles | Add these to administration roles | Add these to application designer roles | Add these to application designer roles and administration roles |
Privilege Changes
DEV-10126 The existing View System Console privilege provides access to the system console and to rolling back a task. However, you now need the new Cancel Tasks privilege to see the option for stopping a running task. During upgrade, the new Cancel Tasks privilege is automatically added to any user who already has the View System Console and Run Analysis privileges.
DEV-10262 The following items have been changed so their list privilege is now visible in the repository. Previously they were only shown if the user had the UserAdministration privilege.
- Email Account - New: Email Account LIST privilege
- Locales and Languages - Changed to existing Language LIST privilege.
During upgrade, the new EmailAccountList and LanguageList privileges are automatically added to any user who already has the UserAdministration privilege. External User Templates continue to use UserAdministration.
DEV-10901 Run Stream Actions has been renamed to Run Actions. Users require this privilege to run both Table actions (now called table-actions and record-actions) as well as the new actionflows.
DEV-11111 - Formatting Rules on screens now use the Style Privilege.
If you have created an application user role, make sure you update it with any privileges they need; see Controlling User Access to Applications
Improvements and New Features
Performance
DEV-7454 After a server restart, PhixFlow automatically re-caches frequently-used models and Screens in the background. This means the first user to access the model or Screen no longer experiences a delay as it is cached. The period over which PhixFlow tracks object usage is set in System Configuration Delete DTO Usage Records after Days.
Applications
DEV-7304 Palettes can now have grouped components, as illustrated below. To organise your palette components into groups, use the palette properties → Palette Groups options.
DEV-7313 For drop-down components in an application, when the user types into the drop-down list, PhixFlow automatically filters the possible options. The filtering-as-you-type has changed from being case-sensitive to case-insensitive.
DEV-7386 To provide more control when you want to divide a screen, the pop-up menu options:
Add Vertical Bar
Add Horizontal Bar
have been replaced with the options:
Add area above
Add area below
Add area on right
Add area on left
DEV-7487 For a locked screen in design mode, no toolbar is displayed. Right-click to either unlock or to see options to show information, such as properties and attributes.
DEV-7591 You can now add drop-targets to individual area components. There is also a new variable, _dropPosition, which provides co-ordinates of the dropped item relative to the component on which it is dropped; see _dropPosition for details.
DEV-7698 If there is an error when PhixFlow evaluates a CSS Property expression on a layout component, the error message now includes the component name.
DEV-7756 There is a new repository category, Layout Categories. You can configure areas to belong to a layout category then use it to set a Preferred Parent; see Component Categories and Preferred Parents. Where preferred parent areas have been configured, when you drag a component from the palette, PhixFlow will highlight the appropriate drop-areas on the screen.
DEV-7907 Grid view components now have a Basic Settings → Default Page Size to set how many records are displayed in the grid.
DEV-7976 Names of context parameters are preserved, with their actual names, when displayed on the show context parameters popup screen. Previously they were prettified by inserting spaces between capitalized words.
DEV-8048 You can now configure event handlers for some components. This means an application can run a table-action or actionflow when the user mouse-clicks or presses the Enter key.
You can configure the following events on data field components:
OnEnter: the user presses the Enter key in a data field.
OnBlur: the user mouse-clicks out of a data field. The event is triggered whether or not the field has changed.
OnChange: the user mouse-clicks out of a data field in which they have changed data. Notice that this event is not triggered by the user typing into a field.
You can configure the following events:
OnClick: the user mouse clicks in an area or grid views.
OnChange: any change to data in an area component.
DEV-8178 When dragging cards on a kanban board, PhixFlow displays the cards as you are moving them.
DEV-8273 In the Screen properties there are new Basic Settings options to specify a position and size for the screen. By default, new Screens are set to Position: Floating. Alternatively, you can pin a screen to one of the window edges and specify the size using Width and Height options. Use the Pinned options to create a permanently visible screen. This is useful for a navigation area or toolbar that you want to be visible for all other screens. Floating screens do not overlap with pinned screens. When the user maximises a Floating screen, it expands only to the remaining space.
DEV-8385 Scheduled, Suspended and Disabled task plans now have clearer icons.
DEV-8464 Layout Components with "On Click" event-handlers will now have a pointer cursor by default.
DEV-9180 The Internal Icon Source field on screen components now has the option to list existing images and add new images.
DEV-9361 For data views, the attribute properties now include a Grid Settings → Minimum Width option. When PhixFlow adjusts grid column widths to make use of available space, the attribute's column will not become narrower than the specified minimum width.
DEV-9364 You can now use formatting rules with different background images to create true/false field components that look different to the default ticked/unticked box; see Making a True-False Component.
DEV-9554 Use the new button component option → Actions tab → Action Type → Maximise/Minimise Screen to toggle whether or not a Screen is maximised; see Component. In a formatting rule, use the associated new _screen internal variable to match the button icon to the current maximised state of the Screen.
DEV-9605 Data views, form fields and card components can no longer have spaces in their names.
DEV-10395 The Style properties → Justify now has the Space Evenly option for responsive sizing and positioning of components.
DEV-10582 The ability to display a component by right-clicking on it and selecting display is now available in the palette.
DEV-10779 The Basic Settings section in an objects properties is now called 'Details'.
DEV-11189 Users can now access the learning centre, application properties and add startup actions from the application homepage.
DEV-11200 The component type is now displayed in the repository header to make it easier to see what a component is. For example, Table, Area, Grid, View etc.
DEV-11211 After deleting the current Application, all windows are closed and the Application Selection screen is displayed.
DEV-11499 When an action is added to a grid, the default setting is now to always show the button.
DEV-11537 PhixFlow now displays an error message when an action is run from a Form containing multiple fields with the same name, as this may lead to unexpected behaviour.
DEV-11546 HTTP Collectors and Exporters now appear in the HTTP Datasource properties in the repository.
DEV-12177 The PhixFlow Header now has a button that allows the user to hide/show windows tabs.
DEV-12186 Opening a screen from the screens homepage or repository now opens the screen unlocked.
Analysis Models
DEV-1870 Pipes from transactional tables now always allow incomplete recordsets.
DEV-7039 Tables now have a Basic Settings → Default Data Range option in which you can select, if a view does not have the default data range set, it defaults to using the setting in its backing table.:
Latest: records from the latest recordset only
All: records from all recordsets.
DEV-7601 In analysis models, new objects added using the pop-up toolbar are assigned to the same container as the analysis model.
DEV-7738 In datasource properties, the Database Driver option now links to the driver properties.
DEV-7741 You can now add driver classes to an application or package.
DEV-7870 HTTP collectors and exporters can now use the PATCH HTTP method.
DEV-8272 PhixFlow now checks tables and view-attributes to ensure their properties are correct. If you need to correct the configuration, PhixFlow reports the issue in the Errors list. Application and package properties also have an Errors section, which lists issues with any table or attribute that they contain.
Note: The Errors section reports issues that do not affect processing. For example, the analysis process can run on tables that have no Data Retention property set. However, retaining all data can lead to performance issues, so PhixFlow records this as an error in the table configuration.
DEV-8297 Attributes from multiple tables can now be included in views. Often, the primary key attribute that links related tables has a unhelpful name, such as UID
. You can now assign a different attribute to use as the Display Name. This acts as a label for the primary key when it appears in view components; see Attribute.
DEV-8783 In database collectors, the properties menu option Run Query and See Result is now only present when the database collector is enabled.
DEV-10160 PhixFlow now requires all tables to have data retention configured. If no data retention option is set, PhixFlow records an error in the table's Error properties. If you do not want to specify the criteria for keeping data in the Keep... properties, set Data Retention > Retain All Data. However, table data will accumulate, which can lead to performance issues; see table Data Retention properties.
DEV-10388 The pipe property → Maximum Number of records per Group is no longer available on a pipe connected to a calculate table.
DEV-10617 In table properties (was stream properties) the Multipliers and Filters has been renamed to Analysis Options. The following options have been moved from the Basic Settings section into the Analysis Options section:
- Enabled
- Static Data
- Period
- Default Date Range
- Table Type
- Supersede Items on Pipe
DEV-10936 HTTP collectors now include JSON as a response type and JsonPath is available to enter an expression to process data from the JSON block.
DEV-10937 DEV-11115 As an alternative to using a keystore, PhixFlow can now record key/value pairs using a Secret Key and Local Secret. The value, for example a password, is stored encoded. You can refer to the secret key name using ${_datasource.secret-key-name}
in an HTTP Header → Value, or a HTTP Collector/HTTP Exporter → Statement Expression to provide a password to an external site.
DEV-10938, DEV10943 To support secure storage of details, both Datasource and HTTP Datasource modelling objects now have the ability to record a secret. This can be applied both locally in the modelling object (Local Secret) or held externally in the Keystore used by PhixFlow (External Keystore). To support the latter these modelling objects have new Advanced → Internal ID property. See Secret Key and Local Secret for detail on how these can be implemented.
DEV-10944, DEV-10945 HTTP collector and HTTP exporter properties have been reorganised so that the commonly-used properties are easier to access.
DEV-11014, DEV-11131 To support data import from JSON, embedded expressions in HTTP collectors/exporters and headers must be enclosed in ${...}. For embedded expressions in other contexts, we recommend changing to ${...}, although {...} is still supported; see Embedded Expressions. As PhixFlow cannot include newlines in an attribute value it automatically replaces newlines in the returned JSON with a space. If you want the data to indicate where the newlines were, in the JsonPath expression, specify the escape character \n
.
DEV-11035 A new Analysis Options section has been added to the Table properties, this section contains the Audit Manual Changes option.
DEV-11548 Collectors and exporters now have the ability to use a custom icon if one is provided.
DEV-11657 HTTP Collector URL fields require ${} expressions and no longer accept {} expressions e.g. ${_URL} rather than {_URL}.
Important Note: Existing applications will be updated as part of the upgrade process but should be validated once the update is deployed.
DEV-12105 Terminology Change: "Upload Managed File" changed to "Upload File" to make it clearer.
DEV-12380 The "View Chart" option in a table editor has been renamed to "View Data".
DEV-12402 A File Exporter set to send an email has its icon changed in the repository from a text file to an email envelope to indicate its purpose and configuration.
Common Features
DEV-7359 You can mouse-over an expression in a property tab grid to see the full expression.
DEV-8278 When you save a table or view attribute, PhixFlow now checks that their properties are correct and reports it in the Model Validation Status property. You can see a list of the checks and any corrections required in the Errors section of the Table or View Attribute properties. The Model Validation Status property in an application or package also indicates whether or not the contained tables and view attributes are OK.
DEV-8901 The expression popup editor has a new 'show functions' button and the existing buttons have been updated.
DEV-9751 The Open Repository button now opens a repository browser filtered to the currently selected application. Previously a repository browser showing all available applications was opened.
DEV-9837 Download area columns have been resized to improve the visibility of the information presented.
DEV-10019 There is a new text function, hash, which hash-encodes a string using the specified algorithm. It can optionally include a salt-string.
DEV-10853 The term Stream is replaced with the more ubiquitous term Table.
DEV-10857 The Permanently delete option will be placed at the bottom of all right-click menus.
DEV-11604 All expression editors now have an icon to indicate the allowed inputs.
DEV-11740 Added a new 'Expand / Contract Help' button which allows the user to show/hide the contextual help pane.
DEV-12245 Table repository sub-categories have been alphabetically ordered.
DEV-13005 StreamItemId and supercededDtm is now added to default views.
Administration