Hey Lungo, Are you trying to create an SQLView? If so, is there a reason why you need to do this through SQL other than the API?
That table is excluded from queries using an SQLView as you could potentially expose the username and password hashes through the API Regards, Mark On Tue, Dec 8, 2015 at 10:05 AM, Knut Staring <[email protected]> wrote: > > ---------- Forwarded message ---------- > From: Juma Lungo <[email protected]> > Date: Fri, Dec 4, 2015 at 9:44 AM > Subject: [Dhis2-devs] User queries on Users table > To: DHIS Developers <[email protected]> > > > Hi > > on DHIS2 v2.16, > > I cannot save the following query, > ===== > SELECT surname, firstname, phonenumber, username FROM userinfo INNER JOIN > users ON (userinfoid = userid) > ===== > because I am querying "special tables". > > What is the workaround for this? > > Lungo > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > Norway: +4791880522 > Skype: knutstar > http://dhis2.org > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
