Good morning,
We have a section on our ServiceNow instance where users can select a training course from a dropdown list, in this case Excel.
Currently the Lookup Select box has a reference qual containing u_type=excel so it filters on Excel only which refers to the IT training table:
The training table's choice list shows the courses and lists them with a sequence value as well as a label (just the Excel ones shown for reference):
However, when a user is using the service portal, the drop down list is sorted by the Value rather than the sequence, so labels appear in that order, instead of in the sequence order which is preferred. I did try to add ^ORDERBYsequence to the end of the reference qualifier but that failed to change anything.
Although the values could be changed to be set alphabetically, would this impact on users who have already filled out the forms and selected a course where they've created a requested item already? Or is there a way to ensure the order by is by sequence, so if more are added in future, we can always set the sequence order accordingly?
