dhis2-users team mailing list archive

["Raminosoa Rabemanantsoa, Tantely" <traminosoa@xxxxxxxxxx>]

Thank you Knut for your suggestion.

Regards,

Tantely.

On Tue, Jul 5, 2016 at 10:53 AM, Knut Staring <knutst@xxxxxxxxx> 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 <
> 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
>



-- 
*Tantely Raminosoa*
*Data Officer*
Management Sciences for Health
Antananarivo Madagascar
Mobile: 0321180040
E-mail: traminosoa@xxxxxxxxxx
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.*