← Back to team overview

dhis2-devs team mailing list archive

Re: Filtering sqlViews by name with foreign characters

 

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 <ahill@xxxxxxxxxx> 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.pickering@xxxxxxxxx> wrote:
>
>> Any reason you simply do not use the UID of the sql view instead?
>>
>> On Wed, Jul 8, 2015, 21:18 Alan Hill <ahill@xxxxxxxxxx> 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 <ahill@xxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>

Follow ups

References