Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009691Openbravo ERPA. Platformpublic2009-06-29 10:562009-07-16 17:55
Reporterpsarobe 
Assigned Toshuehner 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionpiFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009691: The filter pop-up/search pop-up does not work properly
DescriptionThe filter pop-up in the generated windows does not work properly. After entering the parameters for the filter, no result is retrieved. To see the data you need either to refresh the window or to move to another window and then move back
Steps To Reproduce1. Create some sales invoices with date 20/06/2009 and complete them
2. Click the filter pop-up and type from date invoice 25/06/2009
3. No data is retrieved. This is correct
4. Filter by 19/06/2009 and click OK. No data is retrieved. This is wrong
5. Refresh the window or go to another one and come back and you will see the data
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0008972 closed alostale Not possible to use attribute as a filter field 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-29 10:56psarobeNew Issue
2009-06-29 10:56psarobeAssigned To => shuehner
2009-06-29 10:56psarobeStatusnew => scheduled
2009-06-29 10:56psarobefix_in_branch => pi
2009-06-29 14:36shuehnerRelationship addedrelated to 0008972
2009-06-29 14:37shuehnerNote Added: 0017641
2009-06-29 15:22shuehnerNote Added: 0017642
2009-06-29 16:05hgbotCheckin
2009-06-29 16:05hgbotNote Added: 0017645
2009-06-29 16:05hgbotStatusscheduled => resolved
2009-06-29 16:05hgbotResolutionopen => fixed
2009-06-29 16:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7f9b17719565283e4ed51468f58e46e1f830a021 [^]
2009-07-03 13:15hgbotCheckin
2009-07-03 13:15hgbotNote Added: 0017888
2009-07-03 13:15hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/7f9b17719565283e4ed51468f58e46e1f830a021 [^] => http://code.openbravo.com/erp/devel/pi/rev/01c2c9482129feccaa2388ad2dc930f1b8a5d8ab [^]
2009-07-07 11:10sureshbabuStatusresolved => closed
2009-07-07 11:10sureshbabuNote Added: 0017957
2009-07-07 11:10sureshbabuFixed in Version => pi
2009-07-16 17:55anonymoussf_bug_id0 => 2822580

Notes
(0017641)
shuehner   
2009-06-29 14:37   
This is a regression introduced in commit 9859ac217a3f for issue 8972.
(0017642)
shuehner   
2009-06-29 15:22   
8972 was backported, but the backport does not have the same error. So 2.40 branch is not affected (tested on current 2.40/oracle).
(0017645)
hgbot   
2009-06-29 16:05   
Repository: erp/devel/pi
Changeset: 7f9b17719565283e4ed51468f58e46e1f830a021
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Jun 29 16:05:18 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7f9b17719565283e4ed51468f58e46e1f830a021 [^]

Fixed 9691: Fixes The filter pop-up/search pop-up does not work properly
- Reintroduce optimization to optimize away % for where clauses with like and c_ignore_accent
- This optimization was lost acciedently in commit for issue 8972
- This works around 9459

---
M src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java
---
(0017888)
hgbot   
2009-07-03 13:15   
Repository: erp/devel/pi
Changeset: 01c2c9482129feccaa2388ad2dc930f1b8a5d8ab
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Jun 29 16:05:18 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/01c2c9482129feccaa2388ad2dc930f1b8a5d8ab [^]

Fixed 9691: Fixes The filter pop-up/search pop-up does not work properly
- Reintroduce optimization to optimize away % for where clauses with like and c_ignore_accent
- This optimization was lost acciedently in commit for issue 8972
- This works around 9459

---
M src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java
---
(0017957)
sureshbabu   
2009-07-07 11:10   
Tested Filer pop up is working fine for all filter options.