question How to display only a specific record as the first selection in a reference field List in Developer forum

How to display only a specific record as the first selection in a reference field List

Meloper — Tue, 04 Jun 2024 09:45:28 GMT

Is it possible to display only a specific record as the first selection in a reference field List?
not a shadow text or default value.
Klick on the ref icon, and in that pop list, Japan should be First and then Afghanistan, Albania....

Example.
Click on the Ref field: Name of Country
The core_company entries are then displayed there.
Japan should be at the top, as the first suggestion. ANd then all the Other Countries in the Alphabet Order by Name

You can work with attributes and e.g. filter on sys updated on and update the Japan entry, but this is certainly not a permanent solution.

Re: How to display only a specific record as the first selection in a reference field

Mark Manders — Tue, 04 Jun 2024 09:45:13 GMT

With a bit of luck Japan will always be the 'most recently selected'. But you can't put an order on that, unless you want to add a space in front of the country (' Japan'), or just run a daily job to update the record every day and order it like you are suggesting yourself.

Re: How to display only a specific record as the first selection in a reference field List

Fabian Kunzke — Tue, 04 Jun 2024 09:47:53 GMT

Hey,

depending on how you set up your reference qualifier, you can use the attribute "ref_ac_order_by=" to add fields by which the results should be ordered. You can find this in the ServiceNow documentation here.

Note: This will sort all countries in alphabetical order, but won't put Japan on top. I also am unaware of any way to do this outside of a custom scripting for the UI itself (which i don't recommend).

Regards

Fabian