This gets a SharePoint list items, can be used with a query. It also uses the current context for credentials.
function getAllItemsByKey(itemKey)
{
var clientContext= new SP.ClientContext.get_current();
var oList = clientContext.get_web().get_lists().getByTitle('RedFlagData');
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml(
'<View><Query><Where><Eq><FieldRef Name=\'IDKey\'/>' +
'<Value Type=\'Text\'>' + itemKey + '</Value></Eq></Where></Query>' +
'<RowLimit>55</RowLimit></View>'
);
//console.log(itemKey);
this.collListItem = oList.getItems(camlQuery);
clientContext.load(collListItem);
clientContext.executeQueryAsync(
function(){
var listItemEnumerator = collListItem.getEnumerator();
var i = 1;
while (listItemEnumerator.moveNext()) {
var oListItem = listItemEnumerator.get_current();
var itemRowID = oListItem.get_item('RowKey');
var tableRow = document.getElementById(itemRowID);
createUpdateDropDown(i, 'A', tableRow, sourceYesNo,oListItem.get_item('Detection'),oListItem.get_item('ID'),itemKey,'75');
createUpdateDropDown(i, 'B', tableRow, sourceYesNo,oListItem.get_item('Mitigation'),oListItem.get_item('ID'),itemKey,'75');
createUpdateDropDown(i, 'C', tableRow, sourceYesNo,oListItem.get_item('Response'),oListItem.get_item('ID'),itemKey,'75');
createUpdateTextArea(i, 'D', tableRow,oListItem.get_item('Policy_x002d_Procedure'),oListItem.get_item('ID'),itemKey);
createUpdateTextArea(i, 'E', tableRow,oListItem.get_item('Gap_x0020_Analysis'),oListItem.get_item('ID'),itemKey);
createUpdateTextArea(i, 'F', tableRow,oListItem.get_item('Identified_x0020_Inherent_x0020_'),oListItem.get_item('ID'),itemKey);
createUpdateTextArea(i, 'G', tableRow,oListItem.get_item('Risk_x0020_Mitigation_x0020_and_'),oListItem.get_item('ID'),itemKey);
createUpdateDropDown(i, 'H', tableRow, cType, oListItem.get_item('Control_x0020_Type'),oListItem.get_item('ID'),itemKey,'95');
createUpdateDropDown(i, 'I', tableRow, impact, oListItem.get_item('Impact'),oListItem.get_item('ID'),itemKey,'75');
createUpdateDropDown(i, 'J', tableRow, impact, oListItem.get_item('Likelihood'),oListItem.get_item('ID'),itemKey,'75');
createUpdateDropDown(i, 'K', tableRow, impact, oListItem.get_item('Risk_x0020_Indicator'),oListItem.get_item('ID'),itemKey,'75');
i++;
//console.log(i);
}//end while
}
,
function(a,b){
console.log('Request failed. ' + b.get_message() + '\n' + b.get_stackTrace());
}
);
}function EditItemKey(ItemID)
{
//var ItemID = getParameterByName('RedFlagData');
var clientContext= new SP.ClientContext.get_current();
var oList = clientContext.get_web().get_lists().getByTitle('RedFlagData');
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml(
'<View><Query><Where><Eq><FieldRef Name=\'ID\'/>' +
'<Value Type=\'Number\'>' + ItemID + '</Value></Eq></Where></Query>' +
'<RowLimit>1</RowLimit></View>'
);
this.collListItem = oList.getItems(camlQuery);
clientContext.load(collListItem);
clientContext.executeQueryAsync(
Function.createDelegate(this, this.onQueryItemKeySucceeded),
Function.createDelegate(this, this.onQueryItemKeyFailed)
);
}
function onQueryItemKeySucceeded(sender, args) {
var listItemInfo = '';
var listItemEnumerator = collListItem.getEnumerator();
var itemKey;
while (listItemEnumerator.moveNext()) {
var oListItem = listItemEnumerator.get_current();
itemKey = oListItem.get_item('IDKey');
}
getAllItemsByKey(itemKey);
}
function onQueryItemKeyFailed(sender, args) {
alert('Request failed. ' + args.get_message() +
'\n' + args.get_stackTrace());
}
<script type="text/javascript">
retrieveListItems("Wellness Events");
function retrieveListItems(strListTitle) {
//document.getElementById("fooBar").innerHTML = "";
var clientContext= new SP.ClientContext.get_current();
var oList = clientContext.get_web().get_lists().getByTitle(strListTitle);
//var view = list.get_views().getByTitle(viewTitle);
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml(
"<View><Query>'<Where><Gt><FieldRef Name='EndDate' />" +
"<Value Type='DateTime'><Today /></Value>" +
"</Gt>" +
"</Where></Query>" +
"<RowLimit>10</RowLimit></View>"
);
this.collListItem = oList.getItems(camlQuery);
clientContext.load(collListItem);
clientContext.executeQueryAsync(
Function.createDelegate(this, this.onQuerySucceeded),
Function.createDelegate(this, this.onQueryFailed)
);
}
function onQuerySucceeded(sender, args) {
var listItemInfo = '';
var listItemEnumerator = collListItem.getEnumerator();
var strLinkP1 = "<a href='http://scushp01/sites/Testing/Lists/Wellness%20Events/DispForm.aspx?ID=";
var strLinkP2 = "&Source=http%3A%2F%2Fscushp01%2Fsites%2FTesting%2FPages%2FIntranetHomeTest.aspx'>";
var strHtml = "";
while (listItemEnumerator.moveNext()) {
var oListItem = listItemEnumerator.get_current();
strHtml += strLinkP1;
strHtml += oListItem.get_item("ID");
strHtml += strLinkP2;
strHtml += oListItem.get_item("Title");
strHtml += "</a><br/>";
}
document.getElementById("fooBar").innerHTML = strHtml;
}
function onQueryFailed(sender, args) {
alert('Request failed. ' + args.get_message() +
'\n' + args.get_stackTrace());
}
</script>
function retrieveListItems(strListTitle) {
document.getElementById("fooBar").innerHTML = "";
var clientContext= new SP.ClientContext.get_current();
var oList = clientContext.get_web().get_lists().getByTitle(strListTitle);
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml(
'<View><Query><Where><Geq><FieldRef Name=\'ID\'/>' +
'<Value Type=\'Number\'>1</Value></Geq></Where></Query>' +
'<RowLimit>10</RowLimit></View>'
);
this.collListItem = oList.getItems(camlQuery);
clientContext.load(collListItem);
clientContext.executeQueryAsync(
Function.createDelegate(this, this.onQuerySucceeded),
Function.createDelegate(this, this.onQueryFailed)
);
}
function onQuerySucceeded(sender, args) {
var listItemInfo = '';
var listItemEnumerator = collListItem.getEnumerator();
while (listItemEnumerator.moveNext()) {
var oListItem = listItemEnumerator.get_current();
oListItem.get_item(strField)
}
function onQueryFailed(sender, args) {
alert('Request failed. ' + args.get_message() +
'\n' + args.get_stackTrace());
}