Index: grails-app/services/com/lemans/ds/qualitycontrol/PartReviewService.groovy =================================================================== diff -u -ree5afbf65eb74678c97e0233f9647cb139cd1b90 -rf8b53fa453ccada1eb7723f6c414e9e2eeccb18e --- grails-app/services/com/lemans/ds/qualitycontrol/PartReviewService.groovy (.../PartReviewService.groovy) (revision ee5afbf65eb74678c97e0233f9647cb139cd1b90) +++ grails-app/services/com/lemans/ds/qualitycontrol/PartReviewService.groovy (.../PartReviewService.groovy) (revision f8b53fa453ccada1eb7723f6c414e9e2eeccb18e) @@ -224,7 +224,7 @@ 'PA', 'R' ) WHERE - c.entityGroup = 'PartDetails' + c.entityGroup = 'Media' AND cl.entityId = :partNumber AND c.entityField = 'primaryMediaId' ''' @@ -262,9 +262,10 @@ qc.vwChangeLog cl WITH(NOLOCK) INNER JOIN qc.Config c WITH(NOLOCK) - ON cl.configId = c.configId + ON cl.configId = c.configId + AND c.entityGroup = 'Media' AND c.parentEntity = 'Part' - AND c.entity IN ('MediaEntity', 'Part') + AND c.entity = 'MediaEntity' AND cl.parentEntityId = :partNumber AND c.entityGroup = 'Media' INNER JOIN