OAT » TA Jueces

Script para modificar el location de documentos existentes

UPDATE fdd 
SET fdd.url = 
	CASE
		WHEN rft.filingTypeCode IN (41, 80, 81, 813) AND fdd.url LIKE '%/Principal/%'
			THEN REPLACE(fdd.url, '/Principal/', '/Resolution/')
		WHEN rft.filingTypeCode = 42 AND fdd.url LIKE '%/Principal/%'
			THEN REPLACE(fdd.url, '/Principal/', '/Sentences/')
		WHEN rft.filingTypeCode IN (41, 80, 81, 813) AND fdd.url LIKE '%\Principal\%'
			THEN REPLACE(fdd.url, '\Principal\', '\Resolution\')
		WHEN rft.filingTypeCode = 42 AND fdd.url LIKE '%\Principal\%'
			THEN REPLACE(fdd.url, '\Principal\', '\Sentences\')
		ELSE fdd.url
	END
FROM filingDocumentDetails fdd
INNER JOIN filingDocuments fd WITH (NOLOCK)
	ON fd.filingDocumentId = fdd.filingDocumentId 
	AND fd.isDeleted = 0
INNER JOIN recourseFilings rf WITH (NOLOCK)
	ON rf.recourseFilingId = fd.recourseFilingId 
	AND rf.isDeleted = 0
INNER JOIN recourseFilingDetails rfd WITH (NOLOCK)
	ON rfd.recourseFilingId = rf.recourseFilingId 
	AND rfd.isDeleted = 0
INNER JOIN recourseFilingTypes rft WITH (NOLOCK)
	ON rft.recourseFilingId = rf.recourseFilingId 
	AND rft.filingTypeCode IN (41, 80, 81, 813, 42)
	AND rft.isDeleted = 0
WHERE fdd.url LIKE '%\Principal\%' OR fdd.url LIKE '%/Principal/%'
AND fdd.isDeleted = 0