List colletor variable attributes

[mounika7675]

Hi,

I created a List Collector variable referencing the cmdb_ci_computer table.

I configured variable attributes to allow searching by three fields:

Name

Serial Number

Asset

Expected behavior:

When I type a value from any of these fields, the corresponding records should appear.

Actual issue:

Only the first two attributes work correctly and return results.

The third attribute never returns any results, regardless of which field is placed in that position.

I also tested by changing the order of attributes, but the behavior remains the same —

only the first two attributes work, and whichever field is placed third does not work.

[Brad Bowman · Accepted solution]

The column names must be separated with a semicolon (;) in order to make the attribute valid, but ref_ac_columns is also meant to be used only with reference variables, so I wouldn't be too surprised if it still didn't work.

https://www.servicenow.com/docs/r/platform-administration/c_AutoCompleteForReferenceFields.html 

[mounika7675]

I have added (;) for all the variables and now it's working as expected 

Thanks 👍 

[Tanushree Maiti]

Hi @mounika7675 

Update your variable attribute with following value , save it and recheck --

from:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=asset,name,serial_number.ref_ac_columns_search=true

To:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=asset;name;serial_number,ref_ac_columns_search=true