if in you Client object Model code CamlQuery returning all data or C# Server object model SPQuery / CamlQuery returning all data so there may be issue with way of writing Query, it happens due to small mistake while copy pasting query from caml query builder to our code. It is very small thing that need to take care while pasting query to CamlQuery or SPQuery object,
Client Object Model:
<View><Query>
<Where>
<And>
<Eq>
<FieldRef Name='Title' />
<Value Type='Text'>" + t1 + @"</Value>
</Eq>
</And>
</Where>
</Query></View>
Server Object Model
<View><Query>
<Where>
<And>
<Eq>
<FieldRef Name='Title' />
<Value Type='Text'>" + t1 + @"</Value>
</Eq>
</And>
</Where>
</Query></View>
Sample
Code:
using (ClientContext clientContext = new ClientContext(txtSiteUrl.Text))
{
CamlQuery oQuery = new CamlQuery();
oQuery.ViewXml = @"<View><Query><Where>
<And>
<Eq>
<FieldRef Name='Title' />
<Value Type='Text'>" + t + @"</Value>
</Eq>
</And>
</Where></Query></View>";
List oList = clientContext.Web.Lists.GetByTitle("myList");
if (oList != null)
{
ListItemCollection oColl=oList.GetItems(oQuery);
clientContext.Load(oColl);
clientContext.ExecuteQuery();
}
}
In short while working in Client object Model you should append
your Query between <Query><View> </View></Query>like
below:
<View><Query>Your Caml Query</View></Query>
And while working in Server object model remove Query tag from caml query which
is copied from caml query builder like
<Where><Eq><FieldRef
Name='Title' /><Value
Type='Text'>Praveen</Value></Eq></Where>
Please share any issue or findings in this.
--
Regards,
Praveen Pandit
MCTS; MCPD
Keep Sharing Knowledge!!