dhis2-users team mailing list archive

[Mark Polak <mark@xxxxxxxxxxxxxxx>]

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@xxxxxxxxx> wrote:

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