1. Get All Lists in a SharePoint 2013 using REST API
2. Get Top ListItems
3. Display ListItems in JQUery DataTable
3. Display ListItems in JQUery DataTable
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.1/jquery.min.js"></script>
<script type="text/javascript" src="//ajax.aspnetcdn.com/ajax/4.0/1/MicrosoftAjax.js"></script>
<script type="text/javascript" src="/_layouts/15/sp.runtime.js"> </script>
<script type="text/javascript" src="/_layouts/15/sp.js"> </script>
=======================================================
<div>
<input type="button" value="Get All List" onclick="getAllList();" />
</div>
<script type="text/javascript">
// Get
All Lists in Site
function getAllList() {
debugger;
var requestUri = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists";
//_api/Lists/GetByTitle('Informations')/items?$select=EncodedAbsUrl,Category,ID&$orderby=Category asc&$orderby=Modified desc
//_api/Lists/GetByTitle('Informations')/items?$select=EncodedAbsUrl,Category,ID&$orderby=Category asc&$orderby=Modified desc
var requestHeaders = { "accept": "application/json;odata=verbose" };
$.ajax({
url: requestUri,
contentType: "application/json;odata=verbose",
headers: requestHeaders,
success: onSuccess,
error: onError
});
function onSuccess(data, request) {
var listColl ="";
var myLog = data.d;
for (var resultTipe in myLog.results) {
listColl +=
myLog.results[resultTipe].Title +"\n";
}
alert(listColl);
}
function onError(error) {
alert("error");
}
}
=====================================================================
=====================================================================
2. Get Top ListItems
<input id="txtItemToShow" type="text" />
var item2Show = $("#txtItemToShow").val();
var requestUri = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('rku
list')/items?select=id,Title&$Top="+ item2Show+"
";
=======================================================================
3. Get ListItems and Display in JQuery DataTable
=======================================================================
3. Get ListItems and Display in JQuery DataTable
<script type="text/javascript" src="//ajax.aspnetcdn.com/ajax/4.0/1/MicrosoftAjax.js"></script>
<script type="text/javascript" src="/_layouts/15/sp.runtime.js"> </script>
<script type="text/javascript" src="/_layouts/15/sp.js"> </script>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.1/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.4/jquery.dataTables.min.js"></script>
<link rel="stylesheet" type="text/css" href="http://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.4/css/jquery.dataTables.css">
<section>
<div id="divUserNewStarter">
<style type="text/css">
#divUserNewStarter {font-size:12px;}
#divUserNewStarter li {color:rgb(182,182,182);}
</style>
<table id='tblAllItems'>
<thead>
<tr >
<th align="Left">Item ID</th>
<th align="Left">Title</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</section>
<script type="text/javascript">
$(document).ready(function () {
getAllListItems();
});
function getAllListItems() {
item2Show = 110;
var requestUri = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('rku list')/items?select=id,Title&$Top=" + item2Show + "
";
var requestHeaders = { "accept": "application/json;odata=verbose" };
$.ajax({
url: requestUri,
contentType: "application/json;odata=verbose",
headers: requestHeaders,
success: onSuccess,
error: onError
});
}
function onSuccess(data, request) {
riskTable = "";
var myLog = data.d;
for (var resultType in myLog.results) {
riskTable = "<tr class='rowStyle'><td><li
class='tt-ListSquare'><span><a class='tt-Anchor' target=_self href=" + _spPageContextInfo.webAbsoluteUrl + "_layouts/15/listform.aspx?PageType=4&ListID=2d90bd86-b9f9-4a1a-aa5b-59e4f632fc8f&ID=" + myLog.results[resultType].ID + "&source=" +
_spPageContextInfo.webAbsoluteUrl + ">" + myLog.results[resultType].Title + "</a></span></li></td>";
riskTable = riskTable + "<td><span>" + myLog.results[resultType].ID + "<span></td>";
$('#tblAllItems').append(riskTable);
}
//
$("#countTable").dataTable({ "bSort": false });
// $("#countTable").dataTable({
"iDisplayLength": 5 });
// bFilter: True Enables the search
$("#tblAllItems").dataTable({
"bPaginate": true,
"bInfo": true,
"bFilter": true,
"bLengthChange": false,
"bSort": false
});
}
function onError(error) {
alert("error");
}
</script>
No comments:
Post a Comment