Find document in Sharepoint

Question

Looking for a way to find a document registered in Sharepoint. I can find document in a documet library or list by following code.

SPSite oSPSite = new SPSite(_serverUrl); SPWeb oSPWeb = oSPSite.OpenWeb(); SPList oSPList; SPListItemCollection oSPListItemCollection; oSPList = oSPWeb.Lists["Listname"]; SPListItem listItem = null; listItem = oSPList.GetItemByUniqueId(new Guid(spGuid));

But do i need to iterate trough all list if i dont know in which list the document is registered or is there a more efficient way.

Do you know the URL of the document?

Howard
– Howard

2012-01-17 10:44:10 +00:00
Commented Jan 17, 2012 at 10:44 — Howard
– Howard, Commented Jan 17, 2012 at 10:44

Stefan · Accepted Answer · 2012-01-17 11:05:15Z

If the UniqueId is the only information you have then you have to create a SPSiteDataQuery to retrieve the URL of the document:

SPWeb web = // ... SPSiteDataQuery q = new SPSiteDataQuery(); q.Query = String.Format( "<Where><Eq><FieldRef Name='UniqueId' /><Value Type='Lookup'>{0}</Value></Eq></Where>", spGuid); q.Lists = "<Lists BaseType="1" />"; // restrict to document libraries q.RowLimit = 1; // q.Webs = "<Webs Scope='SiteCollection' />"; add to broaden the search on the whole site collection q.ViewFields = "<FieldRef Name='EncodedAbsUrl' />"; DataTable tbl = web.GetSiteData(q); if (tbl.Rows.Count == 0) throw new FileNotFoundException(...); return tbl.Rows[0]["EncodedAbsUrl"];

Then you can load the SPFile (the document) with SPWeb.GetFile(string). If you just need the SPListItem you can access this via SPFile.Item.

JoJa · Accepted Answer · 2012-01-17 10:41:52Z

0

If you don't know in what list the document is placed you will need to iterate over the available SPList objects from the SPWeb.

answered Jan 17, 2012 at 10:41

JoJa

6105 silver badges8 bronze badges

3 Comments

klashagelqvist Over a year ago

Thanks for your answer. Think i found a solution. If i know guid of document i can do ....fileItem = oSPWeb.GetFile(new Guid(spGuid)); where spGuid is string guid

JoJa Over a year ago

Yeah, that would be a better solution if you have the guid :)

Maks Matsveyeu Over a year ago

you should have a look at this wonderful feature sharepointanalysthq.com/2010/04/document-id-feature office.microsoft.com/en-us/sharepoint-online-enterprise-help/…

Collectives™ on Stack Overflow

Find document in Sharepoint

2 Answers 2

Comments

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Related