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...@lists.launchpad.net] De la part de Raminosoa Rabemanantsoa, Tantely Envoyé : lundi 10 avril 2017 17:19 À : DHIS 2 Users list <dhis2-users@lists.launchpad.net>; DHIS 2 Developers list <dhis2-d...@lists.launchpad.net> 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
_______________________________________________ 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
