Modify Variable Attribute

[ngriffiths]

Hi all,

I am hoping someone has an answer or any insight on my issue.   I am trying to modify the search criteria of a Catalog reference variable.   In the "variable attributes" field on the variable form we have entered the following: ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name,ref_ac_order_by=code.   This does exactly what we want, however, we would like the user to be able to search by either the 'Name' or the 'Code' columns.   Right now, they can only search by the 'Code' column.   We have tried adding the following: ref_ac_columns_search=true to the end of the script, but this still doesn't allow for the user to search by the 'Name' column.

Does anyone have any ideas???   We would appreciate any help

Thanks for your help!

Niccole

[Michael Fry1]

I tested this in demo006 on the Paper and Supplies catalog item.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=code,ref_ac_order_by=code,ref_ac_columns_search=true

Compare setup

[ngriffiths]

Hmm...well your right, it does work in the demo instance.   Unfortunately, it doesn't within my instance of SN.   When I compare the 2 instances side by side, everything appears to be the same.   I guess I will have to submit a ticket with SN HI .

Do you think that because we are still on Calgary that would have anything to do with it do you?  

[Michael Fry1]

Not sure, could be something else. Let me know outcome. I'll still look for answer.

[ngriffiths]

Will do and thank you again for all your help with this, I really appreciated it!

[ngriffiths · Accepted solution]

I was submitting an incident with SN HI and the article below appeared.     This is an issue in Calgary and earlier releases of SN.   According to the KB this is / was fixed with the Dublin release.

https://hi.service-now.com/ciw_kb_view.do?sysparm_article=KB0523227