- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2019 06:13 AM
Hello,
I have a field in a service catalog that the client requested to show the host name instead of the name…. I have configured a lookup field and I have specified the LOOKUP VALUE FIELD = host name.. but the topic is that the client mentioned:
List of assets is not searchable and is very long
Can I configure something in the lookup Select Box to have the possibility to find the option in an easy way?
When I modify this field in Reference type.. I can search for an option an easily way but the topic is that the data showed is the name of the CI and the user requires the host name..... other field....
Any suggestion,please?
Thanks!
Solved! Go to Solution.
- Labels:
-
Scripting and Coding
-
Team Development

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2019 06:18 AM
As you discovered, a reference field is a nice way to enable a search or lookup on a long list, but you are constrained by the display value (in your case the CI name).
A choice list is fine if you want to set a specific value or use a list from another table, but it can get very long (and nobody likes scrolling past about 20 items.)
It sounds like what you need is a lookup table that you can reference. You will need to populate and maintain the values in this table based off the active CIs. That means an initial script to put values in and a business rule to maintain them each time there is a record change on the CI, you update the lookup table value. Then you can use a reference field to your lookup table.
By using a table, YOU set the display value (to be host) and you can also reference the original CI record so you can dot-walk to whatever values you need to get any remaining data.
That would be my suggestion. It's a bit of work so make sure whomever is asking for this requirement understands the implementation and maintenance costs. This is another thing that will require testing as you do upgrades - prepare them and let them make the choice if it is worth it or not.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2019 06:18 AM
As you discovered, a reference field is a nice way to enable a search or lookup on a long list, but you are constrained by the display value (in your case the CI name).
A choice list is fine if you want to set a specific value or use a list from another table, but it can get very long (and nobody likes scrolling past about 20 items.)
It sounds like what you need is a lookup table that you can reference. You will need to populate and maintain the values in this table based off the active CIs. That means an initial script to put values in and a business rule to maintain them each time there is a record change on the CI, you update the lookup table value. Then you can use a reference field to your lookup table.
By using a table, YOU set the display value (to be host) and you can also reference the original CI record so you can dot-walk to whatever values you need to get any remaining data.
That would be my suggestion. It's a bit of work so make sure whomever is asking for this requirement understands the implementation and maintenance costs. This is another thing that will require testing as you do upgrades - prepare them and let them make the choice if it is worth it or not.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2019 07:01 AM
Thanks Chuck to answer me.....

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2019 06:20 AM
Hi there,
Can you specify your question a bit more? I mean, if I just quickly add a variable of type Lookup Select Box, I instantly have a search option available. That is what you are after? Or something different?
If my answer helped you in any way, please then mark it as helpful.
Kind regards,
Mark
---
LinkedIn
Community article list
Kind regards,
Mark Roethof
Independent ServiceNow Consultant
10x ServiceNow MVP
---
~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2019 03:29 PM