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-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp