
6.2-r3	master	2021-01-28T13:50:13Z		6.2.3	6.2.3	6.2.3	1 / 31	6.2-r3.zip 6.2-r3.zip
6.2-r3 What's new? `Translations` - New translations feature which enables CRUD (Create, Read, Update, Delete) interactions with the translations on the AGR Pool cloud server. Users can maintain translations for all deployed systems (wherever in the world) running AGR v6.2 or newer from within the AGR app itself. DEV-1755, PR-1088 System users will need to login to the AGR Pool cloud service with separate credentials to enable the edit mode. All translation changes are staged and have to be manually saved by clicking the save button. Any staged changes can be undone/reset from the info sidebar. Translating to a new language can be amazingly fast using the new magic button which suggests a translation from Google based on the current english translation. When translating the application it is possible to turn off the default translation fallback behaviour to visualize all the untranslated strings for the selected language in the app. 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 There are known issues within the upgrade scripts between minor versions, i.e. the scripts to upgrade from 6.1->6.2 are broken and those issues are planned to be fixed in 6.2-r4 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, on the 6.2 release branch + these pull requests on the develop branch See code changes on GitHub compare Client 6.2.3 `Format` - Fix how durations are processed and formatted in the app. These changes enable us to use both `Date` objects and rounded/integer `number` values in milliseconds to store durations and display in the app. DEV-1858, PR-1051 `Grids` - Fix: issues that cause grid to re-sort after cell edit. DEV-1909, PR-1072 `Grids` - Fix: Distinct aggregation with grouping broke the grid when date fields were included in the grid DEV-1839, PR-1135 `Item Card` - Fix issue where grid was not displaying series data on the week level, when the start of week is not Monday (i.e aggregated to another day in `chart_item_select`). The `item_card_start_week` property was added to `dbo.settings` so the start of week can be changed. DEV-1948, PR-1057 `Item Card` - Fix issue where the forecast series in the Item Card chart was not displayed correctly when the start of week is not Monday (i.e aggregated to another day in `chart_item_select`). After these changes the forecast should be correctly placed and the helper/grid lines (tickInterval) in the chart are also moved to align with the newly added `item_card_start_week` setting. DEV-1960, PR-1099 `Item Card` - Make the week indication label on the x-axis optional in the Item Card chart. By setting the newly added `item_card_hide_week_number` setting to `true` the chart label will dislpay e.g. `7. Dec'20` instead of `w50 - Dec'20`. PR-1099 `Item Card` - Make the chart config visibility setting actually affect the default visibility for series. With this change, if the `"visible: false"` setting is set in `dbo.chart_elements.highcharts_series_options` the series will be hidden by default. DEV-2055, PR-1167 `Item Card` - Open datepicker for editable date values in item card details on previously selected date to improve the user experience. DEV-2064, PR-1166 `Item Card` - Open datepicker for editable date values in item card details on previously selected date to improve the user experience. DEV-2064, PR-1166 `Item Card` - Make the chart config visibility setting actually affect the default visibility for series. With this change, if the `"visible: false"` setting is set in `dbo.chart_elements.highcharts_series_options` the series will be hidden by default. DEV-2055, PR-1167 `Navigation` User that does not have access to any feature in a sub-menu will not see the empty sub-menu button. DEV-1868, PR-1073 `Translations` - New translations feature which enables CRUD (Create, Read, Update, Delete) interactions with the translations on the AGR Pool cloud server. Users can maintain translations for all deployed systems (wherever in the world) running AGR v6.2 or newer from within the AGR app itself. DEV-1755, PR-1088 System users will need to login to the AGR Pool cloud service with separate credentials to enable the edit mode. All translation changes are staged and have to be manually saved by clicking the save button. Any staged changes can be undone/reset from the info sidebar. Translating to a new language can be amazingly fast using the new magic button which suggests a translation from Google based on the current english translation. When translating the application it is possible to turn off the default translation fallback behaviour to visualize all the untranslated strings for the selected language in the app. `Workspaces` - Add dynamic query for action modal select options. DEV-1819, PR-1050 `Workspaces` - Fix column formatting assumption happening when a column name contains the word 'price'. PR-1074, DEV-1890 `Workspaces` - Filter drilldown be present viewfilter of same column DEV-1893, PR-1116 `Workspaces` - Fix: the edit-ability of the column in a total row when there is conditional editing on the column. For example with this column configuration on the weight column in a view with item no and weight present DEV-1577, PR-1140 `Workspaces` - Fix "selectedObj" attributes sent in workspace commands DEV-1911, PR-1150 `Workspaces` - Add a loading indicator to workspace lookup cell-editor. DEV-2061, PR-1154 `Workspaces` - Cache the lookup values query result when opening the workspace lookup cell-editor so that future requests are resolved immediately. DEV-2060, PR-1154 `Workspaces` - Make workspace lookup cell-editor display lookup options a lot quicker by only rendering a portion of items in the DOM. This is done by enabling the virtual scroll for the ngSelect component. DEV-2067, PR-1165 API 6.2.3 `App Service` - Fixes app-service restart state in core.event log, notification ordering in drop down menu and clear own notifications from drop down menu DEV-1850, DEV-1924, PR-1164 `Orders` - Faster paste (bulk update) in orders grid. DEV-1912, PR-1061 `Orders` - Timeout for manual orders extended to 4hrs DEV-2052, PR-1132 Databases 6.2.3 `Demand Run` - Fix issues with malformed reports halting the demand run DEV-1959, PR-1065 `Data Mapping` - Fix datatype to TINYINT for Price Includes VAT column in nav.Item table DEV-1949, PR-1066 `Data Mapping` - Standardising NAV datamapping for product groups to avoid duplications DEV-1953, PR-1142 `Data Mapping` - Forctype column in itemdetails not populated in inventory datamapping DEV-2049, PR-1161 `Data Mapping` - Exclude abc_grouping from inventory datamapping DEV-2053, PR-1160 `Item Card / Settings` - Add the `item_card_hide_week_number` property to the `dbo.settings` table to hide/show the week label when the Item Card chart is viewed on the weekly level. PR-1099 `Settings` - Add the `item_card_start_week` property to the `dbo.settings` table to control which day of the week series are aggregated to when looking at the Item Card Grid in weekly view. DEV-1948, PR-1057 `Split by Constraint` - fix: split by constraint logic broken if using fillup. DEV-1991, PR-1109

6.2-r3

What's new?

Translations - New translations feature which enables CRUD (Create, Read, Update, Delete) interactions with the translations on the AGR Pool cloud server. Users can maintain translations for all deployed systems (wherever in the world) running AGR v6.2 or newer from within the AGR app itself. DEV-1755, PR-1088
- System users will need to login to the AGR Pool cloud service with separate credentials to enable the edit mode.
- All translation changes are staged and have to be manually saved by clicking the save button. Any staged changes can be undone/reset from the info sidebar.
- Translating to a new language can be amazingly fast using the new magic button which suggests a translation from Google based on the current english translation.
- When translating the application it is possible to turn off the default translation fallback behaviour to visualize all the untranslated strings for the selected language in the app.

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
There are known issues within the upgrade scripts between minor versions, i.e. the scripts to upgrade from 6.1->6.2 are broken and those issues are planned to be fixed in 6.2-r4

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, on the 6.2 release branch + these pull requests on the develop branch
See code changes on GitHub compare

Client 6.2.3

Format - Fix how durations are processed and formatted in the app. These changes enable us to use both Date objects and rounded/integer number values in milliseconds to store durations and display in the app. DEV-1858, PR-1051
Grids - Fix: issues that cause grid to re-sort after cell edit. DEV-1909, PR-1072
Grids - Fix: Distinct aggregation with grouping broke the grid when date fields were included in the grid DEV-1839, PR-1135
Item Card - Fix issue where grid was not displaying series data on the week level, when the start of week is not Monday (i.e aggregated to another day in chart_item_select). The item_card_start_week property was added to dbo.settings so the start of week can be changed. DEV-1948, PR-1057
Item Card - Fix issue where the forecast series in the Item Card chart was not displayed correctly when the start of week is not Monday (i.e aggregated to another day in chart_item_select). After these changes the forecast should be correctly placed and the helper/grid lines (tickInterval) in the chart are also moved to align with the newly added item_card_start_week setting. DEV-1960, PR-1099
Item Card - Make the week indication label on the x-axis optional in the Item Card chart. By setting the newly added item_card_hide_week_number setting to true the chart label will dislpay e.g. 7. Dec'20 instead of w50 - Dec'20. PR-1099
Item Card - Make the chart config visibility setting actually affect the default visibility for series. With this change, if the "visible: false" setting is set in dbo.chart_elements.highcharts_series_options the series will be hidden by default. DEV-2055, PR-1167
Item Card - Open datepicker for editable date values in item card details on previously selected date to improve the user experience. DEV-2064, PR-1166
Item Card - Open datepicker for editable date values in item card details on previously selected date to improve the user experience. DEV-2064, PR-1166
Item Card - Make the chart config visibility setting actually affect the default visibility for series. With this change, if the "visible: false" setting is set in dbo.chart_elements.highcharts_series_options the series will be hidden by default. DEV-2055, PR-1167
Navigation User that does not have access to any feature in a sub-menu will not see the empty sub-menu button. DEV-1868, PR-1073
Translations - New translations feature which enables CRUD (Create, Read, Update, Delete) interactions with the translations on the AGR Pool cloud server. Users can maintain translations for all deployed systems (wherever in the world) running AGR v6.2 or newer from within the AGR app itself. DEV-1755, PR-1088
- System users will need to login to the AGR Pool cloud service with separate credentials to enable the edit mode.
- All translation changes are staged and have to be manually saved by clicking the save button. Any staged changes can be undone/reset from the info sidebar.
- Translating to a new language can be amazingly fast using the new magic button which suggests a translation from Google based on the current english translation.
- When translating the application it is possible to turn off the default translation fallback behaviour to visualize all the untranslated strings for the selected language in the app.
Workspaces - Add dynamic query for action modal select options. DEV-1819, PR-1050
Workspaces - Fix column formatting assumption happening when a column name contains the word 'price'. PR-1074, DEV-1890
Workspaces - Filter drilldown be present viewfilter of same column DEV-1893, PR-1116
Workspaces - Fix: the edit-ability of the column in a total row when there is conditional editing on the column. For example with this column configuration on the weight column in a view with item no and weight present DEV-1577, PR-1140
Workspaces - Fix "selectedObj" attributes sent in workspace commands DEV-1911, PR-1150
Workspaces - Add a loading indicator to workspace lookup cell-editor. DEV-2061, PR-1154
Workspaces - Cache the lookup values query result when opening the workspace lookup cell-editor so that future requests are resolved immediately. DEV-2060, PR-1154
Workspaces - Make workspace lookup cell-editor display lookup options a lot quicker by only rendering a portion of items in the DOM. This is done by enabling the virtual scroll for the ngSelect component. DEV-2067, PR-1165

API 6.2.3

App Service - Fixes app-service restart state in core.event log, notification ordering in drop down menu and clear own notifications from drop down menu DEV-1850, DEV-1924, PR-1164
Orders - Faster paste (bulk update) in orders grid. DEV-1912, PR-1061
Orders - Timeout for manual orders extended to 4hrs DEV-2052, PR-1132

Databases 6.2.3

Demand Run - Fix issues with malformed reports halting the demand run DEV-1959, PR-1065
Data Mapping - Fix datatype to TINYINT for Price Includes VAT column in nav.Item table DEV-1949, PR-1066
Data Mapping - Standardising NAV datamapping for product groups to avoid duplications DEV-1953, PR-1142
Data Mapping - Forctype column in itemdetails not populated in inventory datamapping DEV-2049, PR-1161
Data Mapping - Exclude abc_grouping from inventory datamapping DEV-2053, PR-1160
Item Card / Settings - Add the item_card_hide_week_number property to the dbo.settings table to hide/show the week label when the Item Card chart is viewed on the weekly level. PR-1099
Settings - Add the item_card_start_week property to the dbo.settings table to control which day of the week series are aggregated to when looking at the Item Card Grid in weekly view. DEV-1948, PR-1057
Split by Constraint - fix: split by constraint logic broken if using fillup. DEV-1991, PR-1109