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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
