Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0015736 | Openbravo ERP | A. Platform | public | 2011-01-24 01:32 | 2011-05-24 10:55 |
|
| Reporter | johnfandl | |
| Assigned To | mtaal | |
| 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 | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0015736: Backslash character (\) does not work for column filtering |
| Description | The backslash character is not recognized when filtering. |
| Steps To Reproduce | 1. Select Sales order option (with ?window=new) from menu [OK]
2. Select row with '.La , C\Pescadores, 87' as the Invoice Address [OK]
3. Right-click on the Invoice Address column and select "Use as Filter" [NOK]
System should filter the result set to only return rows with an Invoice Address of '.La , C\Pescadores, 87'. Instead, no result is returned.
You can also demonstrate the behavior by just keying in the \ character in the Invoice Address column, directly. |
| Proposed Solution | \ is a special SQL escape character. Special characters in SQL need to be handled as exceptions, e.g. probably surround the string in single quotes or 2 single quotes.
Saw this problem in PostgreSQL, did not test in Oracle--should be corrected and then tested for both. |
| Additional Information | |
| Tags | closingMay2011 |
| Relationships | |
| Attached Files |  Sales_Order_with_backslash_character_in_Invoice_Address_Use_as_filter_does_not_work.PNG (60,070) 2011-01-24 01:32
https://issues.openbravo.com/file_download.php?file_id=3530&type=bug
Sales_Order_with_backslash_character_in_Invoice_Address.PNG (123,950) 2011-01-24 01:33
https://issues.openbravo.com/file_download.php?file_id=3531&type=bug
Sales_Order_with_backslash_character_in_Invoice_Address_ManuallyEnteredBackSlash_does_not_work.PNG (51,290) 2011-01-24 01:34
https://issues.openbravo.com/file_download.php?file_id=3532&type=bug
|
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2011-01-24 01:32 | johnfandl | New Issue | |
| 2011-01-24 01:32 | johnfandl | Assigned To | => alostale |
| 2011-01-24 01:32 | johnfandl | File Added: Sales_Order_with_backslash_character_in_Invoice_Address_Use_as_filter_does_not_work.PNG | |
| 2011-01-24 01:32 | johnfandl | Modules | => Core |
| 2011-01-24 01:33 | johnfandl | Issue Monitored: johnfandl | |
| 2011-01-24 01:33 | johnfandl | File Added: Sales_Order_with_backslash_character_in_Invoice_Address.PNG | |
| 2011-01-24 01:34 | johnfandl | File Added: Sales_Order_with_backslash_character_in_Invoice_Address_ManuallyEnteredBackSlash_does_not_work.PNG | |
| 2011-01-24 08:12 | alostale | Status | new => scheduled |
| 2011-01-24 08:12 | alostale | Assigned To | alostale => mtaal |
| 2011-01-24 08:12 | alostale | fix_in_branch | => pi |
| 2011-02-28 15:51 | hgbot | Checkin | |
| 2011-02-28 15:51 | hgbot | Note Added: 0034425 | |
| 2011-02-28 15:51 | hgbot | Status | scheduled => resolved |
| 2011-02-28 15:51 | hgbot | Resolution | open => fixed |
| 2011-02-28 15:51 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/3c1493c46cf415115dfd15474f72a03618b1551d [^] |
| 2011-05-24 10:11 | dalsasua | Tag Attached: closingMay2011 | |
| 2011-05-24 10:55 | dalsasua | Status | resolved => closed |