Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019253Openbravo ERPA. Platformpublic2011-12-06 17:132012-03-02 15:36
Reporterroklenardic 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browserApple Safari
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019253: filtering numbers using a range fails when there are spaces
Description1) go to live.builds.openbravo.com
2) Login
3) go to Sales Order screen
4) type in this into the Total Gross Amount column's filter: " < 100.00" (without the quotes and with the leading space)
5) unfriendly error appears:Error
Exception when creating query select e from Order as e where ( (( e.grandTotalAmount = null )) and ( ((e.salesTransaction=true AND e.transactionDocument.return= false) and ( ( e.updated > :alias_1 or e.processed = 'N' ) )) ) ) and e.organization.id in ('0', '4F68EB1C1B734E79B27DE9D2DF56089F', '0D8E225ADA6E425E98EAA0F34E5912D7', 'B9C7088AB859483A9B1FB342AC2BE17A', '90A1F59849E84AFABD04814B3D15A691', '378AF0EAE1A2479EAAA33436645E9433', '3C816D72B14D4BBCB8571404B794AB84', '7A8E888A4B4C4E638CD5EB3A41A3289A') and e.client.id in ('FF8080812AFBCB14012AFBD3E373001F', '0')order by e.documentNo,e.id
Steps To Reproducesee above
Proposed Solutiontrim the filter conditions for leading and trailing spaces
Additional Information
TagsNo tags attached.
Relationships
related to defect 0019621 closed alostale Advance Filtering is not working correctly in some columns. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-12-06 17:13roklenardicNew Issue
2011-12-06 17:13roklenardicAssigned To => alostale
2011-12-06 17:13roklenardicWeb browser => Apple Safari
2011-12-06 17:13roklenardicModules => Core
2011-12-06 17:13roklenardicOBNetwork customer => No
2012-02-07 08:41alostaleRelationship addedrelated to 0019621
2012-02-10 17:54hgbotCheckin
2012-02-10 17:54hgbotNote Added: 0045021
2012-02-10 17:54hgbotStatusnew => resolved
2012-02-10 17:54hgbotResolutionopen => fixed
2012-02-10 17:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c583896380b2cc3b2211ebd47332b7c1895bb2af [^]
2012-02-10 17:54alostaleNote Added: 0045022
2012-02-27 15:28marvintmStatusresolved => closed
2012-03-02 15:36hudsonbotCheckin
2012-03-02 15:36hudsonbotNote Added: 0045807

Notes
(0045021)
hgbot   
2012-02-10 17:54   
Repository: erp/devel/pi
Changeset: c583896380b2cc3b2211ebd47332b7c1895bb2af
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Feb 10 17:53:36 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c583896380b2cc3b2211ebd47332b7c1895bb2af [^]

fixed bug 19253: filtering numbers using a range fails when there are spaces

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-number.js
---
(0045022)
alostale   
2012-02-10 17:54   
Fix trims complete expression and numeric values. No regression risk as it is affecting only filter in numeric fields.
(0045807)
hudsonbot   
2012-03-02 15:36   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test