SELECT uid,code,name from organisationunit where hierarchylevel <=6;
On Tue, Jul 5, 2016 at 8:35 AM, Michael Mwebaze <michael.mweb...@gmail.com> wrote: > Hi Tantely, > > Standard ANSI SQL can be executed easily with-in Sqlviews sub-module in > DHIS2. The link below should be helpful. > > http://dhis2.github.io/dhis2-docs/2.22/en/user/html/ch22s06.html > > Regards, > > Michael > > On 5 July 2016 at 04:45, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> 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-users >> Post to : dhis2-us...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049
_______________________________________________ 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