← Back to team overview

dhis2-devs team mailing list archive

Re: Filtering sqlViews by name with foreign characters

 

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