No records in reference variable in public record producer

[Peter Xiang]

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

• Create public role to avaiable for in record producer

• Add create, read, write premission for variables.

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

• Not records in reference variable

[Shraddha Kadam]

Hello @Peter Xiang ,

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

[Peter Xiang]

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.

[Shraddha Kadam]

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. 

[Peter Xiang]

Hi @Shraddha Kadam ,

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