function GetProjects() {
var url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('" + projectListName + "')/items?" + "$filter=((substringof('" + user.get_title() + "',Members)) and (ProjectStatus+eq+'Open'))";
$.ajax({
url: url,
type: "GET",
headers: { "accept": "application/json;odata=verbose" },
success: function (data) {
for (var i = 0; i < data.d.results.length; i++) {
var project = data.d.results[i].Title;
}
},
error: function (xhr) {
alert(xhr.status + ': ' + xhr.statusText);
console.log(xhr.status + ': ' + xhr.statusText);
}
});
}
-----------------------------------------------------------------
Filter on Date Fields
------------------------------------------------------------------
$.ajax({
url: _spPageContextInfo.webAbsoluteUrl +
"/_api/lists/getbytitle('TimesheetEntry')/items?$filter=Date+gt+'" + FromDate + "' and Date+le+'" +ToDate + "'",
type: "GET",
headers: {
"accept": "application/json;odata=verbose",
},
success: function (data) {
if (data.d.results.length > 0) {
$.each(data.d.results, function (i, item) {
var a= data.d.results[i].Date;
var b= data.d.results[i].User;
});
}
},
error: function (err) {
console.log(JSON.stringify(err));
}
});
var url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('" + projectListName + "')/items?" + "$filter=((substringof('" + user.get_title() + "',Members)) and (ProjectStatus+eq+'Open'))";
$.ajax({
url: url,
type: "GET",
headers: { "accept": "application/json;odata=verbose" },
success: function (data) {
for (var i = 0; i < data.d.results.length; i++) {
var project = data.d.results[i].Title;
}
},
error: function (xhr) {
alert(xhr.status + ': ' + xhr.statusText);
console.log(xhr.status + ': ' + xhr.statusText);
}
});
}
-----------------------------------------------------------------
Filter on Date Fields
------------------------------------------------------------------
$.ajax({
url: _spPageContextInfo.webAbsoluteUrl +
"/_api/lists/getbytitle('TimesheetEntry')/items?$filter=Date+gt+'" + FromDate + "' and Date+le+'" +ToDate + "'",
type: "GET",
headers: {
"accept": "application/json;odata=verbose",
},
success: function (data) {
if (data.d.results.length > 0) {
$.each(data.d.results, function (i, item) {
var a= data.d.results[i].Date;
var b= data.d.results[i].User;
});
}
},
error: function (err) {
console.log(JSON.stringify(err));
}
});