Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0006714

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 09. Financial management

major

have not tried

2008-12-22 13:40

2008-12-31 15:39

Reporter

shuehner

View Status

public

Assigned To

Hennadzi

Priority

normal

Resolution

fixed

Fixed in Version

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

PostgreSQL

Java version

OS Version

Database version

8.3

Ant version

Product Version

pi

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

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

Description

The 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 Reproduce

Use 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 Solution

Add the missing TO_NUMBER calls and text the two affected codepaths.

Tags

comsup_sprint3, multi-org

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0006660		closed	shuehner	General Ledger Report, Filter field: From Amount does not work on postgresql 8.3
related to	defect	0006493		closed	dalsasua	General ledger report does not work in 2.40mp1
depends on	backport	0006745		closed	Hennadzi	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