Hi im using sp query to retrieve the items and using projectproperty.Title to get the web name dynamically ,but I got empty value in this data table.

              q.ViewFields = "<FieldRef Name='Title'/>" + "<FieldRef Name='Modified'/>";
                    q.ViewFields += "<ProjectProperty Name=\"Title\" />";
                    q.ViewFields += "<ListProperty Name=\"Title\" />";

                   q.Query="<OrderBy><FieldRef Name='Modified' Ascending='FALSE'></FieldRef></OrderBy>";

                   q.Query = "<Where><Contains><FieldRef Name='ProjectProperty.Title' /><Value Type='Text'>Test1</Value></Contains></Where>";
  DataTable results = spWeb.GetSiteData(q);

if I removed projectproperty.title in my query its working fine.any suggestion.?


according to this thread you cannot filter based on projectproperty

I must add that I haven't tried it myself, though.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.