Items sorting on following data imports is alphanummeric instead of numeric - Known Error

Items sorting on following data imports is alphanummeric instead of numeric Description Sorting column items on following data imports is alphanummeric rather than the expected numeric. If you define following scheduled imports with an order greater than 99, the sorting applied will be alphanummerical. This is due to the [order] field in the table [scheduled_data_import] being of type string. The item will still be visible and will run on third position (after order 10 and 20) instead to run as last import.

Steps to Reproduce

1. Activate an integration plugin like "SCCM System 2016". 3. Go to the module "Scheduled import" in the application menu item "Integration - Microsoft SCCM 2016" ( /nav_to.do?uri=scheduled_import_set.do?sys_id=4c29b91b5b623200dade2e65f0f91ae0 ). 4. In the related list "Run the following imports when complete", change one of the child imports and observe the sequential order sorting.

Workaround After carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases. We do not make this decision lightly, and we apologize for any inconvenience.

As a workaround, format number values to be imported to have the same amount of digits, for example: 010 020 150