mardi 2 décembre 2014

retrieve items between 8 and 17



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