← Back to team overview

dhis2-devs team mailing list archive

Filtering sqlViews by name with foreign characters

 

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

Follow ups