Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015736
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2011-01-24 01:322011-05-24 10:55
ReporterjohnfandlView Statuspublic 
Assigned Tomtaal 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision3c1493c46cf4
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015736: Backslash character (\) does not work for column filtering

DescriptionThe backslash character is not recognized when filtering.
Steps To Reproduce1. 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.
TagsclosingMay2011
Attached Filespng file icon Sales_Order_with_backslash_character_in_Invoice_Address_Use_as_filter_does_not_work.PNG [^] (60,070 bytes) 2011-01-24 01:32


png file icon Sales_Order_with_backslash_character_in_Invoice_Address.PNG [^] (123,950 bytes) 2011-01-24 01:33


png file icon 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
Powered by Mantis Bugtracker