New answers tagged caml-query
0
I tested with two choice fields with same field name without other condition and it works as expected:
Suggest to test with Caml Designer to build the correct result:
Caml Designer Download
1
Date and time in sharepoint is ISO 8601 format. You could try the below script:
$spweb = get-spweb http://sp/sites/test/
$splist = $spweb.Lists.TryGetList("TestList")
$query = New-Object Microsoft.SharePoint.SPQuery
$query.Query =
" <Where>
<And>
<Geq>
<FieldRef Name='Created' />
<...
1
Try using something like below:
<Query>
<Where>
<And>
<Geq>
<FieldRef Name="Created" />
<Value IncludeTimeValue="FALSE" Type="DateTime">2019-09-01</Value>
</Geq>
<Leq>
<FieldRef Name="Created" />
<Value IncludeTimeValue="FALSE" Type="...
1
You're not able to combine those queries into a single CAML-query but you can query all those items in the same request, ex:
List tasksList = context.Web.Lists.GetByTitle("Tasks");
List meetingList = context.Web.Lists.GetByTitle("Meeting");
List newsList = context.Web.Lists.GetByTitle("News");
CamlQuery tasksQuery = new CamlQuery() { ViewXml = '...' };
...
3
This is not a special character issue.
You cannot combine Contains element with Choice field type.
Try Eq element instead:
<ViewFields>
<FieldRef Name='ActionStatus' />
</ViewFields>
<Where>
<Eq>
<FieldRef Name='Region' />
<Value Type='Choice'>East & West</Value>
</Eq>
</Where>
0
As per this blog, it's stating that you wrap your special text in <![CDATA[ TEXT ]]>.
So in your situation it would be <![CDATA[East & West]]>.
For others that are building CAML queries programically, you can split the string and add your variable as normal.
const direction = "East & West";
const camlString = '<Value Type="Choice"&...
0
If you want to set a field's value on form submit, you can add a button and set rules on the button as the following:
Top 50 recent answers are included
