June 2023 Dashboard Release Notes

Open

June 2023

Always use the latest point release (if available) for any major version as it will contain important changes.

We are pleased to present our latest offering of pi - our June 2023 product release! This page helps summarise the areas of the dashboard we have Added, Changed, or Fixed meaning you can make a quick and informed decision on when to upgrade to the latest release.

Here is what is included in the release.

Added

We have added the ability to add roles to a schedule, allowing all of the users within that role to receive an email when the schedule is sent out. There is a 2nd panel within the ‘Recipients and Recurrences’ table which allows you to configure this.

Open

• The users added from the role will not include the dashboard super admin user

• Any duplicates within separate roles or roles and individual users will be added anyway, meaning a user may receive 2 or more emails if configured as such

• If a role does not have collaborate permission, then it will not appear in the drop down list

• If a role contains users which do not have an email, the role will appear in red and you will see a warning in the tooltip

• Upon deleting a role, the role link to the schedule will be deleted too

• You are now able to save a schedule if it has a role added, but no individual user or external email added

It is now possible to vertically align text elements in card charts.

This can be achieved by selecting a text element in the card chart in the chart editor panel, opening the advanced options and selecting a setting for the “Vertical Align” field.

When selecting an option (top, middle, or bottom), the text in the given text box will align to the relevant location.

Previously, the vertical alignment of text within a table cell is fixed at being centred.

Now, a new CSS class has been added (under the “Table” tab of the theme settings screen) that allows you to override this default. The new class is called “.pi-style__table-body-cell .ag-cell-wrapper” and the vertical alignment can be dictated with the “align-items” property. A value of “flex-start” will vertically align the text to the top of the cell, “flex-end” will align it to the bottom, and “center” will act the same as the current default.

It is now possible to exclude charts from the cache to ensure that they always reload data from the database when they are displayed. This means that data will be up to data when drilling to charts and tables, data will be updated where it has changed on the next level. Changes submitted in editable tables will also be visible when drilling up to the chart above.

To choose to exclude a chart from the cache you can tick the “Exclude Chart From Cache” option in the chart editor configuration tab.

Previously, when adding a table from a Data Connection the ‘Name’ field is auto-populated with a space separated equivalent of any columns written in snake_case.

Now, this auto-parsing behaviour has been extended to include columns written in both camelCase and PascalCase.

The Category ID for the relevant chart, the one that the chart in question is refreshed within, is now being recorded in the ‘detail_info’ column for the ‘Chart Fetch From DB’ audit.

Changed

Removed Apache Commons library which was included in the product, but no longer needed.

As part of our commitment to security, we’ve upgraded a number of 3rd party libraries to newer versions.

Fixed

Some users had reported seeing unexpected characters in CSV exports when opening them locally.

This was due to some programmes (including Microsoft Excel) using incompatible encoding for the data when opening the file. This has now been resolved by pre-pending the file with a byte order mark to ensure the programme uses UTF-8 as standard when opening the file.

Fixed an issue where a non super user administrator could not save changes made in the User Access screen.

Fixed an issue when a standard administrator user could not save themes, unless they were the super administrator. This has been resolved.

Schema Changes