Server Object Model:
query.Query = "<Where><Contains><FieldRef Name="Name"/><Value Type="Text">" + "YourValue" + "/Value></Contains></Where>";
Client Object Model:
"<Query><Where><Contains><FieldRef Name="Name"/><Value Type="Text">" + "YourValue"...
Showing posts with label CAML Query. Show all posts
Showing posts with label CAML Query. Show all posts
Tuesday, November 29, 2016
<Value Type="Note"><!CDATA[<BR>]]></Value>
<Query>
<Where>
<Contains>
<FieldRef Name='title_id ' />
<Value Type='Computed'>o</Value>
</Contains>
...
In CAML query, 'complex' fields which store multiple values, only the 'default' value is available to query - by this I mean what would be available when SPField.GetFieldValueAsText()&nbs...
We can SPUserField as SPLookupField
<Query>
<Where>
<And>
<Eq>
<FieldRef Name='UserField'/>
...
CAML Designer
The one that works is this URL: http://camldesigner.blob.core.windows.net/offlinepackage/CamlDesigner2013.zip
The link comes from Karine Bosch's Blog. CAML Designer is the successor of CAML Builder, and from experience I can tell you this tool is much better and accurate. I've tried the both.
Edit: Looks...
Wednesday, March 2, 2016
C# Coding:
DateTime strdate = (DateTime)DateTime.Today.AddDays(7);
string strgetDate = strdate.Year + "-" + strdate.Month + "-" + strdate.Date.Day;
SPWeb currentWeb = SPContext.Current.Web;
SPList lst = currentWeb.Lists["Projects"];
...
Tuesday, February 9, 2016
<Where>
<Leq>
<FieldRef Name ='" + internalEndDate + "'/>
<Value Type ='DateTime'>" + System.DateTime.Now.AddDays(7) + "</Value>
</Leq>
</Where>
Current Date
<Where>
<Leq>
<FieldRef Name ='"...
Posts
