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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0002106
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2007-10-17 13:112008-06-12 09:43
ReportercromeroView Statuspublic 
Assigned Tocromero 
PrioritynormalResolutionfixedFixed in Version2.35
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0002106: Payment Report doesn't return anything in postgre

Description2.33 running against Postgresql

When you specify dates in the Financial Management || Payment Report it never returns any data.

This is because the dates are passed in as strings as a parameter to the generated sql. My guess is that they are not converted to dates because the are specified as strings.

This works in Oracle version.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0002411)
cromero (reporter)
2007-10-17 13:12
edited on: 2008-06-12 09:22

Logged In: YES
user_id=1500614
Originator: YES

It is needed for postgre the explicit cast of the string in order to be able to compare with another date (Oracle makes an automatic cast).
This bug has been fixed and will be published with the next release (r2.35).

Thank you

Carlos Romero
Openbravo Team
(0002412)
rafaroda (developer)
2007-10-31 12:23
edited on: 2008-06-12 09:22

Logged In: YES
user_id=1892190
Originator: NO

Verification assigned to rafaroda.
(0005695)
user71
2005-06-01 00:00
edited on: 2008-06-12 09:43

This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1815056 [^]

- Issue History
Date Modified Username Field Change


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker