No records in reference variable in public record producer

Peter Xiang
Tera Expert

Hi all,

 

I have created a public record producer, but there is not records in reference, select box variables is work. Below are my steps, could anyone help me, thanks.

 

  • Create public page and widget

PeterXiang_5-1752032888807.png

 

  • Create public role to avaiable for in record producer

PeterXiang_0-1752032521905.png

  • Add create, read, write premission for variables.

PeterXiang_1-1752032591293.png

 

  • I added 2 read acl for table and table.*

PeterXiang_2-1752032717603.png

PeterXiang_3-1752032730800.png

  • Not records in reference variable

PeterXiang_4-1752032825547.png

 

18 REPLIES 18

Shraddha Kadam
Mega Sage

Hello @Peter Xiang ,

 

Please check if query_range ACL is available on the core_country table.

If my response was helpful, please mark it as correct and helpful.
Thank you.

Hi @Shraddha Kadam ,

 

Yes, OOTB have 2 query_range ACL, and I also copyed 2 query_range ACL for public user, but it still not work.

PeterXiang_0-1752034069383.pngPeterXiang_1-1752034074177.png

 

 

Hello @Peter Xiang ,

Don't need to create the new query range ACL. Update the existing ACL.

What you can do, in the existing security attribute select local and save it. Or deactivate it. 

If my response was helpful, please mark it as correct and helpful.
Thank you.

Hi @Shraddha Kadam ,

I have deactive the all query_range acl, but it still no reocrds in nationality variable.