SharePoint CAML Query小结

<View Type=”HTML” Name=”Summary”>

<ViewBody ExpandXML=”TRUE”>

<![CDATA[ <p><SPAN class=DocTitle><ows:Field Name=”Title”/></SPAN>

(<ows:Field Name=”Author”/>, <ows:Field Name=”Modified”/>)

<ows:Limit><Field Name=”Body”/></ows:Limit>

</p> ]]>

</ViewBody>

<Query>

<Where>

<Geq>

<FieldRef Name=”Expires”/>

<Value Type=”DateTime”>

<Today/>

</Value>

</Geq>

</Where>

<OrderBy>

<FieldRef Name=”Modified”/>

</OrderBy>

</Query>

<ViewFields>

<FieldRef Name=”Summary”/>

<FieldRef Name=”Author”/>

<FieldRef Name=”Modified”/>

<FieldRef Name=”Body”/>

</ViewFields>

</View>

Public
ListItemCollection
GetSPItems(listName, viewName){

ClientContext context = new
ClientContext("http://SiteUrl");

List list1 = context.Web.Lists.GetByTitle(listName);

View view = list1.Views.GetByTitle(viewName);

clientContext.Load(view);

clientContext.ExecuteQuery();

CamlQuery query = new
CamlQuery();

camlQuery.ViewXml = view.ViewQuery;

ListItemCollection items = announcementsList.GetItems(query);

context.Load(items);

context.ExecuteQuery();

retun items;

}

//Example of usage:

ListItemCollection listItems = GetSPItems("Tasks", "My Tasks");