Re: [Dhis2-users] WebAPI resource - SQLview missing
Hi Jason, You can create the SQLview through the data administration module. However, when browsing the WebAPI, it does not appear among the listed resources. I created a empty databases and tried with one of the latest war files, however it was not appearing either. Sam Kasozi Information Systems Consultant HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center +256 757 662752 | +256 788 993565 | kaso...@gmail.com | Skype: sam.kasoziug On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering wrote: > Hi Sam, > Do you mean that you do not see any views in an empty database, or that > you are unable to access the "SQL View" functionality through the "Data > administration" dialog? > > Regards, > Jason > > > > On Sun, Sep 7, 2014 at 8:14 AM, Sam Kasozi wrote: > >> Hi all, I see the SQLview resource on the demo server, however it does >> seem to appear on any other instances; including an empty database running >> 2.16 >> (16404) >> >> regards, >> >> Sam Kasozi >> Information Systems Consultant >> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center >> +256 757 662752 | +256 788 993565 | kaso...@gmail.com | Skype: >> sam.kasoziug >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 > ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] WebAPI resource - SQLview missing
Hi Sam, Do you mean that you do not see any views in an empty database, or that you are unable to access the "SQL View" functionality through the "Data administration" dialog? Regards, Jason On Sun, Sep 7, 2014 at 8:14 AM, Sam Kasozi wrote: > Hi all, I see the SQLview resource on the demo server, however it does > seem to appear on any other instances; including an empty database running > 2.16 > (16404) > > regards, > > Sam Kasozi > Information Systems Consultant > HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center > +256 757 662752 | +256 788 993565 | kaso...@gmail.com | Skype: > sam.kasoziug > > ___ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049 ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] WebAPI resource - SQLview missing
Hi all, I see the SQLview resource on the demo server, however it does seem to appear on any other instances; including an empty database running 2.16 ( 16404) regards, Sam Kasozi Information Systems Consultant HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center +256 757 662752 | +256 788 993565 | kaso...@gmail.com | Skype: sam.kasoziug ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Averaging over orgunits
Hi - i just want to add support to the importance of splitting the aggregator operator across time and org units. I'm planning around its availability for 2.17 Rodolfo Meliá > On 5 Sep 2014, at 17:26, Robin Martens wrote: > > Hi Lars, > > Thank you. I thought so but couldn't find the reference. > > In the blueprint it is assigned to release 2.17, is this still being > maintained? > > Regards, > > Robin > > From: Lars Helge Øverland [mailto:larshe...@gmail.com] > Sent: 05 September 2014 18:24 > To: Robin Martens > Cc: dhis2-users; dhis2-d...@lists.launchpad.net > Subject: Re: DHIS2 - Averaging over orgunits > > Hi Robin, > > I get your point. This has actually been raised before and we plan to support > individual aggregation operators for the org unit and time dimensions. > Blueprint here: > > https://blueprints.launchpad.net/dhis2/+spec/orgunit-hierarchy-aggregation-operator > > regards, > > Lars > > > > > > > On Thu, Sep 4, 2014 at 12:49 PM, Robin Martens wrote: > Hi there, > > As per the manual, the "average" option when defining data elements > aggregates by average over periods but sum over orgunits. This limits > severely the reporting possibilities, for instance when calculating the > average person age over multiple districts but I can think of many other > examples (prices, age, education grades,...). Is there any way to configure > DHIS2 to average over orgunits? > > Thank you, > > Robin > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Retrieve Indicator values through WEB API
Hello Morina, a good way of learning how the analytics web api works is to use the pivot table and play around with indicator data there. When you have created a pivot view of the indicators you want you can click download > plan data source - JSON. From this you can study the URL in your browser in order to understand the analytics URL syntax. Let us know how it goes. regards, Lars On Sat, Sep 6, 2014 at 9:47 AM, Morina Matasi wrote: > I want to retrieve indicator values through WEB API. Can somebody help, > the manual is not very clear (have tried examples in vain) on how to > retrieve data from indicators, or I am missing something. > > Regards, > > Morina > > > ___ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Retrieve Indicator values through WEB API
https://www.dhis2.org/doc/snapshot/en/user/html/ch32s21.html Example: api/analytics?dimension=dx:&dimension=pe:2013&dimension=ou: On Sat, Sep 6, 2014 at 3:49 PM, Knut Staring wrote: > "have tried examples in vain" is not very informative. > > Which examples, what results? > > > On Sat, Sep 6, 2014 at 8:17 PM, Morina Matasi > wrote: > >> I want to retrieve indicator values through WEB API. Can somebody help, >> the manual is not very clear (have tried examples in vain) on how to >> retrieve data from indicators, or I am missing something. >> >> Regards, >> >> Morina >> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > +4791880522 > http://dhis2.org > > ___ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Retrieve Indicator values through WEB API
"have tried examples in vain" is not very informative. Which examples, what results? On Sat, Sep 6, 2014 at 8:17 PM, Morina Matasi wrote: > I want to retrieve indicator values through WEB API. Can somebody help, > the manual is not very clear (have tried examples in vain) on how to > retrieve data from indicators, or I am missing something. > > Regards, > > Morina > > > ___ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Knut Staring Dept. of Informatics, University of Oslo +4791880522 http://dhis2.org ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] Retrieve Indicator values through WEB API
I want to retrieve indicator values through WEB API. Can somebody help, the manual is not very clear (have tried examples in vain) on how to retrieve data from indicators, or I am missing something. Regards, Morina ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp