Index: grails-app/services/com/lemans/ds/warehouse/WarehouseService.groovy =================================================================== diff -u -r4b813bb6ac6aae701981f5b5061505314696f9ef -rb8a1ce5e6892ee076b1ae6517c8e97af8e1c1983 --- grails-app/services/com/lemans/ds/warehouse/WarehouseService.groovy (.../WarehouseService.groovy) (revision 4b813bb6ac6aae701981f5b5061505314696f9ef) +++ grails-app/services/com/lemans/ds/warehouse/WarehouseService.groovy (.../WarehouseService.groovy) (revision b8a1ce5e6892ee076b1ae6517c8e97af8e1c1983) @@ -7,7 +7,7 @@ class WarehouseService extends LemansService { Map findWarehouses() { - List output = sql().rows('SELECT warehouse, warehouseAbbr FROM dbo.Warehouse WHERE dateDeleted IS NULL AND isActive = 1') + List output = sql().rows('SELECT warehouse, warehouseAbbr FROM common.dbo.Warehouse WHERE dateDeleted IS NULL AND isActive = 1') output.add([warehouse: '00', warehouseAbbr: 'ANY']) [results: output] }