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

AlwinJebakY · 3 weeks ago

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?

Ankur Bawiskar · 3 weeks ago

@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 AJAXTableCompl...

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

Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader

AlwinJebakY · 3 weeks ago

@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 ?

Ankur Bawiskar · 3 weeks ago

@AlwinJebakY

is it working fine with admins with that attribute ref_ac_columns_search?

Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader

AlwinJebakY · 3 weeks ago

@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.