dhis2-users team mailing list archive

[channara rin <rin.channara@xxxxxxxxx>]

Hi all,
do you have some explaination relate to table schema?
when i open, it alot of table.

thank you
channara

On Tue, Jul 5, 2016 at 8:19 PM, Raminosoa Rabemanantsoa, Tantely <
traminosoa@xxxxxxxxxx> wrote:

> Thank you Michael.
>
> Regards,
>
> Tantely.
>
> On Tue, Jul 5, 2016 at 3:35 PM, 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
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>
> *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
>
>