i am trying to retrieve all items between the time 8-17, i only get one item even if i got 2 items in the list,
function () {
var fromTime = new Date(result);
var fromTimeConverted = fromTime.toJSON().split('T')[0] + "T08:00:00Z";
var toTime = new Date(result2);
var toTimeConverted = toTime.toJSON().split('T')[0] + "T17:00:00Z";
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml('<View><Query><Where><And><Geq><FieldRef Name=\'EventDate\' /><Value IncludeTimeValue=\'TRUE\' Type=\'DateTime\'>'
+ fromTimeConverted + '</Value></Geq><Leq><FieldRef Name=\'EndDate\' /><Value IncludeTimeValue=\'TRUE\' Type=\'DateTime\'>' + toTimeConverted +
'</Value></Leq></And></Where></Query></View>');
this.collListItem = list.getItems(camlQuery);
context.load(collListItem);
context.load(collListItem, 'Include(EventDate,EndDate)');
var listItemEnumerator = collListItem.getEnumerator();
while (listItemEnumerator.moveNext()) {
var oListItem = listItemEnumerator.get_current();
var listDetails = oListItem.get_item('EventDate') +" " + oListItem.get_item('EndDate');
result = result + listDetails;
alert(result);
}

0 commentaires:
Enregistrer un commentaire