Enable Search a reference Field to search in 2 fields

[tapannigam]

Hi All, 

Looking to search in a referece field in this way that search should work in 2 fields of reference field to find results. For ex: try to search in Department Referece field then entered string should be serarched in name fields & Description field of Department to find records. By default, search get apply to name only once enter a string in Department reference field. Please refer attached screen shot. Please share solution in detail.

Regards,
Tapan Nigam

[Alberto Consonn]

Hi,

have a look in deep to the following thread discussion, it should fit your need:

https://community.servicenow.com/community?id=community_question&sys_id=98b1cb69db98dbc01dcaf3231f96...

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[tapannigam]

Hi Alberto, 

I am using London release at my end as of now. done change with below Attribute: 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;description,ref_ac_columns_search=true

however it didnt work. Please refer below screen shot: 

[Rahul Kumar17 · Accepted solution]

HI,

Pass the Attribute Value

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=email,ref_ac_columns_search=true;

thanq