Additional column(s) in Reference lookup

[Michal Sadowski]

Hi ServiceNow superstars,

This is embarrassing but I can't get this to work... 

The requirement is to display Manager next to Assignment group as users search for assignment group in Incident record in Assignment group field. Something like this:

I've followed the docs and community posts, travelled far and wide for this but it's just not working for me...

This is what I did:

1. Configure Dictionary on Assignment group field

2a. As per docs, in Advanced view I added the following in the Attributes field: ref_auto_completer=AJAXTableCompleter,ref_ac_columns=manager

2b. As per this post, I also tried these attributes ref_ac_columns_search=true,ref_auto_completer=AJAXTableCompleter,ref_ac_columns=manager

3. I configured the Reference list for sys_user_group table to display both Name and Manager

End result is I still only see the name of the group when I search in Assignment group field:

What is going on? What am I missing here?

Any pointers much appreciated...

[Maik Skoddow]

Hi

unfortunately you can have only one display value for a reference field.

Kind regards
Maik

[Michal Sadowski]

Are you sure?

How is what I'm trying to achieve different from the below where the auto-complete in the reference field displays more than one value?

[Jaspal Singh · Accepted solution]

Can you try

ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,ref_ac_columns=manager,ref_ac_order_by=name

Also, can you ensure that there does not exists any Dictionary Override entry for the same. Right click the Assignment Group field & then Configure Dictionary. Scroll to the bottom & you will find Dictionary Override. 

[Michal Sadowski]

Hi Jaspal!

Thanks a million. It was the dictionary override with Override attributes set to true on Incident table!. I'm now where I want to be with this. 

Thank you again.