← Back to team overview

dhis2-users team mailing list archive

Re: WebAPI resource - SQLview missing

 

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@xxxxxxxxx> 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@xxxxxxxxx | Skype:
> sam.kasoziug
>
>
> On Sun, Sep 7, 2014 at 11:06 AM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
> 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@xxxxxxxxx> 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@xxxxxxxxx | Skype:
>>> sam.kasoziug
>>>
>>>
>>> On Sun, Sep 7, 2014 at 10:43 AM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
>>> wrote:
>>>
>>>> Fixed in trunk and backported to 2.16.
>>>>
>>>> --
>>>> Morten
>>>>
>>>>
>>>> On Sun, Sep 7, 2014 at 2:27 PM, Jason Pickering <
>>>> jason.p.pickering@xxxxxxxxx> 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, 2014 at 8:56 AM, Sam Kasozi <kasozis@xxxxxxxxx> 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@xxxxxxxxx | Skype:
>>>>>> sam.kasoziug
>>>>>>
>>>>>>
>>>>>> On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering <
>>>>>> jason.p.pickering@xxxxxxxxx> 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@xxxxxxxxx>
>>>>>>> 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@xxxxxxxxx | Skype:
>>>>>>>> sam.kasoziug
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> 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
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Jason P. Pickering
>>>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>>>> tel:+46764147049
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Jason P. Pickering
>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>> tel:+46764147049
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>>
>>>>>
>>>>
>>>
>>
>

Follow ups

References