I'm using the following query :
camlQuery.set_viewXml = "<View><Query><Where><Eq><FieldRef Name='Employee'/><Value Type='User'>" + currentUser.get_title() + "</Value></Eq></Where></Query></View>";
var listItemCollection = list.getItems(camlQuery);
clientContext.load(listItemCollection);
clientContext.executeQueryAsync(function () {
//alert("Success");
var listItemEnumerator = listItemCollection.getEnumerator();
if (listItemCollection.get_count() == 1 && listItemEnumerator.moveNext()) {
}
This query returns ok results (count = 1) using the U2U Caml Query builder. When i use the code in visual studio it returns 2 results, all the items in the list.
What is wrong with my code?
I also tried query with ID but again returns all items.
//camlQuery.set_viewXml = ("<Query><Where><Eq><FieldRef Name='Employee' LookupId='True'/><Value Type='Lookup'>" + _spPageContextInfo.userId + "</Value></Eq></Where></Query>");