Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009946Openbravo ERPY. DBSourceManagerpublic2009-07-17 17:472009-07-29 00:00
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP3 
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
Summary0009946: Several reports depend on SubCategoryProducts_data.xsql which makes customization of these hard
DescriptionSeveral report depends on this file to get a list of product categories. This can be changed by using the standard ComboTableData class.
Steps To Reproduce
Proposed Solution
Additional Information
Tags250MP3releasecandidate
Relationships
related to defect 0009932 closed shuehner Several reports depend ReportTrialBalance_data.xsql which makes customizations harder 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-17 17:47shuehnerNew Issue
2009-07-17 17:47shuehnerAssigned To => shuehner
2009-07-17 17:51shuehnerRelationship addedrelated to 0009932
2009-07-17 17:51hgbotCheckin
2009-07-17 17:51hgbotNote Added: 0018384
2009-07-17 17:51hgbotStatusnew => resolved
2009-07-17 17:51hgbotResolutionopen => fixed
2009-07-17 17:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/13a54b6a0cc89e83dd37f718df9ce7a8f2ee8064 [^]
2009-07-17 17:55shuehnerNote Added: 0018385
2009-07-21 16:24psarobeFixed in Version => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-28 12:08psarobeStatusresolved => closed
2009-07-29 00:00anonymoussf_bug_id0 => 2828658

Notes
(0018384)
hgbot   
2009-07-17 17:51   
Repository: erp/devel/pi
Changeset: 13a54b6a0cc89e83dd37f718df9ce7a8f2ee8064
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Jul 17 17:50:56 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/13a54b6a0cc89e83dd37f718df9ce7a8f2ee8064 [^]

Fixed 9946: Remove dependency on SubCategoryProduct_data.xsql from several reports, remove the whole xsql file as its unused after this change
- Convert the users to use ComboTableData
- Remove the then unused, non-public xsql file

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerEdition.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSite.java
M src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderJR.java
R src/org/openbravo/erpCommon/ad_reports/SubCategoryProduct_data.xsql
---
(0018385)
shuehner   
2009-07-17 17:55   
@qa: testing

Rendering of the product category dropdown list and if the filtering of the rerpots' output by this dropdown works in the following reportS:

- ReportProjectBuildingSite: Service Project Report
- ReportSalesOrderJR: Sales Order Report
- ReportinvoiceCustomerJR: Customer Invoice Report

The following changed reports are not active by default


- ReportProjectBuildingSite
- ReportInvoiceCustomerEdition