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 < tramino...@mikolo.org> wrote: > Thank you Michael. > > Regards, > > Tantely. > > On Tue, Jul 5, 2016 at 3:35 PM, Michael Mwebaze <michael.mweb...@gmail.com > > 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 < >> tramino...@mikolo.org> wrote: >> >>> Thank you Knut for your suggestion. >>> >>> Regards, >>> >>> Tantely. >>> >>> On Tue, Jul 5, 2016 at 10:53 AM, Knut Staring <knu...@gmail.com> 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 < >>>> tramino...@mikolo.org> 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@lists.launchpad.net >>>>> 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-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
