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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0006714
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorhave not tried2008-12-22 13:402008-12-31 15:39
ReportershuehnerView Statuspublic 
Assigned ToHennadzi 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision11612
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version8.3Ant 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

0006714: General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 (again)

DescriptionThe fix for issue 6493 in revision r11423 did break the filter field "From Amount" again on postgresql 8.3 when the two new xsql-functions which are introduced in this commit are used (selectTree, selectTreeHiding) because these two methods are missing the TO_NUMBER call for the paramAmtFrom parameter.

The original report was fixed in issue 6660 r11393.
Steps To ReproduceUse the General Ledger Report on pgsql 8.3
Use the Amount From filter
use the other parameters to execute a codepath where the methods selectTree and selectTreeHiding are executed
Proposed SolutionAdd the missing TO_NUMBER calls and text the two affected codepaths.
Tagscomsup_sprint3, multi-org
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0006660 closedshuehner General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 
related to defect 0006493 closeddalsasua General ledger report does not work in 2.40mp1 
depends on backport 0006745 closedHennadzi General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 (again) 

-  Notes
(0011653)
shuehner (administrator)
2008-12-22 13:41

This should be backported to r2.40 as 6660 did fix the problem on r2.40 and this issue opens up the problem again.
(0011768)
svnbot (reporter)
2008-12-30 14:03

Repository: openbravo
Revision: 11612
Author: hennadzi
Date: 2008-12-30 14:03:30 +0100 (Tue, 30 Dec 2008)

Fixed bug 0006714: General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 (again)

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11612&sc=1 [^]
(0011807)
lakshmi (reporter)
2008-12-31 15:39

Verified the issue and it works in Openbravo 2.50 (r11619). So i closed this issue

- Issue History
Date Modified Username Field Change
2008-12-22 13:40 shuehner New Issue
2008-12-22 13:40 shuehner Assigned To => rafaroda
2008-12-22 13:40 shuehner sf_bug_id 0 => 2458464
2008-12-22 13:40 shuehner Regression testing => No
2008-12-22 13:41 shuehner Note Added: 0011653
2008-12-22 14:36 shuehner Relationship added related to 0006660
2008-12-22 14:36 shuehner Relationship added related to 0006493
2008-12-22 14:42 shuehner Assigned To rafaroda => dalsasua
2008-12-28 11:41 rafaroda Status new => scheduled
2008-12-28 11:41 rafaroda Assigned To dalsasua => Hennadzi
2008-12-28 11:41 rafaroda fix_in_branch => trunk
2008-12-30 14:03 svnbot Checkin
2008-12-30 14:03 svnbot Note Added: 0011768
2008-12-30 14:03 svnbot Status scheduled => resolved
2008-12-30 14:03 svnbot Resolution open => fixed
2008-12-30 14:03 svnbot svn_revision => 11612
2008-12-30 14:04 Hennadzi Tag Attached: comsup_sprint3
2008-12-30 14:04 Hennadzi Tag Attached: multi-org
2008-12-31 15:39 lakshmi Status resolved => closed
2008-12-31 15:39 lakshmi Note Added: 0011807


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker