Steps to Reproduce :-
Use the below query.
(select 'White' as name,1 as lookup_order from dual
select 'Green' as name,2 as lookup_order from dual
select 'Purple' as name, 3 as lookup_order from dual
select 'Black' as name, 4 as lookup_order from dual
Expected Results :- Lookup Values are shown in the order which is defined by the Default Sorting Column
Actual Results :- Lookup values are shown in a random order.
Note: A similar issue also occurs on the Custom Investment, Dynamic lookup field in the Board View is not honoring the sort order given in the Lookup on the Custom Investment.
Release : 16.1.3 and all supported Clarity releases
Component : Clarity MUX UI Usability
This was reviewed by Clarity Engineering as part of DE66565. It has been determined to be not a defect.
A change to this behaviour can be considered as part of an enhancement. Process for logging enhancement requests is here.