Last name serach in caller field

NeethuB
Tera Contributor

In servicenow in the incident form there is a assigned_to field but when we search caller we can only search by his first name like "amal murali" we can search him by amal then the amal first name people is showing but i want to serach by the last name too.

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@NeethuB 

you can add this in dictionary attributes

ref_ac_columns=last_name,ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true

Auto-complete for reference fields 

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

View solution in original post

10 REPLIES 10

JenniferRah
Mega Sage

If you use an asterisk (*), it will find users with that in either part of their name.

Ankur Bawiskar
Tera Patron
Tera Patron

@NeethuB 

you can add this in dictionary attributes

ref_ac_columns=last_name,ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true

Auto-complete for reference fields 

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

HI @Ankur Bawiskar 
Its working on one instance but its not working for the another instance what should i do?

 

I added that attribute to the dictionary and still now working

Followed these instructions and added that line:

  1. Navigate to a list of the target table, such as All > User Administration > Users.
  2. Perform the appropriate action for your list version.
    Version Action
    List v2Right-click the column header and click Configure > Dictionary.
    List v3Open the list title menu and click Configure, and then click Dictionary.
  3. Select the row that does not list a column name.
    This row is typically the first row in the list. For example, select the first sys_user link.
  4. Under Related Links, click Advanced view.
  5. In the Attributes field, enter a comma-separated list of auto-complete attributes you want to apply to all fields in the table.
    For example, to display the user's department with all references to the sys_user table, enter:
    Explain this code
    ref_auto_completer=AJAXTableCompleter,ref_ac_columns=department,ref_ac_order_by=department
    Copy
  6. Click Update.

However when I typed in a last name, got a invalid reference instead

It looks like you missed this attribute: 

ref_ac_columns_search=true