Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0015736 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | minor | always | 2011-01-24 01:32 | 2011-05-24 10:55 | |||
Reporter | johnfandl | View Status | public | |||||
Assigned To | mtaal | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | pi | Fixed in SCM revision | 3c1493c46cf4 | |||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | PostgreSQL | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
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. | |||||||
Tags | closingMay2011 | |||||||
Attached Files | Sales_Order_with_backslash_character_in_Invoice_Address_Use_as_filter_does_not_work.PNG [^] (60,070 bytes) 2011-01-24 01:32
Sales_Order_with_backslash_character_in_Invoice_Address.PNG [^] (123,950 bytes) 2011-01-24 01:33 Sales_Order_with_backslash_character_in_Invoice_Address_ManuallyEnteredBackSlash_does_not_work.PNG [^] (51,290 bytes) 2011-01-24 01:34 | |||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0034425) hgbot (developer) 2011-02-28 15:51 |
Repository: erp/devel/pi Changeset: 3c1493c46cf415115dfd15474f72a03618b1551d Author: Martin Taal <martin.taal <at> openbravo.com> Date: Mon Feb 28 15:50:23 2011 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/3c1493c46cf415115dfd15474f72a03618b1551d [^] Fixes issue 15736: Backslash character (\) does not work for column filtering --- M modules/org.openbravo.service.json/src/org/openbravo/service/json/QueryBuilder.java --- |
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 |
Copyright © 2000 - 2009 MantisBT Group |