Author: jleroux
Date: Tue Jul 29 06:59:56 2008
New Revision: 680698
URL: http://svn.apache.org/viewvc?rev=680698&view=rev
Log:
Fix a bug : when searching Facility Inventory Items (menu Inventory) and using
a date in "Show Products Sold Thru" it was working with Derby but not Postgres
(at least 8.3 as I tested only this version).
Modified:
ofbiz/trunk/applications/product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.groovy
Modified:
ofbiz/trunk/applications/product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.groovy
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.groovy?rev=680698&r1=680697&r2=680698&view=diff
==============================================================================
---
ofbiz/trunk/applications/product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.groovy
(original)
+++
ofbiz/trunk/applications/product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.groovy
Tue Jul 29 06:59:56 2008
@@ -104,7 +104,8 @@
discontinuationDateCondition = EntityCondition.makeCondition(
[
EntityCondition.makeCondition("salesDiscontinuationDate",
EntityOperator.EQUALS, null),
- EntityCondition.makeCondition("salesDiscontinuationDate",
EntityOperator.GREATER_THAN, productsSoldThruTimestamp)
+ EntityCondition.makeCondition("salesDiscontinuationDate",
EntityOperator.GREATER_THAN,
+
ObjectType.simpleTypeConvert(productsSoldThruTimestamp, "Timestamp", null,
null, false))
],
EntityOperator.OR);
whereConditionsList.add(discontinuationDateCondition);
