
6.2-r5	master	2021-02-23T14:39:12Z		6.2.5	6.2.5	6.2.5	0 / 17	6.2-r5.zip 6.2-r5.zip
6.2-r5 Database Update Scripts Check out the update reports for updating and patching in the dbscripts\comparereports folder of the release zip file. (Note that all schema changes listed in the patch reports are applied every time you patch the databases, so please check the report and see if you have any customisations in the objects listed there.) Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See list on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.2.5 `Item Card` - Set the min and max values for the x-axis in the Item Card chart so that the x axis doesn't change when series are hidden. With this change the x-axis values in the chart should always reflect the period range (history/forecast) values selected. DEV-2123, PR-1265 `Reports` - Fix error where report could not be saved because of an error in the Advanced Filter. Handle the error gracefully in the client. DEV-2107, PR-1272 `Workspaces` - Added a new config item to workspace column config "link". It is possible to specify a list of drilldowns that should be explicitly closed in the transferred view. DEV-2124, PR-1263 `Workspaces` - Fix issue where grid and cell focus was lost after updating the checkbox value of an editable checkbox-cell in the workspace view. This made it impossible to navigate and update the grid using the keyboard (space and arrow keys). DEV-2065, PR-1288 API 6.2.5 `User Management` - Clear encrypted password from API response DEV-1874, PR-1253 `User Management` - Flag deleted users instead of deleting them from the database. DEV-2127, PR-1289 `User Management` - Change verification check when checking if email exists for user so it ignores deleted users (e-mail can therefore be reused). Fix unique key constraint when dealing with email for deleted users. DEV-2127, PR-1289 Databases 6.2.5 `Audit db` - fix: `Add zys.generate_sql`. DEV-2088, PR-1218 `Actions/Executions` - Use named parameters for `dbo.de_execute_action`. DEV-2128, PR-1280 `Dashboard / Key Reports` - Adding nightly refresh to key report item count. DEV-2093, PR-1258 `Helper Objects` - Add `zys.generate_sql`. DEV-1864, PR-1227 `Item Card` - Using `hidden_in_chart` in `chart_item_select`. DEV-2054, PR-1255 `Logging/System Status` - Fix error when app server is logging big stack traces. DEV-2134, PR-1281 `Orders` - fix: Using access-group restrictions made orders disappear if some items were closed while the order is still in process DEV-2104, PR-1239 `Orders` - Override and backup the `dbo.orders_update_values_custom` procedure on database update. Consultants will have to manually move any customisations from the backup to the standard procedure which has changed significantly. DEV-2137, PR-1276 `Update Script` - Fix db various migration issues DEV-2102, PR-1237, PR-1245, PR-1242 `Workspaces` - Change description column in `data_element_calc/ref_columns` to `nvarchar(max)` DEV-2085, PR-1243

6.2-r5

Database Update Scripts

Check out the update reports for updating and patching in the dbscripts\comparereports folder of the release zip file. (Note that all schema changes listed in the patch reports are applied every time you patch the databases, so please check the report and see if you have any customisations in the objects listed there.)

Known Issues/Bugs

Unaddressed issues in JIRA

Issues

Issues that were addressed and fixed in this release

See list on Jira
See list of pull requests involved in this update on GitHub
See code changes on GitHub compare

Client 6.2.5

Item Card - Set the min and max values for the x-axis in the Item Card chart so that the x axis doesn't change when series are hidden. With this change the x-axis values in the chart should always reflect the period range (history/forecast) values selected. DEV-2123, PR-1265
Reports - Fix error where report could not be saved because of an error in the Advanced Filter. Handle the error gracefully in the client. DEV-2107, PR-1272
Workspaces - Added a new config item to workspace column config "link". It is possible to specify a list of drilldowns that should be explicitly closed in the transferred view. DEV-2124, PR-1263
Workspaces - Fix issue where grid and cell focus was lost after updating the checkbox value of an editable checkbox-cell in the workspace view. This made it impossible to navigate and update the grid using the keyboard (space and arrow keys). DEV-2065, PR-1288

API 6.2.5

User Management - Clear encrypted password from API response DEV-1874, PR-1253
User Management - Flag deleted users instead of deleting them from the database. DEV-2127, PR-1289
User Management - Change verification check when checking if email exists for user so it ignores deleted users (e-mail can therefore be reused). Fix unique key constraint when dealing with email for deleted users. DEV-2127, PR-1289

Databases 6.2.5

Audit db - fix: Add zys.generate_sql. DEV-2088, PR-1218
Actions/Executions - Use named parameters for dbo.de_execute_action. DEV-2128, PR-1280
Dashboard / Key Reports - Adding nightly refresh to key report item count. DEV-2093, PR-1258
Helper Objects - Add zys.generate_sql. DEV-1864, PR-1227
Item Card - Using hidden_in_chart in chart_item_select. DEV-2054, PR-1255
Logging/System Status - Fix error when app server is logging big stack traces. DEV-2134, PR-1281
Orders - fix: Using access-group restrictions made orders disappear if some items were closed while the order is still in process DEV-2104, PR-1239
Orders - Override and backup the dbo.orders_update_values_custom procedure on database update. Consultants will have to manually move any customisations from the backup to the standard procedure which has changed significantly. DEV-2137, PR-1276
Update Script - Fix db various migration issues DEV-2102, PR-1237, PR-1245, PR-1242
Workspaces - Change description column in data_element_calc/ref_columns to nvarchar(max) DEV-2085, PR-1243