Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018223Openbravo ERPA. Platformpublic2011-08-08 12:142011-09-01 16:34
Reporterpsarobe 
Assigned Toiperdomo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP2Fixed in Version3.0MP2 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018223: You cannot see the business partners associate to a particular volume discount
DescriptionYou cannot see the business partners associate to a particular volume discount. The problem seems to be in the HQL where clause
Steps To ReproduceLogin as Openbravo/openbravo
Change the role to QA admin
Go to Volume discount window
Select "Volume discounts Spain (EUR)"
Move to business partner tab
You will notice that there is no data and this is wrong

Expected behaviour: You should see two business partners:
1. Customer Spain with volume discount
2. Vendor Spain with volume discount
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-08-08 12:14psarobeNew Issue
2011-08-08 12:14psarobeAssigned To => iperdomo
2011-08-08 12:14psarobeModules => Core
2011-08-08 12:14psarobeOBNetwork customer => No
2011-08-08 12:15psarobeStatusnew => scheduled
2011-08-08 16:59hgbotCheckin
2011-08-08 16:59hgbotNote Added: 0040008
2011-08-08 16:59hgbotStatusscheduled => resolved
2011-08-08 16:59hgbotResolutionopen => fixed
2011-08-08 16:59hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d3b9b3c463db6025cacc34bc43eb0f7592e512c6 [^]
2011-08-11 09:44psarobeNote Added: 0040107
2011-08-11 09:44psarobeStatusresolved => closed
2011-08-11 09:44psarobeFixed in Version => 3.0MP2
2011-08-16 13:21hgbotCheckin
2011-08-16 13:21hgbotNote Added: 0040176
2011-08-16 13:21hgbotStatusclosed => resolved
2011-08-16 13:21hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/d3b9b3c463db6025cacc34bc43eb0f7592e512c6 [^] => http://code.openbravo.com/erp/devel/pi/rev/dac14a3fa4cbfadd42db03d32d0f2cc43a99b99d [^]
2011-08-16 13:23hudsonbotCheckin
2011-08-16 13:23hudsonbotNote Added: 0040191
2011-09-01 16:34iperdomoNote Added: 0040682
2011-09-01 16:34iperdomoStatusresolved => closed

Notes
(0040008)
hgbot   
2011-08-08 16:59   
Repository: erp/devel/pi
Changeset: d3b9b3c463db6025cacc34bc43eb0f7592e512c6
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Mon Aug 08 16:58:49 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d3b9b3c463db6025cacc34bc43eb0f7592e512c6 [^]

Fixes issue 18223: The filter by the parent id is automatically added. HQL not required.
The hql where clause is not needed in this case. But if you remove it, the
compilation process will mark this Window to be shown in classic mode. Added a
dummy hql where 1=1 clause to avoid the problem.

---
M src-db/database/sourcedata/AD_TAB.xml
---
(0040107)
psarobe   
2011-08-11 09:44   
Works fine
(0040176)
hgbot   
2011-08-16 13:21   
Repository: erp/devel/pi
Changeset: dac14a3fa4cbfadd42db03d32d0f2cc43a99b99d
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Mon Aug 08 16:58:49 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/dac14a3fa4cbfadd42db03d32d0f2cc43a99b99d [^]

Fixes issue 18223: The filter by the parent id is automatically added. HQL not required.
The hql where clause is not needed in this case. But if you remove it, the
compilation process will mark this Window to be shown in classic mode. Added a
dummy hql where 1=1 clause to avoid the problem.

---
M src-db/database/sourcedata/AD_TAB.xml
---
(0040191)
hudsonbot   
2011-08-16 13:23   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c1dc221b8cb3 [^]

Maturity status: Test
(0040682)
iperdomo   
2011-09-01 16:34   
Closed as the reporter (psarobe) forgot about it ;)