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

Ankur Bawiskar
Tera Patron
Tera Patron

@Peter Xiang 

none of the reference variables are showing data?

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar ,

 

If I not login, no records in the reference field, if I login, records are shown in the reference.

PeterXiang_0-1752036955310.pngPeterXiang_1-1752036989259.png

 

@Peter Xiang 

Are you saying it works for admin users, but not for non-admin users?

Could you also share a screenshot of the List layout of active ACLs on the Country table?

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

Hi @Shraddha Kadam ,

 

I mean is if I login the instance, I can see the records in the Nationality variable, but if I not login the instance, no records in the Nationality variable.

Below screenshot is all active acl for country table.

PeterXiang_0-1752040358886.png

 

Hello @Peter Xiang ,

If you created any ACLs make it deactivate for now and keep this 3 ACLs Active. I checked for myself and it is working on PDI. Also, verify once if there are any query range acls are active or not for country table.
https://instancename.service-now.com/sys_security_acl_list.do?sysparm_query=nameLIKEcore_country%5Esys_scope%3Dglobal&sysparm_first_row=1&sysparm_view=

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