{"id":1050,"date":"2010-09-26T01:55:07","date_gmt":"2010-09-26T06:55:07","guid":{"rendered":"http:\/\/blogs.devhorizon.com\/reza\/?p=1050"},"modified":"2010-09-26T09:35:49","modified_gmt":"2010-09-26T14:35:49","slug":"querying-document-sets-using-spsitedataquery","status":"publish","type":"post","link":"https:\/\/blogs.devhorizon.com\/reza\/2010\/09\/26\/querying-document-sets-using-spsitedataquery\/","title":{"rendered":"Querying Document Sets Using SPSiteDataQuery"},"content":{"rendered":"

In SharePoint 2010, a document set is just what it is shouting at us- a bundle of documents! Agnes (SharePoint MVP) has a nice and short post here <\/a>about how to setup document sets. If you activate a site collection scoped feature called\u00a0 “Document ID Service”,\u00a0 document sets, like any other document in a site collection, are assigned a unique ID (i.e. “DHSD-5-14”) which can be used to retrieve them\u00a0 independent of their location in the site collection. An awesome feature of SP2010!<\/p>\n

A pretty common integration scenario is when a BizTalk orchestration (or CRM Workflow) needs to pass a document set id to your WCF service (installed in ISAPI folder in the WFE) and your service needs to return the document library URL based on that document set id. This way BizTalk can upload multiple documents to that document set. Let’s assume that the document library and the document set are already created and BizTalk is aware of them.<\/p>\n

How would you go about this?<\/p>\n

I haven’t found an easy way to do this through SharePoint object model .Obviously, one inefficient way to do this is to loop through all the document libraries and find the document set , like below:<\/p>\n

[CSharp]
\nusing (SPSite site = new SPSite(“http:\/\/foo”))
\n{
\n using (SPWeb web = site.OpenWeb())
\n {<\/p>\n

\/\/Bad Code
\n foreach (SPList list in web.Lists) {
\n if (list.ContentTypesEnabled)
\n {
\n SPContentType spCtype = list.ContentTypes[“Document Set”];
\n foreach (SPListItem item in list.Items)
\n {
\n if (item[“Document ID”].ToString().Contains(“DHSD-5-14”))
\n string url = string.Format(“{0}\/{1}”, list.ParentWeb.Url, list.Title);
\n }
\n }
\n } \/\/End of SPWeb using
\n}\/\/End of SPSite using
\n[\/CSharp]<\/p>\n

As you can see, when you activate Document ID Service, each document set (they are SPListIItem at the end of the day, right?), gets a new column called “Document ID” which by examining the SPListItem[“Document ID”], I am finding the one that I am looking for.<\/p>\n

Another (and better) way is to use the SPSiteDataQuery to query the entire SPWeb (and all the child subsites) for that document set.<\/p>\n

[CSharp]<\/p>\n

using (SPSite site = new SPSite(“http:\/\/foo”)) )
\n{
\n using (SPWeb web = site.OpenWeb())
\n {
\n\tSPSiteDataQuery query = new SPSiteDataQuery();
\n\tquery.Webs = ““;
\n\tquery.Lists = ““;
\n\tquery.Query = ““;
\n\tquery.Query += “Document Set<\/Value><\/Eq>“;
\n\tquery.Query += “” + “DHSD-5-14” + “<\/Value><\/Eq>“;
\n\tquery.Query += “<\/And><\/Where>“;
\n\tDataTable dt = web.GetSiteData(query);
\n\tDataView dv = new DataView(dt);
\n\tif (dt.Rows.Count == 0) { \/\/ No donuts! }
\n\tDataRow dr = dt.Rows[0]; \/\/There is always one row, if any!
\n\tGuid listId = new Guid(Convert.ToString(dr[“ListID”]));
\n\tSPList targetDocLib = web.Lists[listId];
\n\tstring url = string.Format(“{0}\/{1}”, targetDocLib.ParentWeb.Url, targetDocLib.Title);
\n } \/\/End of SPWeb using
\n} \/\/End of SPSite using<\/p>\n

[\/CSharp]<\/p>\n

If you have worked with SPSiteDataQuery before, most likely you are aware that it’s a bad ass API. A simple lowercase or or spelling mistake either results in errors or(even worse) returning no result. In my case I had issues querying document sets.<\/p>\n

As you can tell, I am not passing any ViewFields<\/strong> to the SPSiteDataQuery.\u00a0 These are not required as ListID<\/strong>, as well as WebID and SPListItem ID, are returned by default. You will also notice that I haven’t looped through all of the returned data rows, since if my query returns any result, there should be only one document set with the id of\u00a0 “DHSD-5-14”.<\/p>\n

The most important thing, thought, is the use of\u00a0 _dlc_DocId <\/strong>in the query which is being referenced in the where clause of my CAML query. This is the static name for the Document ID column and\u00a0 took me a little while to figure it ou. Thankfully, using the SPSiteDataQuery class, I was able to quickly find my document set and extract the URL of its parent document library.<\/p>\n","protected":false},"excerpt":{"rendered":"

In SharePoint 2010, a document set is just what it is shouting at us- a bundle of documents! Agnes (SharePoint MVP) has a nice and short post here about how to setup document sets. If you activate a site collection scoped feature called\u00a0 “Document ID Service”,\u00a0 document sets, like any other document in a site […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-1050","post","type-post","status-publish","format-standard","hentry","category-sharepoint-2010"],"yoast_head":"\nQuerying Document Sets Using SPSiteDataQuery - Reza Alirezaei's Blog %<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blogs.devhorizon.com\/reza\/2010\/09\/26\/querying-document-sets-using-spsitedataquery\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Reza Alirezaei\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2010\\\/09\\\/26\\\/querying-document-sets-using-spsitedataquery\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2010\\\/09\\\/26\\\/querying-document-sets-using-spsitedataquery\\\/\"},\"author\":{\"name\":\"Reza Alirezaei\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"headline\":\"Querying Document Sets Using SPSiteDataQuery\",\"datePublished\":\"2010-09-26T06:55:07+00:00\",\"dateModified\":\"2010-09-26T14:35:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2010\\\/09\\\/26\\\/querying-document-sets-using-spsitedataquery\\\/\"},\"wordCount\":612,\"commentCount\":2,\"articleSection\":[\"SharePoint 2010\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2010\\\/09\\\/26\\\/querying-document-sets-using-spsitedataquery\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2010\\\/09\\\/26\\\/querying-document-sets-using-spsitedataquery\\\/\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2010\\\/09\\\/26\\\/querying-document-sets-using-spsitedataquery\\\/\",\"name\":\"Querying Document Sets Using SPSiteDataQuery - Reza Alirezaei's Blog %\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\"},\"datePublished\":\"2010-09-26T06:55:07+00:00\",\"dateModified\":\"2010-09-26T14:35:49+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2010\\\/09\\\/26\\\/querying-document-sets-using-spsitedataquery\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/\",\"name\":\"Reza Alirezaei's Blog\",\"description\":\"Blogging from the field!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\",\"name\":\"Reza Alirezaei\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"caption\":\"Reza Alirezaei\"},\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/author\\\/rezaa\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Querying Document Sets Using SPSiteDataQuery - Reza Alirezaei's Blog %","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blogs.devhorizon.com\/reza\/2010\/09\/26\/querying-document-sets-using-spsitedataquery\/","twitter_misc":{"Written by":"Reza Alirezaei","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blogs.devhorizon.com\/reza\/2010\/09\/26\/querying-document-sets-using-spsitedataquery\/#article","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2010\/09\/26\/querying-document-sets-using-spsitedataquery\/"},"author":{"name":"Reza Alirezaei","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"headline":"Querying Document Sets Using SPSiteDataQuery","datePublished":"2010-09-26T06:55:07+00:00","dateModified":"2010-09-26T14:35:49+00:00","mainEntityOfPage":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2010\/09\/26\/querying-document-sets-using-spsitedataquery\/"},"wordCount":612,"commentCount":2,"articleSection":["SharePoint 2010"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blogs.devhorizon.com\/reza\/2010\/09\/26\/querying-document-sets-using-spsitedataquery\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blogs.devhorizon.com\/reza\/2010\/09\/26\/querying-document-sets-using-spsitedataquery\/","url":"https:\/\/blogs.devhorizon.com\/reza\/2010\/09\/26\/querying-document-sets-using-spsitedataquery\/","name":"Querying Document Sets Using SPSiteDataQuery - Reza Alirezaei's Blog %","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#website"},"datePublished":"2010-09-26T06:55:07+00:00","dateModified":"2010-09-26T14:35:49+00:00","author":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.devhorizon.com\/reza\/2010\/09\/26\/querying-document-sets-using-spsitedataquery\/"]}]},{"@type":"WebSite","@id":"https:\/\/blogs.devhorizon.com\/reza\/#website","url":"https:\/\/blogs.devhorizon.com\/reza\/","name":"Reza Alirezaei's Blog","description":"Blogging from the field!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.devhorizon.com\/reza\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938","name":"Reza Alirezaei","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","caption":"Reza Alirezaei"},"url":"https:\/\/blogs.devhorizon.com\/reza\/author\/rezaa\/"}]}},"_links":{"self":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/comments?post=1050"}],"version-history":[{"count":0,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1050\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/media?parent=1050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/categories?post=1050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/tags?post=1050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}