Friday, August 5, 2011

retrouver une webpart par son guid

USE
SELECT DISTINCT W.FullURL as WebURL, D.DirName,
D.LeafName, tp_ID As WebPartSK ,WP.tp_WebPartTypeId
FROM dbo.Docs D WITH (nolock)
INNER JOIN dbo.Webs W WITH (nolock) ON D.WebID = W.Id
INNER JOIN dbo.WebParts WP WITH (nolock) ON D.Id = WP.tp_PageUrlID
WHERE WP.tp_WebPartTypeId = (GUID)

No comments: