0022569: Format of numeric filter value is changed when filtering - numeric keyboard dot does not result in the comma in the filter field

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #22569		[ All Revisions ] [ Back to Issue ]
Summary	0022569: Format of numeric filter value is changed when filtering - numeric keyboard dot does not result in the comma in the filter field

Revision	2012-12-13 14:39 by mtaal
Description	When I enter a filter value of 11,64 the system changes it to 11.64. Also when entering a dot through the numeric keyboard I get a dot instead of the expected comma. This can be reproduced by setting the correct number format.

Revision	2012-12-13 14:14 by mtaal
Description	Filtering on numeric value gives an error when the grouping/decimal symbol are set to US values. The number is sent as it is to the server and not translated to a real valid number which can be parsed on the server. The exception: 21986b5e 416662 [http-8080-4] ERROR org.openbravo.base.exception.OBException - Invalid filter value 11.6400,00. org.openbravo.base.exception.OBException: Invalid filter value 11.6400,00. at org.openbravo.service.json.AdvancedQueryBuilder.buildValueClause(AdvancedQueryBuilder.java:591) at org.openbravo.service.json.AdvancedQueryBuilder.buildRightClause(AdvancedQueryBuilder.java:460) at org.openbravo.service.json.AdvancedQueryBuilder.parseSimpleClause(AdvancedQueryBuilder.java:408) at org.openbravo.service.json.AdvancedQueryBuilder.parseSingleClause(AdvancedQueryBuilder.java:372) at org.openbravo.service.json.AdvancedQueryBuilder.parseCriteria(AdvancedQueryBuilder.java:290) at org.openbravo.service.json.AdvancedQueryBuilder.parseStructuredClause(AdvancedQueryBuilder.java:790) at org.openbravo.service.json.AdvancedQueryBuilder.parseAdvancedCriteria(AdvancedQueryBuilder.java:771) at org.openbravo.service.json.AdvancedQueryBuilder.parseCriteria(AdvancedQueryBuilder.java:288) at org.openbravo.service.json.AdvancedQueryBuilder.getWhereClause(AdvancedQueryBuilder.java:182) at org.openbravo.service.json.AdvancedQueryBuilder.getJoinClause(AdvancedQueryBuilder.java:1057) at org.openbravo.service.json.DataEntityQueryService.buildOBQuery(DataEntityQueryService.java:118) at org.openbravo.service.json.DefaultJsonDataService.fetch(DefaultJsonDataService.java:145) at org.openbravo.service.datasource.DefaultDataSourceService.fetch(DefaultDataSourceService.java:72) at org.openbravo.service.datasource.DataSourceServlet.doFetch(DataSourceServlet.java:243) at org.openbravo.service.datasource.DataSourceServlet.doPost(DataSourceServlet.java:611) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:435) at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87) at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:63) at org.openbravo.service.datasource.DataSourceServlet.service(DataSourceServlet.java:125) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.activiti.OBActivitiRequestFilter$1.doAction(OBActivitiRequestFilter.java:68) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.activiti.OBActivitiRequestFilter.doFilter(OBActivitiRequestFilter.java:81) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) 21986b5e 416663 [http-8080-4] ERROR org.openbravo.service.json.DefaultJsonDataService - Invalid filter value 11.6400,00. org.openbravo.base.exception.OBException: Invalid filter value 11.6400,00. at org.openbravo.service.json.AdvancedQueryBuilder.buildValueClause(AdvancedQueryBuilder.java:591) at org.openbravo.service.json.AdvancedQueryBuilder.buildRightClause(AdvancedQueryBuilder.java:460) at org.openbravo.service.json.AdvancedQueryBuilder.parseSimpleClause(AdvancedQueryBuilder.java:408) at org.openbravo.service.json.AdvancedQueryBuilder.parseSingleClause(AdvancedQueryBuilder.java:372) at org.openbravo.service.json.AdvancedQueryBuilder.parseCriteria(AdvancedQueryBuilder.java:290) at org.openbravo.service.json.AdvancedQueryBuilder.parseStructuredClause(AdvancedQueryBuilder.java:790) at org.openbravo.service.json.AdvancedQueryBuilder.parseAdvancedCriteria(AdvancedQueryBuilder.java:771) at org.openbravo.service.json.AdvancedQueryBuilder.parseCriteria(AdvancedQueryBuilder.java:288) at org.openbravo.service.json.AdvancedQueryBuilder.getWhereClause(AdvancedQueryBuilder.java:182) at org.openbravo.service.json.AdvancedQueryBuilder.getJoinClause(AdvancedQueryBuilder.java:1057) at org.openbravo.service.json.DataEntityQueryService.buildOBQuery(DataEntityQueryService.java:118) at org.openbravo.service.json.DefaultJsonDataService.fetch(DefaultJsonDataService.java:145) at org.openbravo.service.datasource.DefaultDataSourceService.fetch(DefaultDataSourceService.java:72) at org.openbravo.service.datasource.DataSourceServlet.doFetch(DataSourceServlet.java:243) at org.openbravo.service.datasource.DataSourceServlet.doPost(DataSourceServlet.java:611) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:435) at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87) at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:63) at org.openbravo.service.datasource.DataSourceServlet.service(DataSourceServlet.java:125) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.activiti.OBActivitiRequestFilter$1.doAction(OBActivitiRequestFilter.java:68) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.activiti.OBActivitiRequestFilter.doFilter(OBActivitiRequestFilter.java:81) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) 21986b5e 416664 [http-8080-4] INFO org.openbravo.erpCommon.utility.ErrorTextParserPOSTGRE - did not find constraint name for error message: Invalid filter value 11.6400,00.