I am building a visual web part application with c# and i need to query items from my list, but i have to add some conditionals.
I am successfully querying ID and Title but I need another conditional to show items only if they are created earlier than example 5 May 2017.
I am trying the following query but it is not working and it shows me an error?
please help me!
<Query> <Where> <And> <Lt> <FieldRef Name='ID' /> <Value Type='Counter'>10</Value> </Lt> <Eq> <FieldRef Name='Title' /> <Value Type='Text'>text</Value> </Eq> <Leq> <FieldRef Name='Created' /> <Value IncludeTimeValue='TRUE' Type='DateTime'>2017-05-05T17:01:50Z</Value> </Leq> </And> </Where> </Query>