Openbravo Issue Tracking System - Openbravo ERP |
View Issue Details |
|
ID | Project | Category | View Status | Date Submitted | Last Update |
0019253 | Openbravo ERP | A. Platform | public | 2011-12-06 17:13 | 2012-03-02 15:36 |
|
Reporter | roklenardic | |
Assigned To | alostale | |
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | |
Platform | | OS | 5 | OS Version | |
Product Version | pi | |
Target Version | | Fixed in Version | | |
Merge Request Status | |
Review Assigned To | |
OBNetwork customer | |
Web browser | Apple Safari |
Modules | Core |
Support ticket | |
Regression level | |
Regression date | |
Regression introduced in release | |
Regression introduced by commit | |
Triggers an Emergency Pack | No |
|
Summary | 0019253: filtering numbers using a range fails when there are spaces |
Description | 1) 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 Reproduce | see above |
Proposed Solution | trim the filter conditions for leading and trailing spaces |
Additional Information | |
Tags | No tags attached. |
Relationships | related to | defect | 0019621 | | closed | alostale | Advance Filtering is not working correctly in some columns. |
|
Attached Files | |
|
Issue History |
Date Modified | Username | Field | Change |
2011-12-06 17:13 | roklenardic | New Issue | |
2011-12-06 17:13 | roklenardic | Assigned To | => alostale |
2011-12-06 17:13 | roklenardic | Web browser | => Apple Safari |
2011-12-06 17:13 | roklenardic | Modules | => Core |
2012-02-07 08:41 | alostale | Relationship added | related to 0019621 |
2012-02-10 17:54 | hgbot | Checkin | |
2012-02-10 17:54 | hgbot | Note Added: 0045021 | |
2012-02-10 17:54 | hgbot | Status | new => resolved |
2012-02-10 17:54 | hgbot | Resolution | open => fixed |
2012-02-10 17:54 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/c583896380b2cc3b2211ebd47332b7c1895bb2af [^] |
2012-02-10 17:54 | alostale | Note Added: 0045022 | |
2012-02-27 15:28 | marvintm | Status | resolved => closed |
2012-03-02 15:36 | hudsonbot | Checkin | |
2012-03-02 15:36 | hudsonbot | Note Added: 0045807 | |