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

[Peter Xiang]

Hi @sundarjm ,

1) The Nationality variable is reference to country table, I don't want to change it to select box variable.

2) I have created the 3 read acl in country table (table level, table.* level, table.name level), unfortunately it still no records in the nationality varialbe when I not login the instance.

[Peter Xiang]

Hi all,

I checed the response in the network, there is a message "Part of the query on core_country has been ignored because of insufficient access for 'query_range' operation on core_country.name", and then I added a query_range acl for public role for core_country.name, but it still not records.

[Shraddha Kadam]

@Peter Xiang ,

Try it without adding the role or deactivate the ACL

[Peter Xiang]

Hi @Shraddha Kadam ,

did it, but still not work.