← Back to team overview

dhis2-users team mailing list archive

Fwd: [Dhis2-devs] User queries on Users table


---------- Forwarded message ----------
From: Juma Lungo <jlungo@xxxxxxxxx>
Date: Fri, Dec 4, 2015 at 9:44 AM
Subject: [Dhis2-devs] User queries on Users table
To: DHIS Developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>


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?


Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
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

Follow ups