mardi 2 décembre 2014

Query items from list between Time ranges



I am trying to view all items on time between 08:00 to 17:00, I get only one item count even if I have more?



var fromTime = new Date(result);
var toTime = new Date(result2);
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml('<View><FieldRef Name=\'EventDate\' /><Value IncludeTimeValue=\'TRUE\' Type=\'DateTime\'>' + fromTime.setTime() + '</Value><FieldRef Name=\'EndDate\' /><Value IncludeTimeValue=\'TRUE\' Type=\'DateTime\'>' + toTime.setHours(17) + '</Value></View>');

this.collListItem = list.getItems(camlQuery);
context.load(collListItem);

var itemCount = collListItem.get_count();
if (itemCount > 0) {
alert(itemCount);
}







0 commentaires:

Enregistrer un commentaire