Thank you Michael. Regards,
Tantely. On Tue, Jul 5, 2016 at 3:35 PM, 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 >>> >> >> >> >> >> >> -- *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
