How to show different values in reference field for different tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-20-2024 03:41 AM
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 as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-20-2024 05:48 AM
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.
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