dhis2-devs team mailing list archive

["Raminosoa Rabemanantsoa, Tantely" <traminosoa@xxxxxxxxxx>]

Hi Harivola,

Thank you very much for the SQL scripts querying the users information. The
syntax is accepted by SQL View, but I am a bit encountering a blank result
as illustrated by the attached file. I am wondering where I am doing wrong?

Thank you for your help!

Regards,

Tantely.



On Tue, Apr 11, 2017 at 3:38 PM, Harivola RANDRIANJAFY <harivolar@xxxxxx>
wrote:

> Tantely,
>
>
>
> Below the SQL View :
>
>
>
> SELECT
>
> "public".users.username,
>
> "public".userinfo.surname,
>
> "public".userinfo.firstname,
>
> "public".userinfo.email,
>
> "public".userinfo.phonenumber,
>
> "public".users.lastlogin,
>
> "public".users.created,
>
> "public".users.disabled,
>
> "public".userrole."name",
>
> "public".users.uid
>
> FROM
>
> "public".users
>
> INNER JOIN "public".userinfo ON "public".users.userid =
> "public".userinfo.userinfoid
>
> INNER JOIN "public".userrole ON "public".userrole.userid =
> "public".userinfo.userinfoid
>
>
>
>
>
> Thanks,
>
> Harivola
>
>
>
> *De :* Dhis2-users [mailto:dhis2-users-bounces+harivolar=psi.mg@lists.
> launchpad.net] *De la part de* Raminosoa Rabemanantsoa, Tantely
> *Envoyé :* lundi 10 avril 2017 17:19
> *À :* DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2
> Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> *Objet :* [Dhis2-users] DHIS2 users list from SQL View
>
>
>
> Dear Community,
>
>
>
> I would like to output from SQL View a list of all DHIS2 users by using
> headers like the information listed by the users details information, like
> illustrated by the image below (inside red ellipse).
>
>
>
>
> ​
>
>
>
> I am using DHIS2 2.24. I would like to check the users table fields but I
> could not output any information from the following query
>
>
>
> select * from users;
>
>
>
> as trhere are some protected info.
>
>
>
> My question is in which fields should I base the SQL query to output such
> information?
>
>
>
> Thank you for your support,
>
>
>
> Regards,
>
>
>
> Tantely
>
> ​
>
>
>
>
>
>
>
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> Garanti
> sans virus. www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*

Attachment: DHIS2 Users list1.pdf
Description: Adobe PDF document