How to add info when searching on select box or reference field

[Kifrez]

Hi,

I have a custom table . Let's say it has a name field and a description field.

When user search on service portal for a name, I would like the description to show next to the name .

For example as per screenshot below.

Thanks in advanced

[Kifrez]

Mahendra, nevermind, it works haha....

It was my typo

I put

ref_auto_completer=AJAXTableCompleter;

Once I change to below, it works

ref_auto_completer=AJAXTableCompleter,

[Sai Kumar B]

@Freddy 

You can use ref_ac_columns attribute in your variable record to show multiple columns in options

ref_ac_columns -> Specifies the list of reference table columns to display. Separate column names with a semi-colon. For example, ref_ac_columns=user_name;email;sys_created_on allows auto-complete to match text from the user_name, email, and sys_created_on columns.

Try the below

ref_ac_columns=email

[Kifrez]

Hi Mahendra, thanks for responding.

It's a reference field.

I have a custom table with

- u_role = single line text field

- u_description = single line text field

- u_role_owner = reference field to user

On catalog item, it is a reference field . Then I added variable attribute with

ref_ac_columns=u_description;u_role_owner

but still doesn't work, do you happen to know why?

[Sai Kumar B]

@Freddy Please try the below in your variable attributes

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_description;u_role_owner

[shloke04]

HI,

Please use below in your Variable Attributes to get it working:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_description,ref_ac_order_by=u_role_owner

This should work for you. let me know if you are facing an issue.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke