I am unable to search other fields in my CI reference field even when ref_ac_columns_search is TRUE.

[Jordan Humphre1]

Hi,

So, I am working on updating my "CI" reference field, which is based off cmdb_ci so it allows me to search for a CI not only by the name (which is the "display value" right now on that table), but also add the ability to auto-complete search by fields like serial_number or asset_tag.

I ran through the documentation and found an attribute called ref_ac_columns_search which is said to allow me to search fields included in ref_ac_columns. However, when I try to do something like search via a serial number, I get an invalid reference error.

Here are the attributes for the field:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search
=true,ref_contributions=task_show_ci_map;show_related_records,ref_ac_columns=sys_class_name;asset_tag;serial_number,ref_ac_order_by=sys_class_name

I opened a case with HI but maybe you guys could offer some ideas? Thanks!

[Brent Sutton · Accepted solution]

Hi Jorden,

I can't see anything standing out as being wrong in your attributes.  I have this running correctly, in a dictionary override on the incident table, using the following attributes:

ref_ac_order_by=sys_class_name,ref_contributions=task_show_ci_map;show_related_records,ref_ac_columns=sys_class_name;asset_tag;serial_number,ref_ac_columns_search=true,ref_auto_completer=AJAXTableCompleter

 Result:

Try copying my code and let me know if it worked for you. If it continues to fail then Hi will be your best bet.

Brent

P.S. If my suggestion helped then please mark as helpful and/or correct so other community members can benefit from this information.

[Jordan Humphre1]

That worked but say for example if I'm using a barcode scanner on this field: If I press Enter when the service tag is present it will not properly display. However, the list of auto-complete choices allows me to manually click on the one I want. Is there a way to have it accept the value?

[Brent Sutton]

My developer instance is on the London release and it allows input values from searchable columns. When you first press enter it comes up with an invalid reference error but then populates the correct CI.