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
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment