Changeset 564 for trunk/grails-app


Ignore:
Timestamp:
Jun 2, 2010, 10:11:48 PM (14 years ago)
Author:
gav
Message:

Adjust InventoryReportService getStockTakeByLocation() for MSSQL.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/grails-app/services/InventoryReportService.groovy

    r550 r564  
    152152                                        order by inventoryStore.name, inventoryLocation.name"
    153153
    154         result.query = "select  distinct inventoryItem " + result.query
     154        // MSSQL will not do distinct here, for some reason it tries to compare the image data type!
     155        result.query = "select inventoryItem " + result.query
    155156        result.inventoryItemList = InventoryItem.executeQuery(result.query, namedParams, paginateParams)
     157
     158        result.inventoryItemList.unique()
    156159
    157160        // Success.
Note: See TracChangeset for help on using the changeset viewer.