dhis2-users team mailing list archive

[Michael Mwebaze <michael.mwebaze@xxxxxxxxx>]

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