Datatable shows when page is put in Edit Mode

@Nanddeep: I am using JSOM to fetch the data. I want to restrict the listitems shown for a user. Show all items if the user is a SiteAdmin else show items created by that user.

I am getting the below error:

Error: Data Reterival Failed: Unexpected response from server. The status code of response is '403'

Below is the code:

var txtHTMLLeaveReport = "";

var tableLeaveReport;

var allLeaveReportData;

$(document).ready(function () {

ExecuteOrDelayUntilScriptLoaded(loadLeaveReportList, "sp.js");

});

function loadLeaveReportList() {

var query = "";

var currentClientContext = new SP.ClientContext.get_current();

var currentWeb = currentClientContext.get_web();

var userid = _spPageContextInfo.get_userid;

var leaveReportDataList = currentWeb.get_lists().getByTitle('LeaveRequest');

var camlQuery = new SP.CamlQuery();

var camlXML = "";

var isadmin = _spPageContextInfo.isSiteAdmin;

if (isadmin)

{

camlXML = "";

}

else

{

camlXML = "" + _spPageContextInfo.userId + "";

}

camlQuery.set_viewXml(camlXML);

allLeaveReportData = leaveReportDataList.getItems(camlQuery);

currentClientContext.load(allLeaveReportData);

currentClientContext.executeQueryAsync(Function.createDelegate(this, this.success), Function.createDelegate(this, this.failed));

}

function success() {

var StartDate = null;

var EndDate = null;

var HalfDay = null;

var LeaveType = null;

var ReasonForLeave = null;

var RequestDays = null;

var ApprovalStatus = null;

var Requestor = null;

var USCurrency = { style: "currency", currency: "USD" };

txtHTMLLeaveReport = "";

var Header = "" +

"" +

"Start Date" +

"End Date" +

"Half Day " +

"Leave Type" +

"Reason For Leave" +

"Request Days" +

"Approval Status" +

"Requestor" +

"" +

"";

txtHTMLLeaveReport += Header;

txtHTMLLeaveReport += "";

var listEnumerator = allLeaveReportData.getEnumerator();

while (listEnumerator.moveNext()) {

var currentItem = listEnumerator.get_current();

if (currentItem.get_item('StartDate') != null) {

StartDate = currentItem.get_item('StartDate');

StartDate = StartDate.format('dd MMM yyyy');

} else {

StartDate = "";

}

if (currentItem.get_item('EndDate') != null) {

EndDate = currentItem.get_item('EndDate');

EndDate = EndDate.format('dd MMM yyyy');

} else {

EndDate = "";

}

if (currentItem.get_item('HalfDay') != null) {

HalfDay = currentItem.get_item('HalfDay');

} else {

HalfDay = "";

}

if (currentItem.get_item('LeaveType') != null) {

LeaveType = currentItem.get_item('LeaveType');

} else {

LeaveType = "";

}

if (currentItem.get_item('ReasonForLeave') != null) {

ReasonForLeave = currentItem.get_item('ReasonForLeave');

} else {

ReasonForLeave = "";

}

if (currentItem.get_item('RequestDays') != null) {

RequestDays = currentItem.get_item('RequestDays');

} else {

RequestDays = "";

}

if (currentItem.get_item('ApprovalStatus') != null) {

ApprovalStatus = currentItem.get_item('ApprovalStatus');

} else {

ApprovalStatus = "";

}

if (currentItem.get_item('Requestor').get_lookupValue() != null) {

Requestor = currentItem.get_item('Requestor').get_lookupValue();

} else {

Requestor = "";

}

txtHTMLLeaveReport += "" +

"" + StartDate + "" +

"" + EndDate + "" +

"" + HalfDay + "" +

"" + LeaveType + "" +

"" + ReasonForLeave + "" +

"" + RequestDays + "" +

"" + ApprovalStatus + "" +

"" + Requestor + "";

txtHTMLLeaveReport += "";

}

txtHTMLLeaveReport += "";

$("#idLeaveReportList").append(txtHTMLLeaveReport);

tableLeaveReport = $('#idLeaveReportList').DataTable(

{

"columnDefs": [

{ "targets": [0], "visible": true, "width": "8%" },

{ "targets": [1], "visible": true, "width": "8%" },

{ "targets": [2], "visible": true, "width": "8%" },

{ "targets": [3], "visible": true, "width": "8%" },

{ "targets": [4], "visible": true, "width": "8%" },

{ "targets": [5], "visible": true, "width": "8%" },

{ "targets": [6], "visible": true, "width": "8%" },

{ "targets": [7], "visible": true, "width": "8%" }

]

}

);

tableLeaveReport.draw();

}

function failed(sender, args) {

alert("Data Reterival Failed: " + args.get_message());

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shail S8y ago
@Nanddeep: I am using JSOM to fetch the data. I want to restrict the listitems shown for a user. Show all items if the user is a SiteAdmin else show items created by that user.

I am getting the below error:

Error: Data Reterival Failed: Unexpected response from server. The status code of response is '403'

Below is the code:

var txtHTMLLeaveReport = "";
var tableLeaveReport;
var allLeaveReportData;
$(document).ready(function () {
ExecuteOrDelayUntilScriptLoaded(loadLeaveReportList, "sp.js");
});
function loadLeaveReportList() {

var query = "";

var currentClientContext = new SP.ClientContext.get_current();
var currentWeb = currentClientContext.get_web();
var userid = _spPageContextInfo.get_userid;
var leaveReportDataList = currentWeb.get_lists().getByTitle('LeaveRequest');
var camlQuery = new SP.CamlQuery();
var camlXML = "";

var isadmin = _spPageContextInfo.isSiteAdmin;

if (isadmin)
{
camlXML = "";

}
else
{
camlXML = "" + _spPageContextInfo.userId + "";
}

camlQuery.set_viewXml(camlXML);
allLeaveReportData = leaveReportDataList.getItems(camlQuery);
currentClientContext.load(allLeaveReportData);
currentClientContext.executeQueryAsync(Function.createDelegate(this, this.success), Function.createDelegate(this, this.failed));
}
function success() {
var StartDate = null;
var EndDate = null;
var HalfDay = null;
var LeaveType = null;
var ReasonForLeave = null;
var RequestDays = null;
var ApprovalStatus = null;
var Requestor = null;

var USCurrency = { style: "currency", currency: "USD" };
txtHTMLLeaveReport = "";
var Header = "" +
"" +
"Start Date" +
"End Date" +
"Half Day " +
"Leave Type" +
"Reason For Leave" +
"Request Days" +
"Approval Status" +
"Requestor" +
"" +
"";
txtHTMLLeaveReport += Header;
txtHTMLLeaveReport += "";
var listEnumerator = allLeaveReportData.getEnumerator();
while (listEnumerator.moveNext()) {
var currentItem = listEnumerator.get_current();

if (currentItem.get_item('StartDate') != null) {
StartDate = currentItem.get_item('StartDate');
StartDate = StartDate.format('dd MMM yyyy');
} else {
StartDate = "";
}
if (currentItem.get_item('EndDate') != null) {
EndDate = currentItem.get_item('EndDate');
EndDate = EndDate.format('dd MMM yyyy');
} else {
EndDate = "";
}
if (currentItem.get_item('HalfDay') != null) {
HalfDay = currentItem.get_item('HalfDay');
} else {
HalfDay = "";
}
if (currentItem.get_item('LeaveType') != null) {
LeaveType = currentItem.get_item('LeaveType');
} else {
LeaveType = "";
}

if (currentItem.get_item('ReasonForLeave') != null) {
ReasonForLeave = currentItem.get_item('ReasonForLeave');
} else {
ReasonForLeave = "";
}
if (currentItem.get_item('RequestDays') != null) {
RequestDays = currentItem.get_item('RequestDays');
} else {
RequestDays = "";
}
if (currentItem.get_item('ApprovalStatus') != null) {
ApprovalStatus = currentItem.get_item('ApprovalStatus');
} else {
ApprovalStatus = "";
}
if (currentItem.get_item('Requestor').get_lookupValue() != null) {

Requestor = currentItem.get_item('Requestor').get_lookupValue();
} else {
Requestor = "";
}

txtHTMLLeaveReport += "" +
"" + StartDate + "" +
"" + EndDate + "" +
"" + HalfDay + "" +
"" + LeaveType + "" +
"" + ReasonForLeave + "" +
"" + RequestDays + "" +
"" + ApprovalStatus + "" +
"" + Requestor + "";
txtHTMLLeaveReport += "";
}
txtHTMLLeaveReport += "";
$("#idLeaveReportList").append(txtHTMLLeaveReport);
tableLeaveReport = $('#idLeaveReportList').DataTable(
{
"columnDefs": [
{ "targets": [0], "visible": true, "width": "8%" },
{ "targets": [1], "visible": true, "width": "8%" },
{ "targets": [2], "visible": true, "width": "8%" },
{ "targets": [3], "visible": true, "width": "8%" },
{ "targets": [4], "visible": true, "width": "8%" },
{ "targets": [5], "visible": true, "width": "8%" },
{ "targets": [6], "visible": true, "width": "8%" },
{ "targets": [7], "visible": true, "width": "8%" }
]
}
);
tableLeaveReport.draw();
}
function failed(sender, args) {
alert("Data Reterival Failed: " + args.get_message());
}
0
Nanddeep Nachan8y ago
In normal mode, open developer dashboard (F12) and observe the console window.
Check if any script is getting blocked or any error logged to console.
0