← Back to team overview

dhis2-devs team mailing list archive

SQLview - protected tables

 

Hi,

Getting the following error while trying to get user list for a given organization unit in sql view:

"SQL query contains references to protected tables"

The query is here:
---
SELECT
  userinfo.surname,
  userinfo.firstname,
  organisationunit.name
FROM
  public.usermembership,
  public.userinfo,
  public.organisationunit
WHERE
  usermembership.userinfoid = userinfo.userinfoid AND
  organisationunit.organisationunitid = usermembership.organisationunitid;

---

Perhaps the userinfo table is protected. Is there a workaround this so the said data can be accessed? OR any other method?

Thanks,
Himanshu


Follow ups