How to show different values in reference field for different tables

[dharmesh rathod]

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

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

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?

[Mark Manders]

No. A table only has one display value and that's the value it will show. Is there a way to dotwalk to the table by any chance? In that case you can put the field dotwalked on the form instead of as a referenced field.

[dharmesh rathod]

Can you please elaborate your answer and provide more detail by which table to dotwalk and even if we dotwalk will it show reference field values as it will have multiple options to be selected

[Mark Manders]

Dotwalking to a field will allow you to show any field from the dotwalked table.

For instance: if I create a ticket form and I put the caller on there and I also need the location of the caller, I can put the dotwalked field on there: user.location. And the display value for user is still the same.

So if there is a way you can dotwalk from your sc_cat_item table, you can add the custom_table.custom_field to the form. I just don't know how your custom table is setup and if you can dotwalk to it. 

If not, then there is no other way than to script to the field and fill it like that.

[dharmesh rathod]

Dotwalking will not help because 'Catalog item level of service' field is String field on the table 'u_sla_service_configuration' is string field