6.2-r4

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.4

• Translations - Prompt the user to input an API key to use Google Translations when retrieving a suggested translation. This API key was stored in the application code, but because it can be revoked or changed at any time it was wise to remove it and have users input it instead. DEV-1978, PR-1196
• Translations - Prompt the user to login again by opening the login modal when a user tries to save any new/updated translations when the current session has expired. This fixes an issue where users would lose all their translation changes when trying to save with an expired token. DEV-2063, PR-1189
• Workspaces - Fix how the workspace period filter handles validating and updating big values. It used to change both the to and from value when either one was invalid. This change fixes this so only the invalid value is changed to the max/min valid value. DEV-1962, PR-1187
• Workspaces - Fix: When series are updated and there is a config under row.uniqueKeyColumns, the query submitted to update (and refresh) should use the specified unique key columns instead of copying all non-serie columns in the view. DEV-1463, PR-1193
• Workspaces - Clear cache after saving default config DEV-1891, PR-1210, PR-1212
• Workspaces - Fix how the workspace period filter handles validating and updating big values. It used to change both the to and from value when either one was invalid. This change fixes this so only the invalid value is changed to the max/min valid value. DEV-1962, PR-1187

API 6.2.4

• Event Logging - Fixes to forecast event logging DEV-2062, PR-1211

Databases 6.2.4

• Cleanup - Removing fill factor and other unnecessary index options DEV-1906, PR-1203
• Correlated/Similar Items Workspace - Added correlated/similar items database objects to core DEV-2084, PR-1216
• Data Mapping - Making sure views are refreshed in the data transfer in order to have the correct data types DEV-1980, PR-1176
• Item Card - Loading vdailydemand into table variable to improve performance DEV-2047, PR-1180
• Orders - fix: When manual orders were created multiple order routes were falsely stopped by sanity check DEV-2001, PR-1184
• Orders -Fix order line breakdown to properly reflect lost sale now that it's not a true/false anymore but a percentage DEV-2076, PR-1206
• Update Script - fix: orderlogicsetting change from string to tinyint must translate values in pre migration step DEV-2075, PR-1182
• Update Script - fix: Create missing settings groups and move the creation of the core.setting table out of the pre-update script DEV-2077 DEV-2089, PR-1201 PR-1217