How to show different values in reference field for different tables

dharmesh rathod
Tera Contributor

Hello All,

 

I have a custom table 'u_sla_service_configuration' which has two fields of type string 

1. CMDB Level of service (value to be displayed in cmdb_ci table) (Note: Display:true)

2. Catalog item level of service (value to be displayed in sc_cat_item table)

 

There is one custom field of type reference created on both cmdb_ci and sc_cat_item table

Field name: Level of service

Reference table: u_sla_service_configuration

 

I have added respective reference qualifier on the field 'Level of service' to show data as per condition CMDB on cmdb_ci table and Catalog on sc_cat_item table each

 

Now my requirement is: 

I want to show value of 'CMDB Level of service' field on 'cmdb_ci' table like below

dharmeshrathod_0-1724150226760.png

 

 

and Value of 'Catalog item level of service' on sc_cat_item' table

But due to Display: true is set for 'CMDB Level of service' field I m getting blank value on sc_cat_item table 'Level of service' field

dharmeshrathod_1-1724150489488.png

 

 

How can i overcome this challenge?

Note: I m aware that two fields display true cannot be set. Is there any other alternative workaround to achieve this  requirement?

5 REPLIES 5

The field type doesn't matter. The question is IF you can dotwalk or not. I don't know the setup so I don't know if you can.

MarkManders_0-1724158031157.png

I dot walked to the string field 'street' on the user form in the above screenshot.
If you can't dot walk, you will need to script the result into your field. A table can only have one display field.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark