Index: src/main/groovy/com/lemans/pricecalc/Mapper.groovy =================================================================== diff -u -r8621546d2153cd375c0802a11ca16ca1fbfca787 -rd82e472cb1f7500dca89dc766cd4bacb809861f8 --- src/main/groovy/com/lemans/pricecalc/Mapper.groovy (.../Mapper.groovy) (revision 8621546d2153cd375c0802a11ca16ca1fbfca787) +++ src/main/groovy/com/lemans/pricecalc/Mapper.groovy (.../Mapper.groovy) (revision d82e472cb1f7500dca89dc766cd4bacb809861f8) @@ -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, houseBrand = b.houseBrand" + select = "[filter] = 'brand', id = b.brandId, code = b.brandCode, descr = b.brandName, houseBrandFlag = b.houseBrandFlag" 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 -r8621546d2153cd375c0802a11ca16ca1fbfca787 -rd82e472cb1f7500dca89dc766cd4bacb809861f8 --- src/main/groovy/com/lemans/pricecalc/services/catalog/CatalogPartService.groovy (.../CatalogPartService.groovy) (revision 8621546d2153cd375c0802a11ca16ca1fbfca787) +++ src/main/groovy/com/lemans/pricecalc/services/catalog/CatalogPartService.groovy (.../CatalogPartService.groovy) (revision d82e472cb1f7500dca89dc766cd4bacb809861f8) @@ -40,7 +40,7 @@ vp.brandId, b.brandName, b.brandCode, - b.houseBrand, + b.houseBrandFlag, vp.partDescr, vp.punctuatedPartNumber, vp.vendorPunctuatedPartNumber, @@ -231,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, houseBrand=b.houseBrand" + select = "[filter] = 'brand', id = b.brandId, code = b.brandCode, descr = b.brandName, houseBrandFlag=b.houseBrandFlag" break case 'catalogId': // joins << 'INNER JOIN dbo.vwCatalog c WITH(NOLOCK) ON c.catalogId = cp.catalogId'