Reference variable to show multiple display values
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2025 01:32 PM
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?
Thanks,
Rocky.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2025 02:37 PM
@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!