I want to add two columns in search list of list collector.

Taaha M
Tera Contributor

I want to search a record in a list collector field with either name or by it business unit number.

But it is not working as expected , I used the auto complete attributes as follows:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_name;u_businessunitid,ref_ac_columns_search=true,no_filter

but the u_businessunitid is an integer field on a customised table which the list collector is referring to.

I am not sure why it is not working, I tried using other fields of other type(string,date/time) it did worked, but in case of integer type field it is not working.
What can I do to have the record to be able to search with two fields.

1 REPLY 1

Juhi Poddar
Kilo Patron

Hello @Taaha M 

The issue you are encountering stems from how integer fields are handled in ServiceNow’s autocomplete functionality. Unlike string fields, integer fields often require an exact match, and partial matches (like LIKE or CONTAINS) do not work out of the box.

 

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps others find the solution more easily and supports the community!"

 

Thank You
Juhi Poddar