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!

[Community Alums]

Hi @Community Alums 

In which way you want show all these field can you please describe in detail or provide me the screenshot.

Mark the comment as a correct answer and also helpful if this has helped to solve the problem.

Krishna Sharma

[Community Alums]

Hi @Community Alums ,

I want to show like this to end user

[Sanjeet_Choudha]

Hi @Community Alums ,

Try this solution and mark helpful if this will help you.

https://www.servicenow.com/community/itsm-forum/list-attributes-beyond-name-for-user-reference-fields/m-p/591035 

[Vishal Birajdar]

Hi @Community Alums 

Assuming CI group field is present on cmn_department table

you can use below attribute

ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,ref_ac_columns=ci_group,ci_group.manager.name,ref_ac_display_value=false

//user your backend name's