magritton
11/4/2015 - 2:18 PM

This gets a SharePoint list items, can be used with a query. It also uses the current context for credentials.

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());
}