how could i retrieve items from and daterange 2014-12-07 08:00 to 17:00 2014-12-08 08:00 to 17:00 2014-12-09 08:00 to 17:00
With my query right now i have from 2014-12-07 08:00 to 2014-09-17:00 And that also adds hours from others time between the nights, but i dont wont so,
var fromTime; var toTime; var listItemCustom; var listItemtoDate; var fromTimeConverted; var toTimeConverted;
function checkFreebookingdateTime() {
getListCalender = document.getElementById('CalenderListDrop').value;
spHostUrl = decodeURIComponent(getQueryStringParameter('SPHostUrl'));
context = new SP.ClientContext.get_current();
parentContext = new SP.AppContextSite(context, spHostUrl);
web = parentContext.get_web();
list = web.get_lists().getByTitle(getListCalender);
context.load(list);
var fromDate08 = "T08:00:00Z";
var toDate17 = "T17:00:00Z";
listItemCustom = document.getElementById('datepicker').value;
var listItemFromTime = document.getElementById('timepicker').value;
listItemtoDate = document.getElementById('datepickerto').value;
var listItemToTime = document.getElementById('timepickerTo').value;
var result = listItemCustom + "T" + listItemFromTime + ":00" + "Z";
var result2 = listItemtoDate + "T" + listItemToTime + ":00" + "Z";
fromTime = new Date(result);
var numberToAddbefore = -1;
fromTime.setDate(fromTime.getDate() + numberToAddbefore);
fromTimeConverted = fromTime.toJSON().split('T')[0] + fromDate08;
toTime = new Date(result2);
var numberToAddafter = 1;
toTime.setDate(toTime.getDate() + numberToAddafter);
toTimeConverted = toTime.toJSON().split('T')[0] + toDate17;
var camlQuery = new SP.CamlQuery('<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>');
camlQuery.set_viewXml();
collListItem = list.getItems(camlQuery);
context.load(collListItem);
context.executeQueryAsync(onQuerySucceeded, onQueryFailed);
}
0 commentaires:
Enregistrer un commentaire