Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002106Openbravo ERP09. Financial managementpublic2007-10-17 13:112008-06-12 09:43
Reportercromero 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.35 
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
Summary0002106: 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.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(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 [^]
(0002411)
cromero   
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   
2007-10-31 12:23   
(edited on: 2008-06-12 09:22)
Logged In: YES
user_id=1892190
Originator: NO

Verification assigned to rafaroda.