Symptoms

Choice column sorting in drop-down list
 

Diagnoses

After upgrade form Appit 1.4 to Appit 1.5 Drop down control generated from a Choice column in Sharepoint is automatically sorted and doesn't adhere to the ordering specified in SP Choice column config.

This should apply to blackpearl 4.7 as well.

 

Resolution

Workaround:
Instead of listing the options in a Choice field in SharePoint column, externalise this to its own list, aka list of options in the order required.

Then on the main list instead of using the choice column you can use a Lookup to the new list with the options. This will then require you to rewire the Drop down list to use the Lookup SmartObject which will not be sorted.