Variables referencing customer_contact table is not returning any results for end users even after allowing ACL access to this table.
Before query BR adding additional query to prevent users viewing the content
You can do one of these 2 things,
- Disable BR: https://yourInstance.service-now.com/sys_script.do?sys_id=47d2e4dbc3101200b12d9f2974d3aee0
(Please Note: this BR was intended to prevent users from seeing records on this table)
- Query the sys_user table instead of customer_contact table