January 2023 Dashboard Release Notes
Release Name - pi.2023_01_26
Release Date - Jan 31, 2023
We are pleased to present our latest offering of pi - our January 2023 release! This page helps summarise and familiarise you with the changes we have made and is supported (where applicable) with useful videos to help explain the changes we have delivered.
Before upgrading, we always recommend that you take a backup of your dashboard. You can find more information here.
Before upgrading, we always recommend that you review ALL release notes, from the version you are considering upgrading from and to. This is essential should there be a material change that could impact you or your customers. Where possible, upgrading to a test instance first can be helpful.
Here’s what we’ll cover.
- 1 Added
- 1.1 Additional options added to the Configuration Tool User Interface (UI)
- 1.2 User fields added to the Configuration Tool UI to manage Windows Services
- 1.3 Performance - efficiencies when displaying content, plus addition debugging messages to help diagnosing Category Objects performance
- 1.4 Ability to align chart X and Y axis labels
- 1.5 Additional styling elements added to Themes
- 2 Changed
- 3 Fixed
- 3.1 Returning the correct API error code when incorrect log in details are provided
- 3.2 Newly added data tables on the connection screen don’t 100% overlap
- 3.3 IN ( ) statement adjustment for Chart SQL
- 3.4 Category Filters scrolling issues when displayed on the top
- 3.5 Card Chart editing screen, amended so that drop down panels appear in front of other open UI elements for easier editing
- 3.6 Drill to charts amended to cater for condition defined to compared values in a measure
- 3.7 Identifying application’s URL when using a proxy server / load balancer
- 3.8 Windows Services not being removed where multiple dashboards are running in parallel / install directory renamed
- 3.9 PDF export not respecting padding settings
- 3.10 Merged Tables missing content in PDF exports / preview of merged tables corrected
- 3.11 Entity codes for escaped characters being displayed in Tooltips
- 3.12 Report Filters not applied to merged tables/charts in a report
- 3.13 Search icon / magnifying glass in a Multi-picker overlapping the category objects with long names
- 3.14 Prevent Users from using last password(s) settings not accepting 0/zero
- 3.15 Charts appearing blank with multiple dimensions
- 3.16 Able to go past the last page of data of a paginated table, when it should not be allow
- 3.17 Overlapping messages on Doughnut and Doughnut Variable Radius charts when the “Show Data Total and Mean” Attribute is selected and the chart has no data
- 3.18 The ‘Reload default settings’ button doesn’t reload the default values on both the Renderer and the Scheduler tabs of the Configuration Tool UI
- 3.19 Pagination page number is not centralised
- 3.20 Merged Chart not displaying when one of the charts doesn't have data
- 3.21 Pie & Doughnut Charts - not showing data values when charts are small in size
- 3.22 Drill down functionality not working when a special character exists in an object name
- 3.23 Upgrading on Windows from old versions of Dashboard may not add in new features
Added
Additional options added to the Configuration Tool User Interface (UI) | Configuration-Tool#96 | 19080 | Configuration Tool |
The UI for the Configuration Tool now includes more options on the ‘Repository’ and ‘Renderer’ tabs as well as two additional tabs for ‘Excel Reader’ and ‘Pirana’ settings. Whilst these options can now be set in the UI when they couldn’t before, none of them are new - as they were all previously available to be set through environment variables or by editing the configuration file (dashboard.json) directly.
User fields added to the Configuration Tool UI to manage Windows Services | pi#432 | 15283 | Configuration Tool |
Two new fields for User Account Name and User Account Password have been added to the Configuration Tool UI across all services tabs to manage the Windows services. The fields have also been added to default.json file with the default value of Local Service to run Windows services.
The ‘User Account Name’ field will specify the account under which the service should run. The account name should be represented in the form of DomainName\UserName. If the user account belongs to the built-in domain, you can specify the user account name as .\UserName.
New environment variables have also been added for the user name and password across different services; these can be found in the following documentation: Environment Variables
Example of the new User fields in the Configuration Tool UI for the Scheduler service:
Performance - efficiencies when displaying content, plus addition debugging messages to help diagnosing Category Objects performance | pi#1493 | 23827 | Category Objects / Performance |
Added additional debug messages to help diagnosing category objects performance. Also, implemented performance enhancement to solve slowness when data connection has lots of content.
Ability to align chart X and Y axis labels | pi#808 | 11210 | Chart Display / Functionality |
Within the Chart Editing Screen, options have been added to enable;
the text labels on the x axis can be aligned to left, centre, right
the text labels on the y axis can be aligned to top middle, bottom
Additional styling elements added to Themes | pi#825 | 9733 | Themes |
We have enabled the ability to style 2 new parts of the dashboard in themes:
The titles for variable names and restrictions - these are found under the ‘settings’, ‘users’ and ‘roles’ tabs in the dashboard. You can style these with the field ‘.pi-header-label' which is found under the main 'dashboard’ tab of the themes editor.
The login username & password input fields - specifically, you are now able to change the background colour. In order to do this you also have to set the key & values ‘-webkit-box-shadow: 0 0 0 30px transparent inset;’ to be able to see your background colour changes applied.
Changed
Linux Services - managing services with systemd | configuration-tool#99 | 19373, 23506 | Dashboard Services |
Improved the way the service status is being recorded with systemd. Any errors during the start up of the services will now be recorded in the command line while using ./configuration-tool. Also, changed the way of how the executables are called for all the services to improve the reliability.
Prevented sensitive values being visible in the dashboard and when using the API | pi#1443 | 23174 | Settings Tab / API |
To improve security in the dashboard, a number of values in the Settings tab have been altered so that their values are no longer visible in the dashboard. The UI will instead display an obscured value corresponding to a generic reserve password when a password is present. This generic reserve password (?-3!present!2-?) will now also be returned as the value when accessing this information via the API instead of the sensitive value.
The values affected include:
AWS Secret Access Key
SMTP password
OAuth - API Key
OAuth - API secret