dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

---------- 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>


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     : 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
http://dhis2.org