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 | kasozis@gmail.com | Skype: sam.kasoziug

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 kasozis@gmail.com 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 | kasozis@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.pickering@gmail.com
tel:+46764147049

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 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering jason.p.pickering@gmail.com 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 kasozis@gmail.com 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 | kasozis@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.pickering@gmail.com
tel:+46764147049

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 kasozis@gmail.com wrote:

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.


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Sam Kasozi
Information Systems Consultant
HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
+256 757 662752 | +256 788 993565 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering jason.p.pickering@gmail.com 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 kasozis@gmail.com 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 | kasozis@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.pickering@gmail.com
tel:+46764147049

Fixed in trunk and backported to 2.16.

···


Morten

On Sun, Sep 7, 2014 at 2:27 PM, Jason Pickering jason.p.pickering@gmail.com 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


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

On Sun, Sep 7, 2014 at 8:56 AM, Sam Kasozi kasozis@gmail.com wrote:

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.


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Sam Kasozi
Information Systems Consultant
HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
+256 757 662752 | +256 788 993565 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering jason.p.pickering@gmail.com 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 kasozis@gmail.com 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 | kasozis@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.pickering@gmail.com
tel:+46764147049

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 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 10:43 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Fixed in trunk and backported to 2.16.


Morten

On Sun, Sep 7, 2014 at 2:27 PM, Jason Pickering jason.p.pickering@gmail.com 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


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

On Sun, Sep 7, 2014 at 8:56 AM, Sam Kasozi kasozis@gmail.com wrote:

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.


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Sam Kasozi
Information Systems Consultant
HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
+256 757 662752 | +256 788 993565 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering jason.p.pickering@gmail.com 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 kasozis@gmail.com 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 | kasozis@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.pickering@gmail.com
tel:+46764147049

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 kasozis@gmail.com wrote:

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 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 10:43 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Fixed in trunk and backported to 2.16.


Morten

On Sun, Sep 7, 2014 at 2:27 PM, Jason Pickering jason.p.pickering@gmail.com 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


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

On Sun, Sep 7, 2014 at 8:56 AM, Sam Kasozi kasozis@gmail.com wrote:

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.


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Sam Kasozi
Information Systems Consultant
HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
+256 757 662752 | +256 788 993565 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering jason.p.pickering@gmail.com 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 kasozis@gmail.com 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 | kasozis@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.pickering@gmail.com
tel:+46764147049

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
+256 757 662752 | +256 788 993565 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 11:06 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

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 kasozis@gmail.com wrote:

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 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 10:43 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Fixed in trunk and backported to 2.16.


Morten

On Sun, Sep 7, 2014 at 2:27 PM, Jason Pickering jason.p.pickering@gmail.com 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


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

On Sun, Sep 7, 2014 at 8:56 AM, Sam Kasozi kasozis@gmail.com wrote:

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.


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Sam Kasozi
Information Systems Consultant
HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
+256 757 662752 | +256 788 993565 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering jason.p.pickering@gmail.com 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 kasozis@gmail.com 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 | kasozis@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.pickering@gmail.com
tel:+46764147049

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 Kasozi <kasozis@gmail.com> wrote:

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
+256 757 662752 | +256 788 993565 | kasozis@gmail.com | Skype:
sam.kasoziug

On Sun, Sep 7, 2014 at 11:06 AM, Morten Olav Hansen <mortenoh@gmail.com> > wrote:

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 <kasozis@gmail.com> wrote:

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 | kasozis@gmail.com | Skype:
sam.kasoziug

On Sun, Sep 7, 2014 at 10:43 AM, Morten Olav Hansen <mortenoh@gmail.com> >>> wrote:

Fixed in trunk and backported to 2.16.

--
Morten

On Sun, Sep 7, 2014 at 2:27 PM, Jason Pickering < >>>> jason.p.pickering@gmail.com> wrote:

Yeah, I see what you mean. They are simply not there on the list of
resources.

DHIS2 App Hub works however.

Regards,
Jason

On Sun, Sep 7, 2014 at 8:56 AM, Sam Kasozi <kasozis@gmail.com> wrote:

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 | kasozis@gmail.com | Skype:
sam.kasoziug

On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering < >>>>>> jason.p.pickering@gmail.com> 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 <kasozis@gmail.com> >>>>>>> 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 | kasozis@gmail.com | Skype:
sam.kasoziug

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

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 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 11:36 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

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 Kasozi kasozis@gmail.com wrote:

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
+256 757 662752 | +256 788 993565 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 11:06 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

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 kasozis@gmail.com wrote:

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 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 10:43 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Fixed in trunk and backported to 2.16.


Morten

On Sun, Sep 7, 2014 at 2:27 PM, Jason Pickering jason.p.pickering@gmail.com 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


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

On Sun, Sep 7, 2014 at 8:56 AM, Sam Kasozi kasozis@gmail.com wrote:

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.


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Sam Kasozi
Information Systems Consultant
HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
+256 757 662752 | +256 788 993565 | kasozis@gmail.com | Skype: sam.kasoziug

On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering jason.p.pickering@gmail.com 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 kasozis@gmail.com 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 | kasozis@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.pickering@gmail.com
tel:+46764147049