svn commit: r680698 - /ofbiz/trunk/applications/product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.groovy

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);