ARB Security Solutions » Building SharePoint View Queries with CAML

Latest Free SharePoint Software

ARB Security Solutions regularly releases free SharePoint software, including WebParts, Client Applications, Framework Extensions, and other Miscellaneous Components.
The most recent freeware is:

Title: Simple SharePoint Rollup WebPart
Date Published: 10/22/2009

Previous Two Free WebPart Releases:

SharePoint Security Assurance Program™

For externally facing SharePoint deployments, security is an acutely important deployment concern. Learn how through daily security scanning, you can ensure external business users and partners that they can collaborate in confidence!

Security Assurance WebPart:

Start Audit Process With The SharePoint Security Assurance Program™

Building SharePoint View Queries with CAML

Often times when building applications that will greatly use SharePoint views for data rotation it is helpful to build CAML builders into separate static classes that return a continuous string representation of the arbitrary query. In order to demonstrate this, consider the following examples BuildDefaultViewQuery, BuildPrivateViewQuery, and BuildPublicViewQuery:

PLAIN TEXT

C#:

private static string BuildDefaultViewQuery()
{
var builder = new StringBuilder();
builder.Append("<Where>");
builder.Append("<Eq><FieldRef Name='DefaultView' /><Value Type='Boolean'>");
builder.Append("1");
builder.Append("</Value></Eq></Where>");
return builder.ToString();
}
private static string BuildPrivateViewQuery(string user)
{
var builder = new StringBuilder();
builder.Append("<OrderBy><FieldRef Name='ViewName'/> </OrderBy>");
builder.Append("<Where><Eq><FieldRef Name='ViewCreator' /><Value Type='Text'>");
builder.Append(user);
builder.Append("</Value></Eq></Where>");
return builder.ToString();
}
private static string BuildPublicViewQuery(string user)
{
var builder = new StringBuilder();
builder.Append("<OrderBy><FieldRef Name='Audience'/> <FieldRef Name='ViewName'/></OrderBy>");
builder.Append("<Where><Or><Eq><FieldRef Name='ViewCreator' /><Value Type='Text'>");
builder.Append(user);
builder.Append("</Value></Eq>");
builder.Append("<Eq><FieldRef Name='Audience' /><Value Type='Choice'>");
builder.Append("1");
builder.Append("</Value></Eq></Or></Where>");
return builder.ToString();
}

It should be noted that there are some constants that could instead be extracted to an enumeration and then Enum.GetName could be used for better component allocation. However, in this example since it is merely to show the overlying constructs, is kept purposefully plain.

In order to use one of static CAML methods, the ReturnCollectionExample method will take some basic parameters, than return the item collection associated with the BuildPrivateViewQuery query.

PLAIN TEXT

C#:

private static SPListItemCollection (string url, string viewName, string userId)
{
using (var site = new SPSite(url))
{
using (SPWeb web = site.OpenWeb())
{
var query = new SPQuery { Query = BuildPrivateViewQuery(userId) };
return web.Lists[viewName].GetItems(query);
}
}
}

Article Or Research Filed Under SharePoint Development.

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Articles & Research

Latest Free SharePoint Software

SecureCenter For SharePoint

SharePoint Security Assurance Program™

Free Online SharePoint Security Tools

Building SharePoint View Queries with CAML

No Comments »

Leave a comment