Changeset 564 for trunk/grails-app/services/InventoryReportService.groovy

Timestamp:

Jun 2, 2010, 10:11:48 PM (14 years ago)

Author:

gav

Message:

Adjust InventoryReportService getStockTakeByLocation() for MSSQL.

File:

• trunk/grails-app/services/InventoryReportService.groovy (modified) (1 diff)

trunk/grails-app/services/InventoryReportService.groovy

@@ -152 +152 @@
                                         order by inventoryStore.name, inventoryLocation.name"
 
-        result.query = "select  distinct inventoryItem " + result.query
+        // MSSQL will not do distinct here, for some reason it tries to compare the image data type!
+        result.query = "select inventoryItem " + result.query
         result.inventoryItemList = InventoryItem.executeQuery(result.query, namedParams, paginateParams)
+
+        result.inventoryItemList.unique()
 
         // Success.