Thank you Knut for your suggestion. Regards,
Tantely. On Tue, Jul 5, 2016 at 10:53 AM, Knut Staring <knu...@gmail.com> wrote: > Hi Raminosa, > > I think you should try to install Postgres locally on your laptop, which > would allow you to easily query the database using PgAdmin. > > Regards, > Knut > > On Tue, Jul 5, 2016 at 9:13 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Hi All, >> >> >> I am looking for a documentation of the use of the SQL syntax to run in >> SQL View (table names, field names specific to DHIS2 ). I have seen for >> example to query organization unit, we have to select from “ou” or to use >> “dv” to select the datavalues. I am planning to list all the uid, code and >> names of all organization units at all levels (1 to 6) in one single query >> result. >> >> >> Thank you for your support. >> >> >> 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.* >> _______________________________________________ >> 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 > -- *Tantely Raminosoa* *Data Officer* Management Sciences for Health Antananarivo Madagascar Mobile: 0321180040 E-mail: tramino...@mikolo.org Skype: traminosoa <http://www.msh.org/> Stronger health systems. Greater health impact. <https://www.facebook.com/ManagementSciencesForHealth> <https://twitter.com/MSHHealthImpact> <https://www.youtube.com/user/MSHHealthImpact> www.msh.org -- *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.*
_______________________________________________ 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
