Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-07 Thread Sam Kasozi
Let me try that out. Thanks. 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 11:36 AM, Morten Olav Hansen wrote: > I think you are using

Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-07 Thread Morten Olav Hansen
I think you are using apps.dhis2.org/demo ? in that case, all the optionSets are empty, please try and create a new one, and add options. Also, FYI the format has changed for optionSets in trunk/2.17, since we now allows translation of options -- Morten On Sun, Sep 7, 2014 at 3:26 PM, Sam Kasoz

Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-07 Thread Sam Kasozi
Or perhaps I could rephrase it this way, >From the Data Administration, we have the Option set "Gender". How do i see the options for Gender option set; 'Male' and 'Female' from the Web API? Sam Kasozi Information Systems Consultant HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center

Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-07 Thread Morten Olav Hansen
Where are you seeing this? there is a bug with the 2.16 database ( apps.dhis2.org/demo), did you try and add options manually? they should then appear -- Morten On Sun, Sep 7, 2014 at 2:58 PM, Sam Kasozi wrote: > Thanks. > > Another missing resource is the options for the optionSet (items per

Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-07 Thread Sam Kasozi
Thanks. Another missing resource is the options for the optionSet (items per Option Set) 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 1

Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-07 Thread Morten Olav Hansen
Fixed in trunk and backported to 2.16. -- Morten On Sun, Sep 7, 2014 at 2:27 PM, Jason Pickering wrote: > Yeah, I see what you mean. They are simply not there on the list of > resources. > > https://apps.dhis2.org/demo/api/sqlViews works however. > > Regards, > Jason > > > > On Sun, Sep 7, 201

Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-07 Thread Jason Pickering
Yeah, I see what you mean. They are simply not there on the list of resources. https://apps.dhis2.org/demo/api/sqlViews works however. Regards, Jason On Sun, Sep 7, 2014 at 8:56 AM, Sam Kasozi wrote: > Hi Jason, > > You can create the SQLview through the data administration module. > However

Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-06 Thread Sam Kasozi
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 Sys

Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-06 Thread Jason Pickering
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 ser

[Dhis2-users] WebAPI resource - SQLview missing

2014-09-06 Thread Sam Kasozi
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