Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Additional column(s) in Reference lookup

Michal Sadowski
Mega Sage

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:

find_real_file.png

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

find_real_file.png

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

find_real_file.png

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

find_real_file.png

What is going on? What am I missing here?

Any pointers much appreciated...

1 ACCEPTED SOLUTION

Jaspal Singh
Mega Patron
Mega Patron

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. 

 

View solution in original post

7 REPLIES 7

Ah, I see. I misunderstood you.

Glad that it works now for you!

Kind regards
Maik

No worries. Thanks for this!

Rohit Motiani
ServiceNow Employee
ServiceNow Employee

In the caller field, to show Department, I modified the layout as per the attached screenshot. Please check, if this helps.