OAT » TA Admin

hay q correr este query para corregir los viejos

UPDATE SUMACRecord
SET ObjectTypeCode = 327
WHERE RecordId IN (
	SELECT RecordId
	FROM SUMACCaseBase cb
	INNER JOIN SUMACCaseLegalBasis clb ON clb.CaseId = cb.CaseId
	INNER JOIN SUMACLegalBasis lb ON lb.Code = clb.LegalBasisCode AND lb.LegalBasisTypeCode = 37
	INNER JOIN SUMACRecourseCaseArchive rca ON rca.CaseId = cb.CaseId
	WHERE cb.IsHidden = 0
)

UPDATE SUMACRecord
SET ObjectTypeCode = 96
WHERE RecordId IN (
	SELECT RecordId
	FROM SUMACCaseBase cb
	INNER JOIN SUMACCaseLegalBasis clb ON clb.CaseId = cb.CaseId
	INNER JOIN SUMACLegalBasis lb ON lb.Code = clb.LegalBasisCode AND lb.LegalBasisTypeCode IN (2, 3)
	INNER JOIN SUMACRecourseCaseArchive rca ON rca.CaseId = cb.CaseId
)