select r.containerId, r.containerType, r.srcURL, r.fileId, r.ownerId, r.ownerType, r.uploadDate, c.createDate, 'https://doclibrary.com/' + c.mainFolder + '/' + c.subFolder + '/' + c.fileName contentURL, c.contentId
from tbl_WRK_Repository r
inner join tbl_FSC_Content c
on c.contentId = r.contentId
where left( srcURL, 4 ) = 'http'
and ( srcURL like '%doclibrary%'
or srcURL like '%salesteamportal%' )
and r.uploadDate >= '08/01/2021'
-- and r.containerType = 'TSK' and r.containerId = 162666
-- and r.containerType = 'EML' and r.containerId = 4168493
order by uploadDate
Write #arrayLen( _source )# bytes to #htmleditformat( contentPath )#
Copy #arrayLen( _source )# bytes (#htmleditformat( _sourceFile )#) to #htmleditformat( contentPath )#
Bad Source
Applied
NOT Applied
select * from qmd_toFix where fix is not null