User auto complete on reference field does not work the same in Service Portal.

[Brian Lancaster]

I have added ref_ac_columns=email to the variable attribute on a reference variable that is pointed to the sys_user table.  When I am in regular ServiceNow and I put in someones name it also displays their email address.  However this does not work on the same way in service portal.  The email address never shows.  Is there something I am missing?

[Nithish1 · Accepted solution]

Hi Brian,

Add this variable attribute on the catalog variable.

ref_ac_columns_search=true,global_search_config_handler=UserConfig,all_tables.text_index_translations=true,ref_ac_order_by=name,ref_ac_columns=email,display_image=photo,ref_auto_completer=AJAXTableCompleter,iterativeDelete=true,metadata_link_exempt=true

 And also create new ACL sys_user.email and give read access to all the users.

Regards,

Nithish

[Nithish1 · Accepted solution]

Hi Brian,

Add this variable attribute on the catalog variable.

ref_ac_columns_search=true,global_search_config_handler=UserConfig,all_tables.text_index_translations=true,ref_ac_order_by=name,ref_ac_columns=email,display_image=photo,ref_auto_completer=AJAXTableCompleter,iterativeDelete=true,metadata_link_exempt=true

 And also create new ACL sys_user.email and give read access to all the users.

Regards,

Nithish

[Brian Lancaster]

Sorry this works only if you are an admin.  For some reason a user with no roles cannot see email address.

[Brian Lancaster]

Found the issue.  There is an OOB ACL sys_user.* that was preventing end users from seeing other users emails.  So I had to create a read ACL with sys_user.email to give everybody access to email address.  Then I just needed this in the variable attributes.

ref_ac_columns_search=true,ref_ac_columns=email,ref_auto_completer=AJAXTableCompleter

[Nithish1 · Accepted solution]

Hi,

Add this variable attribute on the catalog variable.

ref_ac_columns_search=true,global_search_config_handler=UserConfig,all_tables.text_index_translations=true,ref_ac_order_by=name,ref_ac_columns=email,display_image=photo,ref_auto_completer=AJAXTableCompleter,iterativeDelete=true,metadata_link_exempt=true

 And also create new ACL sys_user.email and give read access to all the users.

Regards,

Nithish