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
_______________________________________________ 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