Service Now Portal - Need Reference field search to display more than one columns

snuser09
Kilo Expert

Hello,

I would like to display more than one column in service now portal search drop down ,when user is searching. So that it makes it easy for user to choose.

I have added the variable attributes

 ref_auto_completer=AJAXTablecompleter,ref_ac_columns=u_building_name;u_bldg_code;u_name,ref_ac_columns_search=true

It allows to search based on columns u_building_name,u_bldg_code,u_name but it doesnt display it in drop down list. It only displays name in drop down list like below, so it would be hard for users to know building codes. If I can aslo display building name and room number along with name in drop down list

find_real_file.png

Like it does in Service Now UI ,building name, room number

find_real_file.png

 

1 ACCEPTED SOLUTION

snuser09
Kilo Expert

Well, it worked. I was able to list more than one columns in drop down with ref_Ac_columns. It displays everything mentioned here. The mistake I did was, the AJAXTablecompleter, the C should be capital. It worked. Just leaving it here, so anyone comes looking for showing more columns in drop down list

 ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_building_name;u_bldg_code;u_name,ref_ac_columns_search=true

View solution in original post

3 REPLIES 3

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

I don't think it is possible as of now.

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Ok. Do you know where is it ocnifgured what it shows in the drop down list? Like it shows name here. Becasue I see few tables when you search for something it displays more than one columns like name,email,id,etc like shown below. So there must be a way to configure it somewhere right?

 

find_real_file.png

snuser09
Kilo Expert

Well, it worked. I was able to list more than one columns in drop down with ref_Ac_columns. It displays everything mentioned here. The mistake I did was, the AJAXTablecompleter, the C should be capital. It worked. Just leaving it here, so anyone comes looking for showing more columns in drop down list

 ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_building_name;u_bldg_code;u_name,ref_ac_columns_search=true