Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006745Openbravo ERP09. Financial managementpublic2008-12-28 11:412009-03-03 17:16
Reportershuehner 
Assigned ToHennadzi 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
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
Summary0006745: 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.
Additional Information
Tagscomsup_sprint3
Relationships
blocks defect 0006714 closed Hennadzi General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 (again) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-28 11:41rafarodaNew Issue
2008-12-28 11:41rafarodaAssigned To => Hennadzi
2008-12-28 11:41rafarodaStatusnew => scheduled
2008-12-30 14:27svnbotCheckin
2008-12-30 14:27svnbotNote Added: 0011769
2008-12-30 14:27svnbotStatusscheduled => resolved
2008-12-30 14:27svnbotResolutionopen => fixed
2008-12-30 14:27svnbotsvn_revision => 11613
2008-12-30 14:27HennadziTag Attached: comsup_sprint3
2009-03-03 17:16psarobeStatusresolved => closed

Notes
(0011769)
svnbot   
2008-12-30 14:27   
Repository: openbravo
Revision: 11613
Author: hennadzi
Date: 2008-12-30 14:27:24 +0100 (Tue, 30 Dec 2008)

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

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---

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