How to show the name of the service offering instead of the sys_id

Alon Grod
Tera Expert

Hi,

I have the field 'configuration item' reference to cmdb_rel_ci on my incident table.
When I try to choose a configuration item, it shows me the name and the sys_id, when I choose on of the CI"s and the field is populating with the sys_id instead of the CI's name. In addition, when I click on the search symbol and choose a CI, the field is populating with CI"s date created. all the fields on the cmdb_rel_ci table are display = false.
How can I show and populate just the name of the CI?

WhatsApp Image 2023-12-05 at 08.59.47.jpeg

 

When clicking on the CI field:

WhatsApp Image 2023-12-05 at 09.10.12.jpeg

 

After choosing CI (without search):

WhatsApp Image 2023-12-05 at 09.12.54.jpeg



 When clicking on search:

WhatsApp Image 2023-12-05 at 09.10.32.jpeg


After choosing CI from the search:

WhatsApp Image 2023-12-05 at 09.10.44.jpeg

1 ACCEPTED SOLUTION

Anil Lande
Kilo Patron

Hi,

As you are referring table 'cmdb_rel_ci' in your configuration, no field is set as Display true by default. It will select the record from relationship table not from configuration Item table. If you want to show Parent/Child name in selected record then set parent as Display true.

Can you please explain why you are using this table as reference?

If you want to select configuration item in the fiedl then refer 'cmdb_ci' table instaed of 'cmdb_rel_ci'.

 

 

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

View solution in original post

4 REPLIES 4

Alon Grod
Tera Expert

@Alon Grod 

 

As mentioned by the Anil, please refer the table "cmdb_ci" instead of "cmdb_rel_ci"

Anil Lande
Kilo Patron

Hi,

Looks like display value on your reference table is not set correctly.

Check dictionary of your table and make Name column as display true.

https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/field-administr...

 

https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/field-administr...

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

Anil Lande
Kilo Patron

Hi,

As you are referring table 'cmdb_rel_ci' in your configuration, no field is set as Display true by default. It will select the record from relationship table not from configuration Item table. If you want to show Parent/Child name in selected record then set parent as Display true.

Can you please explain why you are using this table as reference?

If you want to select configuration item in the fiedl then refer 'cmdb_ci' table instaed of 'cmdb_rel_ci'.

 

 

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande