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

[Ankur Bawiskar]

@Peter Xiang 

try creating a fresh field level READ ACL on core_country.name and add public role and then see

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Peter Xiang]

Hi @Ankur Bawiskar ,

Sure, created it, but it still not work.

[Ankur Bawiskar]

@Peter Xiang 

any role is added in that variable in Permissions tab? give public there

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Peter Xiang]

Hi @Ankur Bawiskar ,

Yes, I did.

I have a new find in 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.

[sundarjm]

Hi @Peter Xiang ,

Please recheck  the initial steps once,

this could be either  ACL or reference qualifier config.

1)check the variable in the respective Record Producer and change the Type from Reference to Select Box and add the required conditions(required script).

2) please check if there is a read ACL that requires a role for the particular table.