search list collector on multiple fields

Brian Bouchard
Mega Sage

I have a table with 2 columns, u_display_name and u_func_access_tech

I have a Service Catalog with a list collector variable defined referencing that table.  I'd like to be able to search the list by either the u_display_name or the u_func_access_tech field.

I know you can do this with reference fields by modifying the attributes of the field, so I tried updating the attributes of the list collector similarly:

no_filter,ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_display_name;u_func_access_tech,ref_ac_columns_search=true

It doesn't appear to be working. Is it possible to enable this on a Service Catalog variable, or am I barking up the wrong tree?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Brian,

that should work. Did you give correct field name?

Regards
Ankur

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

View solution in original post

4 REPLIES 4

Mike Patel
Tera Sage

try below

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_display_name;u_func_access_tech,ref_ac_columns_search=true,no_filter

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Brian,

that should work. Did you give correct field name?

Regards
Ankur

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

As a matter of fact, I did not.  Thanks for pointing out the obvious 🙂

 

Mairvette Tucke
Tera Contributor

Hi @Brian Bouchard  - 

 

I'm still learning, but are you initially creating two separate fields/variables, one for each column?
I'm needing to do something similar. I can get both element types from the sys_choice table populated in the one variable/field, but I need it separated. Or am I doing it completely wrong? 🙂 

Basically, I have a two column table (roles & their descriptions). We typically store the roles on the sys_choice table, but the user also wants the description associated, but multi-select option. Initial thought was two separate fields, one for each element type.