Show catalog item variables in columns on reference variable referencing sc_req_item

[Oliver Anderson]

I have a catalog item with a field called 'ritm' that references the 'sc_req_item' table in order for a user to "attach" a previous requested item to their new request. There is also a field on this catalog item called 'software_name' where the user can type in the name of software.

When searching in the reference field, I want the 'ritm' reference field to show the 'number', 'opened_at', and 'software_name'. I am currently using 'ref_ac_columns=number;opened_at;' to display 'number' and 'opened_at', but I can't figure out how to show variables of this specific catalog item--I can only figure out how to display the columns directly on 'sc_req_item'. I'm assuming I will have to dot-walk to the 'software_name' variable on my catalog item somehow, but I can't figure it out.

'ritm' variable:

Dictionary Entry on 'sc_req_item':

Current Service Portal view:

[Saurav11 · Accepted solution]

Hello,

Can you try the below in variable attribute:-

ref_ac_columns=number;opened_at;variables.variablename;

if the above does not work you can make the field as select box instead of reference and follow the steps mentioned in the below thread by Bernd7

https://www.servicenow.com/community/developer-forum/show-ritm-variable-values-as-variable-attribute...

Please mark my answer as correct based on Impact.

[Oliver Anderson]

Adding 'variables.software_name' to ref_ac_columns did not work, so I switched it to a Lookup Select Box which achieved what I wanted.

Thanks!

[MADHU MSKJ]

Excellent