How to implement the Auto-Complete for reference fields in the Service Portal?

[johannes5]

Hi ServiceNow Community Developers,

Do you guys know how how to implement the ref_auto_completer attribute in the Service Portal so that when a user clicks the magnifying glass on a reference field s/he is able to see more columns as specified in ref_ac_columns in addition to seeing the display value for that table? I have this functionality implemented as follows in our core platform and in our ESS portal: 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=first_name;last_name;user_name;email;u_nt_id;ref_ac_columns_search=true,ref_ac_display_value=false

However this doesn't work in the Service Portal and I was wondering how can we turn this functionality on in the Service Portal. Please advise.

Thanks,

Johannes

[Matthew Smith]

Hi Johannes

Could you use a Lookup Select Box instead of a reference field? This has a 'Lookup label field(s)' field under Type Specification tab where you can comma separate the list of field names you want to display.

Hope it helps.

Matt

[Tim Deniston · Accepted solution]

I noticed a type in your attributes. The part "u_nt_id;ref_ac_columns_search" should be "u_nt_id,ref_ac_columns_search" (comma instead of semicolon). Not sure if that's the fix... some other Community posts indicate the reference columns functionality is possible, but it stacks the data instead of showing horizontally. 

[johannes5]

Hi Tim,

Would you please share the other Community posts that you are referring to above. 

Thanks,

Johannes

[Tim Deniston]

https://community.servicenow.com/community?id=community_question&sys_id=46924b21dbd8dbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=32efb2eddb58dbc01dcaf3231f96...