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
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@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
jason
(Jason Pickering)
8 July 2015 19:38
3
Any reason you simply do not use the UID of the sql view instead?
···
On Wed, Jul 8, 2015 at 11:49 AM, Alan Hill ahill@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
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@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 ahill@2paths.com wrote:
Fixed: needed to set
URIEncoding=“UTF-8”
in tomcat’s server.xml file.
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
On Wed, Jul 8, 2015 at 11:49 AM, Alan Hill ahill@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
jason
(Jason Pickering)
8 July 2015 19:55
5
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 at 12:38 PM, Jason Pickering jason.p.pickering@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 ahill@2paths.com wrote:
Fixed: needed to set
URIEncoding=“UTF-8”
in tomcat’s server.xml file.
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
On Wed, Jul 8, 2015 at 11:49 AM, Alan Hill ahill@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
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.pickering@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 ahill@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.pickering@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 ahill@2paths.com wrote:
Fixed: needed to set
URIEncoding=“UTF-8”
in tomcat’s server.xml file.
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
On Wed, Jul 8, 2015 at 11:49 AM, Alan Hill ahill@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