sharepoint/CAMLGet100Items.cs at master · eguimaraes/sharepoint · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
 var q = new CamlQuery() { ViewXml = "<View><Query><Where><And><Gt><FieldRef Name='ID' /><Value Type='Counter'>9000</Value></Gt><Lt><FieldRef Name='ID' /><Value Type='Counter'>10000</Value></Lt></And></Where><OrderBy><FieldRef Name='ID' Ascending='True' /></OrderBy></Query></View>"};
    var r = list.GetItems(q);
    ctx.Load(r);

    var q = new SPQuery()
{
    Query = @"<Where><And><Gt><FieldRef Name='ID' /><Value Type='Counter'>9000</Value></Gt><Lt><FieldRef Name='ID' /><Value Type='Counter'>10000</Value></Lt></And></Where><OrderBy><FieldRef Name='ID' Ascending='True' /></OrderBy>"
};


var r = list.GetItems(q);

/*
<Query>
   <Where>
      <And>
         <Gt>
            <FieldRef Name='ID' />
            <Value Type='Counter'>9000</Value>
         </Gt>
         <Lt>
            <FieldRef Name='ID' />
            <Value Type='Counter'>10000</Value>
         </Lt>
      </And>
   </Where>
   <OrderBy>
      <FieldRef Name='ID' Ascending='True' />
   </OrderBy>
</Query>

*/