Let's Sharepoint: javascript object model jsom to get list items; append items into table

<script type="text/javascript" src="//code.jquery.com/jquery-1.11.3.min.js"></script>
<script type="text/javascript" src="//code.jquery.com/jquery-migrate-1.2.1.min.js"></script>
<script 
    src="//ajax.aspnetcdn.com/ajax/4.0/1/MicrosoftAjax.js" 
    type="text/javascript">
</script>
<script 
    type="text/javascript" 
    src="/_layouts/15/sp.runtime.js">
</script>
<script 
    type="text/javascript" 
    src="/_layouts/15/sp.js">
</script>
<script type="text/javascript">
  var jid;
  

jQuery(document).ready(function() {
  //alert("loading");
 
  
  var urls = window.location.href.split('=');
  //alert(urls[1]);
  var res=urls[1].split('&');
  var jn=res[0]
  //alert(jn);

$.ajax({
url: "https://pslightwave.sharepoint.com/sites/Operations/WorkOrders/_api/web/lists/getbytitle('FieldWorkOrders')/items?$filter=(Id eq "+jn+")",
        type: "GET",
        headers: {
            "accept": "application/json;odata=verbose",
        },
        success: function(data){
//alert(data.d.results[0].JobNumberId);  
jid=data.d.results[0].JobNumberId;  

//alert(jid);

$.ajax({
url: "https://pslightwave.sharepoint.com/sites/Operations/WorkOrders/_api/web/lists/getbytitle('Mas90 Job Numbers')/items?$filter=(Id eq "+jid+")",
        type: "GET",
        headers: {
            "accept": "application/json;odata=verbose",
        },
        success: function(data){
//alert(data.d.results[0].JobNumberId);  
jbnum=data.d.results[0].JobNameNumber;  

//alert(jbnum);
expo(data.d.results[0].JobNameNumber);

        },
        error: function(error){

            alert(JSON.stringify(error));
        }
  
    });


        },
        error: function(error){

            alert(JSON.stringify(error));
        }
  
    });

        
    
 SP.SOD.executeFunc('sp.js','SP.ClientContext',expo);
    
    
}); 

function expo()
{
//alert(jbnum);
var clientContext = new SP.ClientContext("https://pslightwave.sharepoint.com/sites/Operations/");
    //alert(clientContext);
   var oWebsite = clientContext.get_web().get_lists().getByTitle('Permit Applications');
    //alert(oWebsite);
     var camlQuery = new SP.CamlQuery();
    camlQuery.set_viewXml(
        "<View><Query><Where><Eq><FieldRef Name='Job_x0020_Number' /><Value Type='Text'>"+jbnum+"</Value></Eq></Where></Query></View>"
    );
    this.collListItem = oWebsite.getItems(camlQuery);
    clientContext.load(collListItem);
    clientContext.executeQueryAsync(
        Function.createDelegate(this, this.onQuerySucceeded), 
        Function.createDelegate(this, this.onQueryFailed)
    );
}
function onQuerySucceeded(sender, args) {
//alert("sucess now");
var listItemInfo = '';
    var listItemEnumerator = collListItem.getEnumerator();
        //alert("listItemEnumerator");
    while (listItemEnumerator.moveNext()) {
        var oListItem = listItemEnumerator.get_current();
        listItemInfo += '\nID: ' + oListItem.get_id() + 
            '\nName: ' + oListItem.get_item('Permit_x0020_Location') + 
            '\nName: ' + oListItem.get_item('Title')            
           // $('#myTable').append('<tr><td>' + oListItem.get_item('Title') + '</td><td>' + oListItem.get_id() + '</td></tr>');
           $('#myTable').append('<tr><td>' + oListItem.get_item('Title') + '</td><td><a href="https://pslightwave.sharepoint.com/sites/Operations/Permit%20Applications/' + oListItem.get_item('Title')+ '">' + oListItem.get_item('Title') + '</a></td><td>' + oListItem.get_item('Permit_x0020_Location') + '</td></tr>');
            }

    alert(listItemInfo.toString());
}
    
function onQueryFailed(sender, args) {
alert("failed");
    alert('Request failed. ' + args.get_message() + 
        '\n' + args.get_stackTrace());
}
    


// alert(jid);

</script> 

<html>
<body>
<table id="myTable" border="1">
<tr>

  <th class="auto-style14">Name </th>
  <th class="auto-style14">Link to Related Permit Application</th>
  <th class="auto-style14">Permit Location</th>

  </tr>
 


</table>
</body>
</html>
Let's Sharepoint

Saturday, July 25, 2015

javascript object model jsom to get list items; append items into table

No comments:

Post a Comment
