Need assistance with variable attribute

[Community Alums]

Hi,

Scenario: I have a catalog item with a reference type variable referring to- the table cmn_department. I want to show the name of Department, its CI Group, and CI Group manager to the end-user.

Relationship:

1) The department names stored in cmn_department table (reference table of variable, CI Group names not present in this table)

2) The departments and Its respective CI Group are stored in the cmdb_ci_group table. (CI Group field is reference field)

3)The CI Group and CI Group manager relationship is stored in the sys_user_group table.

Question: Is it possible to show the name, CI Group, and CI Group manager to the end user if data available in multiple tables for the catalog item?

Example what we want:

can anyone please guide me, how we can achieve it.  Thanks!

[Shahid3]

Hey @Community Alums ,

You may want to try the suggestion in the below trail but would require solutioning to come up with an exact solution.

https://www.servicenow.com/community/developer-forum/how-to-reference-field-with-multiple-tables/m-p/1512983/page/2

[Ankur Bawiskar · Accepted solution]

@Community Alums 

you can show data only from the referenced table but not from other table.

the closest you can do is to set a text variable with the values for CI Group and CI Group manager on department selection

If my response helped please mark it correct and close the thread so that it benefits future readers.