CAML语法- Query写法
来源:互联网 发布:appstore安装不了软件 编辑:程序博客网 时间:2024/05/21 18:38
CAML语法- Query写法
CAML语法-Query写法
1.Geq(>=)greater than or equal to
The Geq element is an arithmetic operator that means "greater than or equal to." It can be used within a Where element in a view definition.
<Query>
<Where>
<Or>
<IsNull>
<FieldRef Name="Expires" />
</IsNull>
<Geq>
<FieldRef Name="Expires" />
<Value Type="DateTime">
<Today />
</Value>
</Geq>
</Or>
</Where>
<OrderBy>
<FieldRef Name="Modified" Ascending="FALSE" />
</OrderBy>
</Query>
此条语句表示的是返回 expires列为空或者 expires列的值(该列为datetime格式)大于今天的listItem,并按照modified列排序
2.Eq(=)equal to
The Eq element is an arithmetic operator that means "equal to" and is used within the Query element.
<Query>
<OrderBy>
<FieldRef Name="Modified" Ascending="FALSE"></FieldRef>
</OrderBy>
<Where>
<Or>
<Eq>
<FieldRef Name="Status"></FieldRef>
<Value Type="Text">Completed</Value>
</Eq>
<IsNull>
<FieldRef Name="Status"></FieldRef>
</IsNull>
</Or>
</Where>
</Query>
select * from list where status="completed" or status=="Null" order by modified;
3.Gt(>)"greater than
The Gt element is an arithmetic operator that means "greater than." This element is used similarly to Eq and Lt.
<Query>
<Where>
<Or>
<IsNull>
<FieldRef Name="Deadline" />
</IsNull>
<Gt>
<FieldRef Name="Deadline" />
<Value Type="DateTime">
<Today />
</Value>
</Gt>
</Or>
</Where>
<OrderBy>
<FieldRef Name="Modified" Ascending="FALSE" />
</OrderBy>
</Query>
select * from list where Deadline=DateTime.today() or DeadLine==null order by modified;
4.Lt(<)less than
The Lt element is an arithmetic operator that means "less than" and is used in queries in views. This element is used similarly to Eq and Gt.
<Query>
<Where>
<Or>
<IsNull>
<FieldRef Name="Deadline" />
</IsNull>
<Lt>
<FieldRef Name="Deadline" />
<Value Type="DateTime">
<Today />
</Value>
</Lt>
</Or>
</Where>
<OrderBy>
<FieldRef Name="Modified" Ascending="FALSE" />
</OrderBy>
</Query>
select * from olist where DeadLine==null or Deadline<DateTime.today() ordeyby modified;
5.Neq(!=)not equal to
The Neq element is an arithmetic operator that means "not equal to" and is used in queries.
<Query>
<OrderBy>
<FieldRef Name="Modified" Ascending="FALSE"></FieldRef>
</OrderBy>
<Where>
<Or>
<Neq>
<FieldRef Name="Status"></FieldRef>
<Value Type="Text">Completed</Value>
</Neq>
<IsNull>
<FieldRef Name="Status"></FieldRef>
</IsNull>
</Or>
</Where>
</Query>
select * from olist where Status!="Completed" or status==null;
协作应用程序标记语言 (CAML)---Query语法示例
1、Or,Lt,Gt,OrderBy
<Query>
<Where>
<Or>
<Lt>
<FieldRef Name="Stock"/>
<Value Type="Number">
15
</Value>
</Lt>
<Gt>
<FieldRef Name="Price"/>
<Value Type="Currency">
20.00
</Value>
</Gt>
</Or>
</Where>
<OrderBy>
<FieldRef Name="Title"/>
</OrderBy>
</Query>
select * from olist where stock<=15 or price>20 order by title
2、Eq
<Query>
<Where>
<Eq>
<FieldRef Name="ID"/>
<Value Type="Integer"><UserID/></Value>
</Eq>
</Where>
</Query>
select * from olist where ID==UserID
3、And,Eq,Lt,Neq,And嵌套
<Query>
<Where>
<And>
<Eq>
<FieldRef Name="AssignedTo"/>
<Value Type="Integer">
<UserID/>
</Value>
</Eq>
<And>
<Lt>
<FieldRef Name="DueDate"/>
<Value Type="DateTime">
<Today/>
</Value>
</Lt>
<Neq>
<FieldRef Name="Status"/>
<Value Type="Choice">Completed</Value>
</Neq>
</And>
</And>
</Where>
</Query>
<Query>
<Where>
<And>
<Eq>
<FieldRef Name="AssignedTo"/>
<Value Type="Integer">
<UserID/>
</Value>
</Eq>
<And>
<Lt>
<FieldRef Name="DueDate"/>
<Value Type="DateTime">
<Today/>
</Value>
</Lt>
<Neq>
<FieldRef Name="Status"/>
<Value Type="Choice">Completed</Value>
</Neq>
</And>
</And>
</Where>
</Query>
select * from olist where AssignedTo=UserId and
(DueDate<DateTime.now() and status!=completed)
7.5 下表是CAML查询的一些简单说明:
元素 说明
And 并且
BeginsWith 以某字符串开始的
Contains 包含某字符串
Eq 等于
FieldRef 一个字段的引用 (在GroupBy 中使用)
Geq 大于等于
GroupBy 分组
Gt 大于
IsNotNull 非空
IsNull 空
Leq 小于等于
Lt 小于
Neq 不等于
Now 当前时间
Or 或
OrderBy 排序
Today 今天的日期
TodayIso 今天的日期(ISO格式)
Where Where子句
- CAML语法-Query写法
- CAML语法-Query写法
- CAML语法- Query写法
- CAML query by user
- U2U CAML Query Builder Feature
- SharePoint Caml query Calculated Fields
- CAML 语法说明 及其实例
- CAML
- db写法query
- SharePoint: In a CAML query, filter by lookup item ID, not by its value
- U2U CAML Query Builder for SharePoint 2003 and SharePoint 2007 (Windows Version)
- How to get value of the person or group type via CAML Query js
- Get tasks assigned to user or to current user groups in SharePoint using CAML query
- osworkflow Query语法解析
- FrexibleSearch Query语法
- $query语法基础
- lucene query语法详解
- makefile 语法和写法
- TT
- 深度学习: 推进人工智能的梦想
- 分布式一致性协议
- 在采购和使用MLCC过程中应该注意哪些问题
- 如何使用Android最新的RecyclerView取代ListView?
- CAML语法- Query写法
- Windows Server 2008 R2 Standard升级到EnterPrise
- Makefile语法基础介绍
- C#-实验3
- Bitwise AND of Numbers Range LeetCode
- 第三周项目-1
- 分页
- linux C程序中调用shell终端的命令
- xcode4的环境变量,Build Settings参数,workspace及联编设置