Reference variable to show multiple display values

Rocky5
Kilo Sage

Hello Devs,

 

I have a reference variable on catalog item that refers to sysapproval_approver table, but.. the field displays the record value but I want to see Approver's name instead or both Approver's name and record value. how can I achieve that?

Rocky5_0-1738877515580.png

Thanks,

Rocky.

1 REPLY 1

Priyankagupta
Giga Guru

@Rocky5 , You cannot directly display values from two columns but can show them in a dropdown. To achieve this, add the following attributes in the Attributes field under the Reference Qualifier section of the variable: "ref_auto_completer=AJAXTableCompleter, ref_ac_columns=field1;field2, ref_ac_columns_search=true"

 

Please mark reply as Helpful/Correct, if applicable. Thanks!