[Dhis2-devs] User queries on Users table

Hi

on DHIS2 v2.16,

I cannot save the following query,

···

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

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 knutst@gmail.com wrote:

---------- Forwarded message ----------
From: Juma Lungo jlungo@yahoo.com
Date: Fri, Dec 4, 2015 at 9:44 AM
Subject: [Dhis2-devs] User queries on Users table
To: DHIS Developers dhis2-devs@lists.launchpad.net

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@lists.launchpad.net

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 : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp