← Back to team overview

dhis2-users team mailing list archive

Re: WebAPI resource - SQLview missing

 

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@xxxxxxxxx | Skype: sam.kasoziug


On Sun, Sep 7, 2014 at 11:36 AM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
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@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
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>

References