Index: grails-app/services/com/lemans/ds/brand/BrandService.groovy =================================================================== diff -u -r759279bf7c0c9e728a6e136fea18ce0795e4fa53 -r6f64a5026eb0b18f11a8cb76e78af145996776b5 --- grails-app/services/com/lemans/ds/brand/BrandService.groovy (.../BrandService.groovy) (revision 759279bf7c0c9e728a6e136fea18ce0795e4fa53) +++ grails-app/services/com/lemans/ds/brand/BrandService.groovy (.../BrandService.groovy) (revision 6f64a5026eb0b18f11a8cb76e78af145996776b5) @@ -6,7 +6,7 @@ @Transactional(readOnly = true) class BrandService extends LemansService { - private static final String BRAND_SELECT = 'SELECT x.brandId, x.brandCode, RTRIM(x.brandName) AS brandName' + private static final String BRAND_SELECT = 'SELECT x.brandId, x.brandCode, RTRIM(x.brandName) AS brandName, x.houseBrand' /** * Searches for Brands supporting * wildcards. *