Lookup Select Public access

[MichaelH5716707]

I need some help on a public record producer. First off this is not my design I picked up a horrible process and just trying to remedy it. I have a record producer that has a category and subcategory field. The category field is a select box and is working as expected. The issue is with doing a lookup select. I created a script include to handle the reference qualifier and this works when authenticated but not when unauthenticated the list is blank. I had attempted to add read ACL on the sys_choice table and maybe I didn't do those right I just had a table level read and a all fields read ACL for public role.

Can anyone help me understand why I am getting denied access to do the lookup?

[Community Alums · Accepted solution]

Hi @MichaelH5716707 ,

The issue you're encountering likely that unauthenticated users (public users) do not have the necessary permissions to read data from the sys_choice table or other related tables used in your reference qualifier. 

 

Please validate that for unauthenticated users to access sys_choice records, the ACLs must be correctly configured.

Check Read level ACL is present at table level as well as for all the fields, basically None and * should be configured properly. Ensure there are no roles associated in the ACL which is restricting the users.

It would be great if you could share the ACLs Snapshot here to take a closer look if your issue doesn't get solved..

If my response has resolved your query, please consider giving it a thumbs up ‌‌ and marking it as the correct answer‌‌!

Thanks & Regards,

Sanjay Kumar