SharePoint CAML Query小结

1. CAML的结构。

<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>

 

可以在这个页面查看更详细的内容：

https://msdn.microsoft.com/en-us/library/office/ms438338.aspx

在这个页面上可以通过点击Parent Elements和Child Elements查看它可以包含的子元素和父元素。

 

1. 如何通过CAML查询一个View里面的数据。

服务器端的API支持输入View的ID:

https://msdn.microsoft.com/en-us/library/ms434064(v=office.15).aspx

 

客户端的API则不支持：

https://msdn.microsoft.com/en-us/library/office/microsoft.sharepoint.client.list.getitems.aspx

需要用如下的方法进行查询：

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");