Catalog Item Reference Variable to Custom Table

[Community Alums]

Hello,

I created a custom table for holding variable data and gave snc_internal read access to the table.  I set variable1 field to display is true.   On the catalog item is a reference variable to the table I have no qualifier on it.  When I impersonate as user I get no matches found.  However if I change to Lookup Select Box I get the value.   Do I need to add more ACL's to the table like query_range?

Any assistance is appreciated.

Thanks,

Chad

[YaswanthKurre]

Hi @Community Alums ,

• Reference variables enforce ACLs and require a Query ACL on the target table to show records.
• Lookup Select Box variables often bypass strict ACL checks because they run in a system context.
• If Reference shows “No matches found,” add a Query ACL to the table to fix it

Please mark this as helpful and correct, if this helps you.

Thanks,

Yaswanth

[Community Alums]

Hello,

Thanks for the response.   I tried adding a query_range acl but still getting no results

[Ankur Bawiskar · Accepted solution]

@Community Alums 

you need to create query_range ACL with Table.* and not Table.None

Give role to that ACL and it will start showing records for non-admins in portal reference variable

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

[Community Alums]

Thanks Ankur.   That worked.

Chad