dhis2-devs team mailing list archive

[Harivola RANDRIANJAFY <harivolar@xxxxxx>]

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@xxxxxxxxxxxxxxxxxxx] 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.



---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus