Thursday, February 3, 2011

SharePoint 2010: how to get SQL rows for a document in a library

Here's the snippet, just change the doc lib name and doc title.

select * from AllDocs d
join AllLists l
on d.ListId = d.ListId
and upper(l.tp_Title) = 'UPPERCASE DOC LIB NAME'
and upper(d.LeafName) = 'UPPERCASE DOC TITLE'
join AllUserData u
on u.tp_DocId = d.Id

No comments: