Index: src/main/groovy/com/lemans/pricecalc/Mapper.groovy =================================================================== diff -u -rd6a6788d307162218552b63a450abd5c72c3e721 -r8621546d2153cd375c0802a11ca16ca1fbfca787 --- src/main/groovy/com/lemans/pricecalc/Mapper.groovy (.../Mapper.groovy) (revision d6a6788d307162218552b63a450abd5c72c3e721) +++ src/main/groovy/com/lemans/pricecalc/Mapper.groovy (.../Mapper.groovy) (revision 8621546d2153cd375c0802a11ca16ca1fbfca787) @@ -43,7 +43,7 @@ switch (filterName) { case 'brandId': joins << 'INNER JOIN [PartsSource_DS].dbo.Brand b WITH(NOLOCK) ON b.brandId = vp.brandId AND b.dateDeleted IS NULL' - select = "[filter] = 'brand', id = b.brandId, code = b.brandCode, descr = b.brandName" + select = "[filter] = 'brand', id = b.brandId, code = b.brandCode, descr = b.brandName, houseBrand = b.houseBrand" break case 'subComCodeId': joins << 'INNER JOIN [PartsSource_DS].dbo.SubComCode scc WITH(NOLOCK) ON scc.subComCodeId = vp.subComCodeId' Index: src/main/groovy/com/lemans/pricecalc/services/catalog/CatalogPartService.groovy =================================================================== diff -u -rc8916200dfda2e501b67f76eba3372c9469cfde2 -r8621546d2153cd375c0802a11ca16ca1fbfca787 --- src/main/groovy/com/lemans/pricecalc/services/catalog/CatalogPartService.groovy (.../CatalogPartService.groovy) (revision c8916200dfda2e501b67f76eba3372c9469cfde2) +++ src/main/groovy/com/lemans/pricecalc/services/catalog/CatalogPartService.groovy (.../CatalogPartService.groovy) (revision 8621546d2153cd375c0802a11ca16ca1fbfca787) @@ -40,6 +40,7 @@ vp.brandId, b.brandName, b.brandCode, + b.houseBrand, vp.partDescr, vp.punctuatedPartNumber, vp.vendorPunctuatedPartNumber, @@ -230,7 +231,7 @@ switch (filterName) { case 'brandId': //joins << 'INNER JOIN [PartsSource_DS].dbo.Brand b WITH(NOLOCK) ON b.brandId = vp.brandId AND b.dateDeleted IS NULL' - select = "[filter] = 'brand', id = b.brandId, code = b.brandCode, descr = b.brandName" + select = "[filter] = 'brand', id = b.brandId, code = b.brandCode, descr = b.brandName, houseBrand=b.houseBrand" break case 'catalogId': // joins << 'INNER JOIN dbo.vwCatalog c WITH(NOLOCK) ON c.catalogId = cp.catalogId'