Making the name and number of a variable appear as a field on a catalogue item

matthew_hughes
Kilo Sage

On a catalogue item, I've got a field called Business Application that only populates the name of the selected Business Application:

matthew_hughes_0-1708612860861.png

 

However, what I'm wanting to do is include the number of the Business Application next to the name, so it looks like the following:

 

matthew_hughes_1-1708614186717.png

 

This are the current details of my Business Application field:

 

matthew_hughes_2-1708614237990.png

 

Does anyone know what I need to change to include the Business Application number starting with AL

 

 

 

1 ACCEPTED SOLUTION

matthew_hughes
Kilo Sage

I've figured it out now. I changed the field type to Lookup Select Box

View solution in original post

2 REPLIES 2

Martin iTSM
Tera Guru

Hey there,

1. Create a new string field on the table your services reside in e.g. [cmdb_ci_service] (do not forget about inheritance)
2. Populate that new field via BR on insert/update (initially maybe a fix script/background script for existing services)
3. Use a catalog variable of type lookup select box (Attention: 10k record limit! more will not be loaded)
For that type you can select the table and the specific field you want to show to pick from.
The new field`s values eventually needs to be set to be unique as else you`ll end up with identically looking entries.

MartiniTSM_1-1708616829024.png

Testing the item:

MartiniTSM_2-1708616887487.png

That should do the trick.
---
Another way could be to set the new field as the display value for that table - but that will be effective throughout the whole system and may not be the desired state - but could also be just fine. 

MartiniTSM_3-1708617327822.png

MartiniTSM_4-1708617372744.png

---
Hope this helps. I guess there are also other ways. - but those two are what i would likely go for.

Cheers!

Martin

matthew_hughes
Kilo Sage

I've figured it out now. I changed the field type to Lookup Select Box