Thanks Jason.

We have just created the views through the UI but realise that we should
probably do it through the API.

Thanks for your help.

Regards

Alan


On Wed, Jul 8, 2015 at 12:55 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Ok, bit you could create the view with a known UID by transmitting this
> through the API , and even if you changed the name, the UID would never
> change. Would seem to be simpler and more reliable.
>
> Regards,
> Jason
>
> On Wed, Jul 8, 2015, 21:45 Alan Hill <ah...@2paths.com> wrote:
>
>> Only that we are not creating the view with a known UID.
>>
>> On Wed, Jul 8, 2015 at 12:38 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Any reason you simply do not use the UID of the sql view instead?
>>>
>>> On Wed, Jul 8, 2015, 21:18 Alan Hill <ah...@2paths.com> wrote:
>>>
>>>> Fixed: needed to set
>>>>
>>>>     URIEncoding="UTF-8"
>>>>
>>>> in tomcat's server.xml file.
>>>>
>>>>
>>>> On Wed, Jul 8, 2015 at 11:49 AM, Alan Hill <ah...@2paths.com> wrote:
>>>>
>>>>> Hi there
>>>>>
>>>>> We have a number of sqlViews in our DHIS2 instance with foreign
>>>>> characters e.g.
>>>>>
>>>>>     Programmes avec les données
>>>>>
>>>>> We are having trouble retrieving these by name through the API e.g.
>>>>>
>>>>>     /api/sqlViews.json?filter=name:eq:Programmes%20avec%20les%20données
>>>>>
>>>>> However, the following does retrieve the sqlView:
>>>>>
>>>>>     /api/sqlViews.json?filter=name:like:Programmes%20avec%20les%20donn
>>>>>
>>>>>
>>>>> This is occurring within a BAO deployed DHIS2 instance.
>>>>>
>>>>> Strangely, the problem does not exist within our own local install of
>>>>> DHIS2.
>>>>>
>>>>> I have tried setting:
>>>>>
>>>>>     file.encoding=UTF-8
>>>>>
>>>>> in our tomcat7.conf file but this makes no difference.
>>>>>
>>>>> Not sure where else to look.
>>>>>
>>>>> Any suggestions greatly appreciated.
>>>>>
>>>>> Many thanks
>>>>>
>>>>> Alan
>>>>>
>>>>>
>>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>
>>
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Reply via email to