- Created by Former user, last modified by Anthony George on Oct 04, 2024
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 74 Next »
PhixFlow new features and fixes are described in 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 9.0.12, indicates 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:
Release 11.2.2
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 11.2.2 This page describes the improvements and fixes in this version.
Installing or Upgrading PhixFlow
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 11 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- PhixFlow must be at version 8.3.18 or later in order to be upgraded to this version. If this is not the case please first upgrade to 8.3.18.
- 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 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 any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
Special Upgrade Instructions
None for 11.2.2. Please check the Special Upgrade Instructions for all the intermediate releases between your current version and this one.
Bug Fixes
DEV-18301 - Background image position for component styles will now copy the vertical position to the horizontal position if the vertical position is not set. Additionally it will again accept numbers without "px" at the end
DEV-18295 - In Actionflows, on tables configured to keep audit history, having two save nodes that modifies the same record no longer duplicates it.
DEV-18266 - Resolved failure on SQL Server to load application translation maps.
DEV-18233 - XML Namespace creations no longer throw an error
DEV-18229 - Resolved issue where frozen columns on grids could cause the grid to be displayed incorrectly.
DEV-18190 - Fixed issues with hover popup not appearing on Analysis Models, Workflows, Actionflow and ERDs when zoomed out.
DEV-18184 - Fixed a publishing error caused by importing a table that previously existed and was deleted.
DEV-18177 - In Analysis Modelling, the issue of emails with long subjects being omitted from processing has been resolved.
DEV-18118 - Improved GUI response times after updating a screen.
DEV-18117 - On startup the audit log files are reread and audit events that were not successfully persisted will be replayed into the database.
Release 11.2.1
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 11.2.1 This page describes the improvements and fixes in this version.
Installing or Upgrading PhixFlow
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 11 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- PhixFlow must be at version 8.3.18 or later in order to be upgraded to this version. If this is not the case please first upgrade to 8.3.18.
- 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 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 any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
Special Upgrade Instructions
None for 11.2.1. Please check the Special Upgrade Instructions for all the intermediate releases between your current version and this one.
Bug Fixes
DEV-18117 - On startup the audit log files are reread and any audit event that was not successfully persisted will be replayed into the database.
DEV-18118 - Improved GUI response times after updating a screen's content.
DEV-18177 - In Analysis Modelling, the issue of emails with long subjects being omitted from processing has been resolved.
DEV-18184 - Fixed a publishing error caused by importing a table that previously existed and was deleted.
DEV-18190 - Fixed issues with hover popup boxes not appearing on Analysis Models, Workflows, Actionflow and ERDs when zoomed out.
DEV-18233 - XML Namespace creations no longer throw an error.
DEV-18266 - Resolved the failure issue when using SQL Server to load application translation maps.
Release 11.2.0
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 11.2.0 This page describes the improvements and fixes in this version.
Installing or Upgrading PhixFlow
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 11 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- PhixFlow must be at version 8.3.18 or later in order to be upgraded to this version. If this is not the case please first upgrade to 8.3.18.
- 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 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 any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
Special Upgrade Instructions
None for 11.2.0. Please check the Special Upgrade Instructions for all the intermediate releases between your current version and this one.
Bug Fixes
DEV-17959 - A second, alternative, domain suffix can be configured for ActiveDirectory by setting the login.activeDirectory.alternativeDomain property. If a user is not found in Active Directory with the primary domain (login.activeDirectory.domain) then the alternative domain will be tried.
DEV-17990 - Improvements have been applied to how PhixFlow captures audit information to ensure that log messages cannot become lost.
DEV-18000 - Resolved the issue of importing configuration deleting Sort Order attributes when a table references a sort order from a different application or package.
DEV-18024 - Resolved stability issues when rate limiting was configured on multiple HTTP collectors or HTTP exporters. HTTP Exporters now throttle per batch of records being processed.
DEV-18051 - Grids showing relational attributes are now refreshed when the table for the relational attribute is updated by an Actionflow.
DEV-18056 - An optional configuration setting, dbAuditService.haltOnDiscardCommitted, has been added which when set will terminate PhixFlow if audit records are unable to be written to the database after extended periods of retrying. The default time period is 24 hours, however this is configurable by setting the property dbAuditService.retryForMs, in server.properties for PhixFlow 10.0 or in local.properties for version 11.0 onwards.
DEV-18062 - Maximum Parallel HTTP Actions property field added into the System Configuration to handle parallel HTTP actions.
DEV-18063 - Added a new Wait action node in Actionflows. Wait actions will hold any records passed into them until all previous action nodes have completed and then pass on a record with only a count attribute containing the sum of all records it has received.
DEV-18107 - Audit records are now also recorded in a separate audit.log file as they are being generated. This guarantees their availability even if the application is restarted before they can be written to the database.
DEV-18114 - In API Endpoints, a Timeout option has been added that allows control over the maximum time (in ms) a request will wait for before timing out. If specified, this will override the default timeout of 60s. However, the Timeout can also be overridden by the timeout URL parameter.
DEV-18116 - Added 'Log Request' and 'Log Response' options to the API Endpoint properties to log its request and responses into the System Console.
DEV-18132 - Creating Grid CRUD Edit Actions now works correctly when performed directly after creating the Grid.
DEV-18149 - Embedded JSON now supports date and time values, converting them into a String representation of the timestamp.
Release 11.1.4
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 11.1.4. This page describes the improvements and fixes in this version.
Installing or Upgrading PhixFlow
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 11 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- PhixFlow must be at version 8.3.18 or later in order to be upgraded to this version. If this is not the case please first upgrade to 8.3.18.
- 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 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 any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
Special Upgrade Instructions
None for 11.1.4. Please check the Special Upgrade Instructions for all the intermediate releases between your current version and this one.
Bug Fixes
DEV-17473 - Memory leak fix applied to Analysis Models and Actionflows providing improved processing performance.
DEV-18002 - Validations with an invalid regular expression will no longer fail silently. An invalid regular expression message will be displayed in the Validation tooltip for the associated Form Field(s).
DEV-18007 - Fixed the "hide loading spinner" option for Actionflows which was not working. When the loading spinner is not hidden it will now display after half a second instead of immediately.
DEV-18020 - Fixed run analysis failing on tables if the table configuration was changed during the analysis run.
Release 11.1.3
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 11.1.3. This page describes the improvements and fixes in this version.
Installing or Upgrading PhixFlow
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 11 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- PhixFlow must be at version 8.3.18 or later in order to be upgraded to this version. If this is not the case please first upgrade to 8.3.18.
- 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 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 any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
Special Upgrade Instructions
If upgrading please review Special Upgrade Instructions for details of any additional Special Upgrade instructions for intermediate releases between your current version and the version which you are upgrading.
Template Package
A new version of the Template Package Serene Grey is available as part of this release. To get the best from your PhixFlow system we recommend downloading and installing this version:
- Download: Serene_Grey.zip
- Instructions: Installing Template Packages
Bug Fixes
DEV-17323 - Setting the default values on form fields now works correctly on Cards.
DEV-17629 - The Table Attribute Picker is no longer limited to the first 250 attributes, it now displays all available attributes.
DEV-17945 - Fixed various issues with display and filtering of values in dropdown fields.
DEV-17952 - Copying Annotations now works using Ctrl+drag on Actionflows.
DEV-17971 - Within Actionflows a fix has been applied to ensure all Save Action attributes are visible after an upgrade.
DEV-18005 - Fixed the issue of not being able to reference pull pipes going into a table within the expressions of collectors connected to the table via a lookup pipe.
DEV-18014 - Running actionflows directly, using the Run Action feature, didn't always pass in the user defined values for attributes that didn't have a default value set. This is now fixed.
Release 11.1.2
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 11.1.2. This page describes the improvements and fixes in this version.
Installing or Upgrading PhixFlow
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 11 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- PhixFlow must be at version 8.3.18 or later in order to be upgraded to this version. If this is not the case please first upgrade to 8.3.18.
- 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 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 any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
Special Upgrade Instructions
If upgrading please review Special Upgrade Instructions for details of any additional Special Upgrade instructions for intermediate releases between your current version and the version which you are upgrading.
Template Package
A new version of the Template Package Serene Grey is available as part of this release. To get the best from your PhixFlow system we recommend downloading and installing this version:
- Download: Serene_Grey.zip
- Instructions: Installing Template Packages
Bug Fixes
DEV-17608 - Warning messages about mixing shorthand CSS properties now display the correct component's name.
DEV-17928 - Pasted images now correctly render in HTML form fields.
DEV-17947 - Resolved issues when upgrading from 9.0.10 whilst using a clustered setup of MySQL 8.
DEV-17948 - Resolved issues where some external database connections would fail with the error “Unable to validate object”.
DEV-17949 - Resolved an issue where HTTP header expressions within Analysis Models would return empty values.
DEV-17956 - When the View option, Show Brush on Charts is disabled, the brush no longer shows.
DEV-17958 - Fixed an issue where the Maximum Rollover Requests in the Rate Limiting of an HTTP Connection was being treated as the total maximum number of new tokens, not the maximum number of rolled over tokens, causing issues when the maximum was configured as 0.
Release 11.1.1
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 11.1.1. This page describes the improvements and fixes in this version.
Installing or Upgrading PhixFlow
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 11 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- PhixFlow must be at version 8.3.18 or later in order to be upgraded to this version. If this is not the case please first upgrade to 8.3.18.
- 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 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 any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
Special Upgrade Instructions
If you are upgrading from a version that is pre version 11 then please also see Special Upgrade Instructions for details of additional Special Upgrade instructions for your version inwards.
(DEV-16708) HTTP Headers on HTTP actions have been updated to ensure correct capitalisation e.g. contenttype will become Content-Type. Due to this amendment existing Actionflows should be reviewed and any access to returned HTTP Header values should be adjusted to use the correct capitalisation if they do not currently use standard header capitalisation.
(DEV-17452) As part of the upgrade, all Actionflows that previously were configured as API Endpoints have been converted to the new API Endpoint type Actionflow. For the endpoint to return data, the response body needs to be mapped to the output body attribute in the new API Endpoint.
Template Package
A new version of the Template Package Serene Grey is available as part of this release. To get the best from your PhixFlow system we recommend downloading and installing this version:
- Download: Serene_Grey.zip
- Instructions: Installing Template Packages
Improvements and New Features
Screens
DEV-16698 - It is now possible to set custom tooltips on grid cells aka table cells, such as displaying details of the action that will be run on-click.
DEV-17352 - It is now possible to not specify the size of a Screen, when unset it will adjust its size to the content automatically.
DEV-17527 - It is now possible to fire button actions or change true/false fields values when a Screen is unlocked by using alt+click.
Actionflows
DEV-17075 - Added the ability to throttle the rate at which requests to external systems are made for a HTTP Action within an actionflows.
DEV-17445 - In Actionflows, it is now possible to share settings between different HTTP Actions using the HTTP Configuration setting.
DEV-17579 - Added an option to run an Actionflow directly from the property editor, Actionflow toolbar, and right-click menu of the repository. This option will show a prompt form to enter any input parameters and will open a grid to display any output records.
DEV-17641 - Added default value expressions to Actionflow attributes. When set, if no mapping is made to that attribute or if that value provided is null or unavailable (for example if the initiating user did not have permission to see it) then the default value expression will be evaluated and the value set to its result. Default value expressions do not use sequence and are automatically resolved in the appropriate order based upon other attributes they reference.
DEV-17729 - Actionflows can now have custom icons assigned.
Performance
DEV-17013 - Improved configuration export performance.
DEV-17507 - Images fetched by File Display components on a screen will now be cached, improving performance.
DEV-17706 - For performance reasons, grids in the system console will no longer show the row count by default. Clicking the ... will display the count.
Charting
DEV-17433 - It is now possible to create multi-layers hierarchical graphs by setting Background Filter Rules using chart selection. Line charts can now indicate which data point is selected.
DEV-17438 - Cumulative sum and cumulative percent are now available as aggregate functions. This allows Pareto graphs to now be generated.
DEV-17456 - It is now possible to create Custom Series on charts, which include fixed values, percentile, and other statistical functions including expressions.
DEV-17811 - Disabling vertical axis on charts now correctly hides the labels.
DEV-17877 - In Charting when grid lines (guides) are disabled the axes lines remain visible. In addition horizontal grid lines are now shared between the left and right axis to avoid overlapping.
Integration
DEV-17302 - A new Private Secrets section has been added to the full repository that enables the management of Private Secret Keys.
DEV-17452 - API actions are now a separate type of Actionflow called API Endpoints. API Endpoints have fixed input attributes (body, headers, contentType and url), and fixed output attributes (body, headers, contentType and statusCode).
DEV-17496 - Native support to easily create JSON documents within expressions is available. Additionally new functions have been added to allow the conversion of these into XML documents. See help, toJson, toXml and JSON Support.
DEV-17888 - New transpose() Function added.
Bug Fixes
DEV-16708 - The headers returned by HTTP Actions are now normalized to follow standard header naming rules (e.g. Content-Type).
DEV-17255 - Data Points are now correctly displayed on Line Charts when the option is selected.
DEV-17319 - Improved performance when adding new components to a screen.
DEV-17501 - Line Charts and combined bar and line charts now work for x-axis attributes of type String.
DEV-17503 - Sorting by x-axis now works for charts when the x-axis attribute is of type String.
DEV-17551 - Sorting graphs with horizontal axis attributes of number types now works correctly.
DEV-17650 - Bulk delete Actionflow nodes now pass through record attributes.
DEV-17697 - Formatting Rules can now refer to the _user internal variable.
DEV-17708 - Improved performance when displaying the audit summary on the Console screen.
Release 11.0.2
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 11.0.2. This page describes the improvements and fixes in this version.
Installing or Upgrading PhixFlow
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 11 on an unsupported database version.
Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
PhixFlow must be at version 8.3.18 or later in order to be upgraded. If this is not the case please first upgrade to 8.3.18.
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 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 any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
Schema Changes
Handled automatically from PhixFlow Version 11.
Improvements and New Features
Minor patch release only containing bug fixes.
Bug Fixes
DEV-17731 | Resolved issue where HTTP Collectors and Database collectors would error with "illegal group reference" if the substituted value contains $. |
DEV-17718 | Filters created on a Card Components now included in its list of filters. |
DEV-17699 | Fixed delete actionflow nodes displaying an unhelpful error message when the primary key is not mapped, with a more informative error message. |
DEV-17640 | Improved performance of analysis tasks. |
DEV-17621 | Field Containers now correctly set the name of the first input field to match the name of the Field Container. |
DEV-17606 | Fixed auto-save actions on Views not having their auto save action method set to Table Action if they were previously configured. |
DEV-17599 | Fixed null pointer exception when a Database Collector query returns zero records. |
DEV-17592 | Bottom axis of bar charts are now aligned consistently with other types of graph, and the alignment of labels has been Improved, |
DEV-17590 | Analysis Models now correctly display pipes after dragging the Modelling Pane. |
DEV-17532 | Fixed Actionflows sometimes not displaying configuration changes until the Refresh button is clicked. |
DEV-15967 | Changing a View Attribute's name now automatically refactors the parent View's Formatting Rules expressions referencing that attribute. |
Release 11.0.1
Introduction
PhixFlow is pleased to announce the release of PhixFlow Version 11.0.1. This page describes the improvements and fixes in this version.
Installing or Upgrading PhixFlow
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 11 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- PhixFlow must be at version 8.3.24 or later in order to be upgraded. If this is not the case please first upgrade to 8.3.24.
- 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 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 any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
Schema Changes
Handled automatically from PhixFlow Version 11.
Improvements and New Features
None.
Bug Fixes
DEV-17403 - Fixed problem with positioning windows when they are configured with a percentage size.
DEV-17465 - In an Actionflow, using a Save Action to insert a record into a table that has already had a record inserted by a different Save Action within the same Actionflow will no longer error.
DEV-17480 - Fixed Actionflow Loop nodes sometimes generating "state was 'CLOSED'" errors.
DEV-17498 - Fixed embedded Actionflow node Connection Points not showing.
DEV-17499 - Fixed not always being able to drag from Actionflow Input Connection Points onto action nodes.
DEV-17516 - Resolved issue where deselecting all rows on grids was no longer working.
DEV-17521 - Fixed problem with resizing relational grid columns which caused reopening the screen to display an error.
DEV-17541 - Added a loading spinner and duplicate protection when dragging an actionflow node between two existing actionflow nodes.
DEV-17571 - PhixFlow will now write an entry to the System Console → Audit Summary each time it starts with its version number and details of any database patch scripts that executed. The Action description starts with “Executing db\upgrade”.
Release 11.0.0
What's New
You requested, we listened! Welcome to PhixFlow Version 11.
We’ve made a whole host of usability and performance enhancements to make PhixFlow more powerful than ever. Over 70 significant improvements and new features have been added, for more information visit phixflow.com/whats-new-in-phixflow-11
Installing or Upgrading to PhixFlow Version 11
A significant change has been made to the installation process of PhixFlow which simplifies the process. Please read the new instructions before installing or upgrading.
PhixFlow systems running on a MariaDB database will not work with version 11, support for this database has now ceased. If you require help switching to a supported database please get in touch with our support team support@phixflow.com
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 11 on an unsupported database version.
- Follow the instructions in Installing PhixFlow.
To upgrade an existing PhixFlow instance:
- Phixflow must be at version 8.3.24 or later in order to be upgraded. If this is not the case please first upgrade to 8.3.24.
- 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 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 any Special Upgrade Instructions for all the intermediate releases between your current version and the version to which you are upgrading.
Special Upgrade Instructions
Configuration Files
The previous configuration files e.g. phixflow-datasource.xml, have been replaced with two new files. Full details are provided in the installation/upgrade instructions:
- local.properties
- logback.phixflow.xml
Database Upgrader
The database schema installation/upgrade is run automatically as part of the installation/ upgrade when upgrading from version 8.3.18 onwards to version 11 or later.
File Table Upload Location
To use the new File Display component which facilitates the uploading of files by dragging and dropping files onto a PhixFlow screen, the following setup is required:
- On your PhixFlow server, create a directory where the files can be stored. This should be created alongside the other System Directories and be accessible to the application. See Minimum Setup for configuring System Directories.
- For example, /opt/phixflow/data/file
- In PhixFlow, from the Administration menu, open System → Configuration
- In the System Directories section → File Table Upload Location field, add the address of the directory setup in the first step, e.g. /opt/phixflow/data/file
- save your changes
- All uploaded files will now be placed in this directory. The directory should be backed up in line with your local policy.
Schema Changes
Significant schema changes are required for this release.
Discontinued Features
PhixFlow systems running on a MariaDB database will not work with version 11, support for this database has now ceased. If you require help switching to a supported database please get in touch with our support team support@phixflow.com
Changes to Privileges
None.
Improvements and New Features
Actionflows
DEV-9373 - Added Converge Action node to Actionflows. Converge actions have many inputs and one output.
DEV-12229 - Added the ability to extract actions to a new Actionflow in the Actionflow node context menu. This will create a new Actionflow and transfer all selected nodes into that Actionflow. All extracted nodes must be connected and not include any start phase nodes. If a start loop is extracted its corresponding end loop must be extracted too and vice-versa.
DEV-13875 - Added a Bulk Update Actionflow node, which can be used to set values on a table in bulk.
DEV-14196 - Added an XML Actionflow node, which can be configured with a path to extract values from an XML string.
DEV-14197 - Added a For Each Actionflow node, which will produce one output record for each entry in an input list or record set.
DEV-14907 - Added "Minimum records" and "Maximum records" to connection points on Actionflows, when set it will cause the Actionflow to error if the number of records received by the Actionflow is less than the minimum or greater than the maximum.
DEV-16096 - Cancelled/failed actions are now correctly removed from the active section of the console in all circumstances.
DEV-16411 - Added a Bulk Delete Actionflow node, which will delete data from a table using a filter or may be configured to delete all data from a table.
DEV-16746 - The Save action has been split into separate Save and Delete actions in the Actionflow screen.
DEV-16801 - Actionflow loops will now wait until all branching nodes are finished before beginning the next iteration of the loop.
DEV-16819 - HTTP Actions now support configuring the timeout, which can be configured in advanced properties.
DEV-16976 - Error messages for actionflows will now include the name of the action node and all parent Actionflows to make it easier to diagnose which node has generated the error.
DEV-16986 - It is now possible to control if an Actionflow can be triggered multiple times in parallel from the same client, i.e. can another run be started while the previous is not finished yet.
DEV-16995 - Added new options for API Actionflows. API Mode allows API Actionflows to be changed to "poll for result", where subsequent API calls can be used to fetch the result of the action when it is finished instead of waiting until it is finished before carrying on. Additionally, the URL will be displayed in the Actionflow property editor for API actions.
DEV-17094 - Converge Action has an "Input Connection" section added.
DEV-17127 - Actionflow phases will now wait for all nodes to finish before beginning the next phase.
DEV-17183 - Added the ability for the Delete action to delete files when a record from a file table is deleted. The behaviour can be configured to delete the file, archive the file to a specified directory or only delete the record but not remove the file from the server.
DEV-17216 - Bulk Update and Bulk Delete actions have an option to allow audited tables. Only non-audited tables can be updated or deleted if this is not ticked.
Administration
DEV-359 - Automatic schema installation is now implemented, no longer requiring the manual running of schema migration scripts.
DEV-6875 - Audits of automatic schema upgrades can be found in the DATABASECHANGELOG table.
DEV-7267 - The installation and upgrade process has been streamlined.
DEV-10952 - The installation and upgrade processes have been simplified and automated to no longer require manual running of database migration scripts.
DEV-11465 - System configuration can now be done via properties files rather than having to edit xml files directly.
DEV-14548 - The System Console Completed Tasks grid now includes the duration of the task.
DEV-16649 - The default password policy for new installs has been updated. The minimum length is now 12 with at least 1 each of uppercase, lowercase, numeric and special characters. The policy has not changed on existing installations.
DEV-16994 - Added a button to the System Console to take a snapshot of a running Actionflow, this will provide information about its current status. A snapshot is also provided upon Actionflow completion.
DEV-17050 - When "Only allow restricted task plan permissions users" is checked in the System Configuration, any scheduled task plan that attempts and is prevented from running will now appear in the console as a Warning rather than an Error.
DEV-17143 - System Configuration and System Logging have been removed from the Repository browser. They can still be accessed via the Administration menu with the rest of the options.
Analysis Models
None.
Applications
DEV-16233 - When connecting to a default-configured MySQL 8.0 database, it is necessary to specify either serverRsaPublicKeyFile or allowPublicKeyRetrieval on the URL. See https://mariadb.com/kb/en/about-mariadb-connector-j/ for detailed descriptions of these options.
Common Features
DEV-13336 - Email accounts can now be configured to use OAuth 2 authentication.
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 expands any secret tokens into their values.
DEV-15001 - A new System Configuration option "Default Template Package" has been added. Applications being created without a selected template package will use this value for the new application.
DEV-16040 - Improvements to messages returned to the user where there are errors in filtering.
DEV-16284 - Views with two aggregations to the same table now display correctly.
DEV-16322 - When connecting to a default-configured MySQL 8.0 database, it is necessary to specify either serverRsaPublicKeyFile or allowPublicKeyRetrieval on the URL. See https://mariadb.com/kb/en/about-mariadb-connector-j/ for detailed descriptions of these options.
DEV-16403 - Added new geometric functions:
geoUnion which computes a Geometry representing the point-set which is contained in two provided geometries.
geoGetNum which returns the number of Geometries in a GeometryCollection or Multipolygon.
DEV-16556 - Fixed stop() method so only a warning message is generated and it no longer incorrectly triggers an error message.
DEV-16589 - Improvements to the display of 'system errors' to make them more accessible by combining them into a single popup and revising the message.
DEV-16707 - In the Table properties, the option "Audit Manual Changes" has been moved from the Analysis Options section to the Advanced section.
DEV-16922 - The order of the home screen menu options (ERD, Screens etc.) has been revised.
DEV-17019 - There is a new 'Annotation' option in Analysis Models and Actionflow which allows the user to add notes to Models.
DEV-17038 - More descriptive error message added when failing to read data from a table due to configuration issue.
DEV-17185 - A new sql function has been added to PhixScript to facilitate the writing of SQL queries including the "?" query parameter markers so a list of corresponding parameters can be programmatically passed in.
DEV-17227 - Improved layout of the Applications screen to increase the size available for application titles and improved the tooltip.
ERD
DEV-12871 - A new type of table a File Table has been added to ERDs to support the uploading of files using the new File Display component on screens.
Performance
DEV-17103 - Improved performance of running confirmation actions.
DEV-17168 - Improved screen performance when editing screen component properties.
Screens
DEV-9335 - Improvements have been made to simplify how components are added to the screens or in the layers.
DEV-11222 - A default menu button option has been added in default components, used when a screen is dragged onto a menu, allowing for automatic button creation to open the screen.
DEV-12667 - Added right-click options to all major touchpoints where backing attributes can be set, and added icons to distinguish whether a backing attribute has or could be set.
DEV-12756 - Improved consistency of mouse cursors over active screen elements.
DEV-12871 - Added a new type of layout component, the "File Display". This can be used to upload/display previews of files linked to the new File Tables. Dragging a file onto the component will upload it.
DEV-13197 - It is now possible to set a “Default Sort Order" for dropdown components. It allows users to specify the order in which the data of the dropdown is displayed. Sort orders used in this field are saved against the field's backing attribute table.
DEV-14054 - Palettes now have a search box to quickly locate templates.
DEV-14767 - Grids that have no size, and are not set to Fit to available space will now automatically grow to the size of their content.
DEV-15382 - After creating a screen via the Screen window, the user is prompted to select a table to back the screen and also choose any required attributes to be displayed on the screen. In addition, screens can now be created via a new Create Screen button on the ERD toolbar.
DEV-15583 - Input fields cannot be moved inside data-bound components (e.g. Cards, Forms) backed by a table to the table backing the component.
DEV-15585 - Added Actionflow as an option for the Autosave action for views.
DEV-15743 - Layout components that are set to read-only now have an icon to identify them in the Layers and an indicator on their icon in the component properties.
DEV-16086 - Updated the way relation names are displayed.
DEV-16185 - Child components on a screen will now correctly be non-read-only in the case where the 'read-only' override tick box is selected and the read-only option is not set.
DEV-16283 - Improved relationship names on the Available Attribute selector.
DEV-16304 - Kanbans now allow multiple consecutive items to be selected using shift-clicking.
DEV-16473 - Changing a component's name now also updates all expressions referring to the component.
DEV-16489 - When adding a new component to a screen via a template, child objects are given unique names based on the parent and all expressions in the copied template are adjusted to use these names.
DEV-16537 - It is now possible to choose to sort Kanban columns by their column headings and reverse the Kanban column's sequence.
DEV-16558 - When clicking on an existing component on the canvas, the Style tab now opens by default rather than the Properties tab in order to streamline styling. When creating a new component the Properties tab is opened.
DEV-16561 - The component styles section has been improved by renaming "Autosize/grow" to "Fit to available space" and some related settings have been reordered.
DEV-16664 - Form field validation will be enforced by default when corresponding actions are run on newly created actions.
DEV-16667 - Deleting a screen when it is the only screen to use an area will now also delete that area (does not affect the template version)
DEV-16782 - The following alterations have been made to items in the Serene Grey template package:
* The minimum width of Tiles has been increased from 130px to 260px. This still supports viewing on mobile devices. The content which overflows outside of a tile is also now hidden so it does not exceed the borders of the tile.
* Horizontal and Vertically expanding tiles have been reworked to simplify the CSS used to achieve this mechanism. The Chevron direction has also been changed to better indicate the direction of expansion.
* There is a new Concertina Tile that provides several expanding areas in a single tile space.
* Tab headers text has been set up so the text which is too long to fully display will have ellipses added to the end. For example: "PhixFlow Inv..."
* The UID form field template has been removed from all card containers.
* The labels on form fields have been moved left to better align with the input field.
DEV-16844 - There is a new option for Dropdown Fields: Do Not Trigger Automatic Data Refresh in the advanced section. Ticking it stops any data-bound components (Grids, Cards) driven by the Dropdown from automatically refreshing when the value in the Dropdown changes.
DEV-16845 - There is a new option for Date and DateTime Fields: Do Not Trigger Automatic Data Refresh. Ticking it stops any data-bound components (Views, Cards) driven by the Field from automatically refreshing when the value in the Field changes.
DEV-16898 - The names of the "Add new" and "Create Menu" buttons on the Screens page have been revised to "Add Screen" and "Add Menu" respectively.
DEV-17055 - If a field is backed by an Attribute, the Attribute's type is used during the field validation. It ensures that input fields backed by Attributes can accept only values valid for the Attribute. Fields backed by Integer attributes now check if the value provided is a valid Integer without any decimal numbers. Fields backed by Float or Decimal attributes now check if the value provided is a valid Number. This can be overridden by setting a custom Validation Type on the field.
DEV-17058 - Improved performance of copying components/saving components as templates.
Workflow
None.
Bug Fixes
Actionflows
DEV-15855 - Using a View action to find a record that has just been inserted by a Save action will no longer give a type conversion error.
DEV-15897 - Fixed some action nodes not being able to connect directly to the output points.
DEV-16064 - Email actions are now passthrough.
DEV-16117 - Resolved rare null pointer exception when using Actionflows.
DEV-16229 - Improved performance of opening the Mapping Configuration screen for Actionflows.
DEV-16302 - Dropping an Actionflow output point onto an end loop action now creates the connector to the driving output of the end loop node.
DEV-16470 - Deleting the screen backing an Actionflow 'Open Screen' node will no longer cause the action to fail due to mapping issues.
DEV-16517 - Opening an application while another application is opening will no longer sometimes cause both applications startup screens to display.
DEV-16638 - Actionflows will now ignore incomplete recordsets except those created in the same Actionflow.
DEV-16658 - Deleting an Action Task from a Task Plan will now correctly delete the associated instance of the Actionflow.
DEV-16712 - Embedded Actionflows will always run their first phase regardless of the phase they are embedded within. It is not valid for the embedded Actionflow to trigger other phases.
DEV-16847 - Resolved an issue where highlighting an action connector would sometimes cause the arrowhead to display in the wrong place.
DEV-16970 - Actionflow lookups will no longer fail if the action is run from a confirmation button and no record was selected for that input on the original action run.
DEV-16993 - By default the order of processing of Actionflows will maintain record order. Added a new option to Actionflow nodes to process the records in parallel, if checked the action may process faster but the order of records will not be deterministic.
DEV-17007 - Fixed action nodes not moving vertically above the top boundary of the canvas.
DEV-17027 - Within an Actionflow, where the first action of a nested Actionflow is a start loop action, it will no longer prevent passthrough of attributes on the outer action.
DEV-17032 - Importing a package that contains an action will no longer delete mappings to instances of that action that exist in other applications.
DEV-17153 - Reusing a nested Actionflow which contains a loop will no longer intermittently cause values to be applied incorrectly.
DEV-17201 - Added autocomplete for attribute names in expressions to all Actionflow nodes.
DEV-17205 - Dragging a Screen onto an Actionflow will now always correctly display the Open Screen node without waiting for a manual refresh.
DEV-17280 - Fixed an issue where Actionflows that open multiple screens would sometimes not open all of them.
DEV-17305 - Fixed an error when HTTP Actionflow nodes received nothing back as the response of an HTTP request.
DEV-17316 - When moving multiple action nodes in a short time span the nodes will no longer change location erratically.
Administration
DEV-15639 - Sorting the system console and other similar grids will now sort based on all records not just the current page.
DEV-16007 - Fixed rollback not working when “Only allow restricted task plan run permission users” is ticked.
DEV-16070 - A new tab has been added to the System Console which filters to only display Daily Logs.
DEV-16135 - The grid to show log messages for the currently selected running tasks now automatically refreshes to show new messages.
DEV-16281 - When an application containing scheduled task plans has been deleted, PhixFlow will no longer attempt to run those task plans.
DEV-16524 - Fixed migration script not running properly for Oracle databases with data in the font_size column for style.
DEV-17021 - Fixed post-migration issue, resulting in a 'QuerySyntaxException' triggered after editing custom logfile filters.
DEV-17099 - System Console grids now correctly display the 'Restore files' option.
Analysis Models
DEV-15070 - Analysis actions now only allow transactional tables to be included to ensure correct model operation.
DEV-16160 - Previously, when a database exporter was connected to multiple pull pipes, the input multiplier was evaluated for the driving push pipe and then re-evaluated for each of the pull pipes in turn. Now, the expression is evaluated only once, for the driving push pipe, and the result is re-used for each of the pull pipes without re-evaluating the expression.
DEV-16477 - Saving an Analysis Model after having moved the view and then adding a new object will no longer cause that object to move.
DEV-16534 - Fixed bug when processing JSON with arrays of objects from an HTTP Collector.
DEV-16697 - Fixed comments stripping within SQL expressions so that the comments are correctly removed after an escaped quote mark or double quote mark. For example, strings of the form 'Wouldn\'t it be nice', the apostrophe in the text is escaped and included in the comment now.
Option added on database exporters and collectors to choose whether to strip white space.
For migrated nodes the setting is enabled to match current behaviour.
For newly created nodes this defaults to false as it can cause issues when some styles of comments are used (e.g -- comment).
Applications
DEV-17108 - PhixFlow now correctly displays the Home Screen Message HTML (rather than the default text) on the login screen which is displayed after a logout.
Common Features
DEV-16004 - Table actions now respond to cancellation by the user; new record sets are marked as incomplete.
DEV-16154 - Exporting Audit Records to Excel now works correctly.
DEV-16294 - For views, in app mode, it will now only show the filters listed on the view in the section App Mode Filters. If you create the filter on the view grid then it will be visible in app mode but if it is created elsewhere then it will not be available in app mode by default.
DEV-16344 - Missing error messages in import.
DEV-16400 - Fixed error refreshing data on aggregate view with missing attributes.
DEV-16594 - User Detail view of a User Group now includes the last activity time.
DEV-16656 - Default Application and Default Screen have been removed from user configuration as they weren't functional. Startup actions can be used to control which screen an application initially displays.
DEV-16673 - Setting the locale when creating a user no longer errors.
DEV-16685 - Pie charts now export correctly.
DEV-16862 - Deprecated drivers have been removed from the available drivers list where they are not in use.
DEV-16883 - Fixed a bug where the first parameter of an AND function was ignored if it evaluated to null whereas if any other parameter evaluated to null it was treated as false. All parameters to the AND function, including the first one, are now treated as false if they evaluate as null.
DEV-16948 - Resolved an issue where sort order directions were not being applied on pipes configured with aggregating attributes. Sort-order directions are now correctly applied.
DEV-16949 - Fixed regression with displaying legacy Form Views.
DEV-17000 - Fixed error when opening a view with a relationship to a table with invalid data.
DEV-17061 - Fixed issue where fields having number formats configured with 'suppress trailing zeros' would sometimes ignore the decimal places setting. This resulted in ".0" being displayed for whole numbers when decimal places were set to 0.
DEV-17063 - Fixed the cause of the error message 'Could not copy property filterId' shown when adding a new form after deleting the old one. This occurred if the element had a default filter set.
DEV-17076 - Filters can now be applied to relational aggregate views.
DEV-17086 - Form fields backed by Table Attributes now correctly have the Aggregate Function and Filter options available in their properties.
DEV-17104 - Improved support for language translation of the main PhixFlow interface.
DEV-17118 - Using 'is in' in a filter on a View Action on SQL Server now works without errors when using lists longer than the value of sqlserver.filter.maxInlineListSize=10 in the server.properties file.
DEV-17133 - HTTP Collector and Exporter timeouts can now be specified on the HTTP Datasource. This value will override the default connection timeout, request timeout and socket timeout set in server.properties. The non-working timeout settings on the HTTP Collector and HTTP Exporter have been removed.
DEV-17134 - Table filters are now shown in the filter dropdown on the properties for relational fields.
DEV-17211 - Formatting and Actionflow nodes now all support autocomplete in expression editors.
DEV-17225 - Changed filter expression fields to use a new expression editor, allowing autocomplete of fields and functions. These fields are now highlighted by a green border.
DEV-17298 - PhixFlow now correctly supports special characters in translation files.
ERD
DEV-16075 - Table attributes that are flagged as 'Foreign Key' are now automatically considered to be 'Indexed'.
DEV-16186 - Setting Return All Attributes no longer causes an error for Tables with Local attributes.
DEV-16256 - ERD connectors are now correctly directed.
DEV-16694 - Resolved issue where connectors on ERDs would sometimes appear to point into empty space.
Performance
DEV-16380 - Improved performance of opening / refreshing Screens.
DEV-16423 - Improved performance of opening Screen properties.
DEV-16498 - Reduced PhixFlow memory usage at an overall architectural level.
DEV-17089 - Changing user group membership will no longer have a performance impact on opening screens.
Screens
DEV-15395 - Double-clicking on a record is now disabled whilst the record is being autosaved.
DEV-15778 - Sort order attributes are now sorted by their display label.
DEV-15832 - When creating a screen within a package, the list of available templates is restricted to only show those in the package.
DEV-15956 - Resolved an issue where the Read-only setting was applied even when the apply read-only checkbox was unchecked.
DEV-16085 - Empty numeric form fields no longer incorrectly show as 0.
DEV-16236 - Resolved issue with Style attributes being wrongly inherited even when they were not enabled in the parent style.
DEV-16255 - Input Fields now correctly inherit the 'mandatory' flag from backing Table Attributes.
DEV-16267 - The On Click Event Handler on an area component now supports the option "Other". This allows action types like "screenshot" and "toggle maximise" to be set.
DEV-16268 - Driven Kanbans now display correct records after changing the driving selection.
DEV-16386 - Add the 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.
DEV-16387 - Fixed a problem with an error being displayed while editing a Screen containing Views with Table Action Menu Items.
DEV-16390 - Added the 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-16391 - The Minimise button now appears on screen windows by default.
DEV-16459 - Moving fields backed by relational Table Attributes around a Screen now works correctly.
DEV-16496 - Expressions in Shared Styles are now correctly re-evaluated when a screen is resized.
DEV-16506 - Dropping Table Attributes onto Cards now works correctly.
DEV-16554 - Screen Elements with Background Filter Rules now save correctly.
DEV-16575 - Background Filter Rules now add correctly to Dropdown Fields backed by relational attributes. The 'Add Filter' button now adds correctly to Dropdown Fields backed by relational attributes.
DEV-16577 - Read-only settings are now reliably propagated to child components.
DEV-16728 - Fixed regression where the CSS property "Display: none" was being ignored, components are now correctly hidden when the CSS property is set.
DEV-16753 - Dragging Tabs now works correctly when adding/reordering Tabs.
DEV-16904 - Fixed Dropdowns now correctly display the current record's value, even if it is not one of the Dropdown's allowed values.
DEV-16914 - Screens now have an interactive floating menu that appears on components on mouseover. The new menu has been added to provide quick access to key tasks, including accessing styles, field validation and defining backing data. It is available on screens when unlocked in Design mode.
DEV-17022 - Editing Card Components and Views no longer displays a 'cannot cast to class' error for users without the VIEW_PRIVATE_CONFIG permission.
DEV-17074 - Preferred Parent Type in nested components are now correctly copied when creating new components.
DEV-17091 - Dropdown Fields backed by a foreign key now correctly update form records.
DEV-17109 - Fixed problem with setting new form after deleting the old one, if the old had a background filter rule set on the element.
DEV-17172 - Fixed problem with Component Types duplicating when copying Layout Components from the palette.
DEV-17197 - A ticked style setting without a value now correctly overrides any inherited values using a default of 0. For instance, if margin or padding is ticked without any value this is equivalent to setting a value of 0.
DEV-17212 - Fixed problem with field labels being renamed when creating components from templates.
DEV-17252 - Having two table view components backed by the same table view on the same screen will no longer cause Actionflows to sometimes use incorrect records.
DEV-17272 - It is no longer permitted to change the screen configured on an Open Screen Action, instead create a new action.
DEV-15943 - Performance has been improved for opening lists of Actionflows throughout the product.
DEV-16097 - Fixed memory leak when lookups are used in Actionflows.
Workflow
None.
Release All 10.0+
Introduction
The following are links to the PhixFlow release notes for all Version 10 product updates:
Release 10.0.0
Release 10.0.1
Release 10.0.2
Release 10.0.3
Release 10.0.4
Release 10.0.5
Release 10.0.6
Release 10.0.7
Release 10.0.8
Release 10.0.9
Release 10.0.10
Release 10.0.11
Release 10.0.12
Release All 9.0+
Introduction
The following are links to the PhixFlow release notes for all Version 9 product updates:
Release 9.0.0
Release 9.0.1
Release 9.0.2
Release 9.0.3
Release 9.0.4
Release 9.0.5
Release 9.0.6
Release 9.0.7
Release 9.0.8
Release 9.0.9
Release 9.0.10
Release 9.0.11
Release 9.0.12
Release 9.0.13
Release 9.0.14
Release 9.0.15
- No labels