Order column not working correctly as per given order . The order field is defined as String for the scheduled_data_import - Support and Troubleshooting

Order column not working correctly as per given order . The order field is defined as String for the scheduled_data_import Issue  ISSUE : Order column not working correctly as per given order. The order field is defined as String for the scheduled_data_import

Steps to reproduce : Go to your OOB instance, London or Kingston release Activate plugin e.g. "SCCM System 2016" Go to the module "Scheduled import" in the application menu item "Integration - Microsoft SCCM 2016" https://devxxxxx.service-now.com/nav_to.do?uri=scheduled_import_set.do?sys_id=4c29b91b5b623200dade2e65f0f91ae In the related list "Run the following imports when complete" change of the child imports to have an order e.g. 214 The item will still be visible and will run on third position (after order 10 and 20) instead to run as last import. See below screenshot:

Root Cause: "Order" column data type as String, it is not following the correct sequence of execution. E.G. a scheduled sub-job of order "2456" will get processed after order "20" and before order "30", instead of being the last one of those jobs.

Workaround : As a workaround user and write numbers with the same amount of digits by appending 0. eg. 010 020 150