Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0002106 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 09. Financial management | minor | always | 2007-10-17 13:11 | 2008-06-12 09:43 | |||
Reporter | cromero | View Status | public | |||||
Assigned To | cromero | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | 2.35 | |||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0002106: Payment Report doesn't return anything in postgre | |||||||
Description | 2.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. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
|
![]() |
|
(0002411) cromero (viewer) 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 (viewer) 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 [^] |
Copyright © 2000 - 2009 MantisBT Group |