dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

SELECT uid,code,name from organisationunit
where hierarchylevel <=6;



On Tue, Jul 5, 2016 at 8:35 AM, Michael Mwebaze <michael.mwebaze@xxxxxxxxx>
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 <
> traminosoa@xxxxxxxxxx> wrote:
>
>> 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.*
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049