Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006856Openbravo ERP00. Application dictionarypublic2009-01-12 18:442009-04-21 12:36
Reporternetworkb 
Assigned Toshuehner 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.35MP10 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006856: "To" value (in numeric fields) in search pop-ups is not taken into account in generated windows
DescriptionWhen a column in Tables and Columns, defined as Numeric, and it is checked as Filter column, the application shows two values in seach pop-up: from and to.
If a value is put in "From" field, the application filters the grid using this value. But if a value is entered in "To" field, the application ignores this value and the grid is not filtered by this value.
Steps To ReproduceGo to "Tables and column", and search C_Order.
Check GrandTotal column as Filter column
Compile order window
Go to Sales Order window, and open seach pop-up.
Two values will be shown (Grand Total Amount From, and To). Enter a value in "To" field. The application does not filter using this value.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0006858 closed shuehner "To" value (in numeric fields) in search pop-ups is not taken into account in generated windows 
depends on backport 0006859 closed shuehner "To" value (in numeric fields) in search pop-ups is not taken into account in generated windows 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-12 18:44networkbNew Issue
2009-01-12 18:44networkbAssigned To => rafaroda
2009-01-12 18:44networkbsf_bug_id0 => 2501944
2009-01-12 18:44networkbOBNetwork customer => Yes
2009-01-12 18:44networkbRegression testing => No
2009-01-12 19:13rafarodaStatusnew => scheduled
2009-01-12 19:13rafarodaAssigned Torafaroda => shuehner
2009-01-12 19:13rafarodafix_in_branch => trunk
2009-01-12 20:21shuehnerNote Added: 0012131
2009-01-13 19:34svnbotCheckin
2009-01-13 19:34svnbotNote Added: 0012158
2009-01-13 19:34svnbotStatusscheduled => resolved
2009-01-13 19:34svnbotResolutionopen => fixed
2009-01-13 19:34svnbotsvn_revision => 11857
2009-04-21 12:36psarobeStatusresolved => closed

Notes
(0012131)
shuehner   
2009-01-12 20:21   
Problem is that the search popup renders from/to fields for a lot of reference-types, but ModelSQLGeneration does generate filtering code for the second field for the date-datatype only.

This does not only affect fields of type Amount (as described in the issue) but all fields which have a to-filter-field (<=) and are not date-fields.
(0012158)
svnbot   
2009-01-13 19:34   
Repository: openbravo
Revision: 11857
Author: huehner
Date: 2009-01-13 19:34:37 +0100 (Tue, 13 Jan 2009)

Fixed 6856
Fixes "To" value (in numeric fields) in search pop-ups is not taken into account in generated windows
by syncing the list of field which have a "To" value between Popup display generation and sql generation

---
U trunk/src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=11857&sc=1 [^]