Skip to main content
jP_web_icon

Examples

Go Search
Home
  
Examples > src > RetrieveListItems  

Web Part Page Title Bar image
RetrieveListItems

 Script Code

<div id='outtable' />
<script type="text/javascript"
src="//sharejpoint.googlecode.com/files/jPointLoader-0.6-expanded.js" ></script>
<script>
$(document).ready(function(){
  var query = "<OrderBy><FieldRef Name='ID' Ascending='FALSE' /></OrderBy>";
  var list = jP.Lists.setSPObject("/examples", "FeedbackExample");
  list.getSPItemsWithQuery(query);
  var data = list.JQueryData;
  //extract data into items
  var items = {};
  for(var j=0; j < data.length; j++) {
    var ItemFields = data[j].attributes;
    items[j] = {};
    for (i=0; i<ItemFields.length; i++) {
      var ItemFieldName = ItemFields[i].name.replace(/ows_/i, "").replace(/_x0020_/g, "");
      items[j][ItemFieldName]=ItemFields[i].value;
    }
  }
  var out = "<table border=1>";
  $.each(items, function (i, v){
    out += "<tr><td>"+i+"</td><td>"+v.Comments+"</td></tr>";
  });
  out += "</table>";
  $("#outtable").html(out);
});
</script>

 Script Running

<div id='outtable' />
<script type="text/javascript" src="//sharejpoint.googlecode.com/files/jPointLoader-0.6-expanded.js" ></script>
<script>
$(document).ready(function(){
  var query = "<OrderBy><FieldRef Name='ID' Ascending='FALSE' /></OrderBy>";
  var list = jP.Lists.setSPObject("/examples", "FeedbackExample");
  list.getSPItemsWithQuery(query);
  var data = list.JQueryData;
  //extract data into items
  var items = {}; 
  for(var j=0; j < data.length; j++) {  
    var ItemFields = data[j].attributes;
    items[j] = {};
    for (i=0; i<ItemFields.length; i++) {
      var ItemFieldName = ItemFields[i].name.replace(/ows_/i, "").replace(/_x0020_/g, "");
      items[j][ItemFieldName]=ItemFields[i].value;
    }
  }
  var out = "<table border=1>";
  $.each(items, function (i, v){
    out += "<tr><td>"+i+"</td><td>"+v.Comments+"</td></tr>";
  });
  out += "</table>";
  $("#outtable").html(out);
});
</script>