How to display only a specific record as the first selection in a reference field List
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2024 02:42 AM - edited 06-04-2024 02:45 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2024 02:45 AM
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.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2024 02:46 AM - edited 06-04-2024 02:47 AM
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