Reference field are empty in public record producer

[Tarasingh26]

Hi All,

I have created public record producer for external users. It is working fine and they are able to submit record. Now I have created one reference field on record producer which refers to different table. External users cannot see values in reference field. It is coming no match found. I have provided read access by adding snc_external role to reference table but still value are not visible to external users. Can anyone let me know solution if you face this kind of issue.

Thanks,

Tara Singh 

[M Iftikhar]

Hi @Tarasingh26, 

The issue is that you are using the snc_external role, which is for logged-in external users, whereas truly public, unauthenticated users are governed by the special public role. To fix this, you need to create a read Access Control List (ACL) on the table that your reference field points to and grant access specifically to the public role.

Also, be aware that if the display value for that reference table is itself another reference field (e.g., a user's name), you must also grant public read access to that secondary table (e.g., sys_user) as well. The easiest way to confirm this is the issue is to use the "Debug Security Rules" feature while impersonating a guest user; it will show you exactly which table read operation is failing.

Hope this helps!

Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution and helpful so others can benefit as well.

[Ankur Bawiskar]

@Tarasingh26 

try creating query_range Table.None READ ACL on that table and add snc_external role

Reference variable not visible in Portal for non-admin user but visible in classic view 

Also note if any field level READ ACL on that table for the field which is marked Display=true is blocking.

Try creating fresh field level READ ACL on that display field and add snc_external role

see this article

Ways to analyze and fix the query_range issue in portals using Access Analyzer 

If my response helped please mark it correct along with other ones from my response so that it benefits future readers.