question Re: Reference field shows “No records found” when using ref_ac_columns_search=true on Record Produce in Developer forum

Reference field shows “No records found” when using ref_ac_columns_search=true on Record Producer

AlwinJebakY — Thu, 01 Oct 2026 07:53:36 GMT

Hi,

I am trying to populate Asset records based on a Product Model condition. I have configured a reference qualifier and added the following variable attributes:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=serial_number;display_name,ref_ac_columns_search=true

When ref_ac_columns_search=true is included, the reference field displays “No records found.” If I remove this attribute, the expected Asset records are displayed correctly.

Several Community posts suggest that a query_range ACL may be required. The affected user has the snc_external role. I created the ACL and tested it, but the issue still persists.

Could someone help me understand:

Why does ref_ac_columns_search=true prevent records from being returned?
Are additional ACLs or configurations required for searching the specified columns?
Do serial_number and display_name require field-level read access or any specific indexing?

Re: Reference field shows “No records found” when using ref_ac_columns_search=true on Record Produce

Ankur Bawiskar — Thu, 01 Oct 2026 09:23:19 GMT

@AlwinJebakY

is it working fine with admins? -> if yes then it's some ACL issue

Try creating query_range ACL on both the fields and add proper role

Also user should have read access to fields used in that attribue

check this KB

Service Catalog — Autocomplete Not Working with Custom Fields in ref_ac_columns Using AJAXTableCompleter - Support and Troubleshooting

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Re: Reference field shows “No records found” when using ref_ac_columns_search=true on Record Produce

AlwinJebakY — Thu, 01 Oct 2026 11:11:14 GMT

@Ankur Bawiskar

I tried all this ways, but now also I'm not getting any values on that field?
Did you know any other ways ?

Re: Reference field shows “No records found” when using ref_ac_columns_search=true on Record Produce

Ankur Bawiskar — Thu, 01 Oct 2026 12:00:41 GMT

@AlwinJebakY

is it working fine with admins with that attribute ref_ac_columns_search?

Re: Reference field shows “No records found” when using ref_ac_columns_search=true on Record Produce

AlwinJebakY — Thu, 01 Oct 2026 12:22:59 GMT

@Ankur Bawiskar
It is working previously for same user, now only got an error and I checked with another users with same access level they can able to see the records.

Re: Reference field shows “No records found” when using ref_ac_columns_search=true on Record Produce

Ankur Bawiskar — Thu, 01 Oct 2026 12:44:34 GMT

@AlwinJebakY

if it's working with admin and some non-admin and not working for some other non-admin then it's access issue