customized order of values in reference field dropdown on incident form

[panu]

we have requirement like "to get 20 most used service offering in incident and remaining service offering by alphabetically for variable in that is a reference to (service offering) table "

we are able to get the values that is in form of array of sys_id via script include & passing this to reference qualifier of variable .

but still drop down is defaulting too alphabetically .

How do I order the way the values display in the drop down?

[Daniel Madsen]

Hi panu

The Reference qualifiers link can help you understand how to customize query results and potentially control the ordering of values displayed in your variable's drop-down.

Reference qualifiers - https://servicenow.com/docs/bundle/yokohama-platform-administration/page/script/server-scripting/con...

If this helps, please give it a helpful vote. And if it’s what you were looking for, go ahead and accept the solution. Thanks,
Daniel Madsen