dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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 <
traminosoa@xxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> 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