Display TASK status using REST API

Sign in to answer this question.

• 

  Prem M5y agoPosted Jun 18, 2021, 2:45 PM

  I'm not getting any alerts 
• 

  Sachin Singh5y agoPosted Jun 18, 2021, 2:36 PM

  just check this and let me know what does it alert

  1. success: function(data) {      
  2.                       var items = data.d.results;      
  3.   
  4.             alert(items.length);  
  5.   
  6.                },      

  I guess, you are getting null here. 
• 

  Prem M5y agoPosted Jun 18, 2021, 2:34 PM

  No, I did not get any error.

   

  Update the code both in Chrome and Edge. Still no luck
• 

  Prem M5y agoPosted Jun 18, 2021, 2:28 PM

  I also had below source code, which was updating the counts, but recently this does not gives the count.

   

  See below code:

   

  1.   
  2. "text/javascript" src="http://teams.eeoon.com/corp/title/sitename/js_css/jquery.SPServices-0.7.2.min.js">  // have uploaded jquery 0.7.2 version to site documents  
  3. "javascript" type="text/javascript">  
  4.   
  5.  $(document).ready(function() {  
  6.   $().SPServices({  
  7.     operation: "GetListItems",  
  8.     async: false,  
  9.     listName: "Learning",  
  10.     viewName: "{f32a491f-d9c5-4c22-b0b5-3bf868290286}", // this is the view ID  
  11.     CAMLViewFields: "",  
  12.      completefunc: function(xData, Status) {  
  13.             itemCount1 = $(xData.responseXML).SPFilterNode("rs:data").attr("ItemCount");  
  14.         }  
  15.     });  
  16.         var cmpl = itemCount1  
  17.         
  18.         $("#Completed").append(cmpl);  
  19.                       
  20.       });  
  21.   
  22.   
  23.   
  24.   
  25. 
        
  26. "500"  cellpadding="0px" cellspacing="5px" style="border:0px solid #fff;line-height:20px;margin-left:2px;border-collapse:separate !important;">  
  27.    "#FFFFFF" >  
  28.   
  29.     "15%" align="center" valign="middle" style="padding:10px;color: white;font-size:14px;border:0px solid #ccc;font-weight:bold; background:#0bbc00;" id="Completed">Completed - "Completed">  
  30.     
  31.   

  Below is the output, that I'm getting;

   

   
• 

  Vaibhav Chauhan5y agoPosted Jun 18, 2021, 2:24 PM

  Can you see any error in browser console like:

   

  $ is not defined... ?

   
• 

  Prem M5y agoPosted Jun 18, 2021, 1:58 PM

  Still no Luck:

  1. function getCount(status) {      
  2.         //console.log(category);      
  3.         var listName = "Learning";      
  4.         var query = "$filter=(Status eq '" + status + "')";      
  5.         var url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('" + listName + "')/items?" + query;      
  6.       
  7.            
  8.         $.ajax({      
  9.                 url: http://teams.etn.com/corp/sitename/Lists/Learning,      
  10.                 method: "GET",      
  11.                 async: false,      
  12.                 headers: {      
  13.                         "Accept": "application/json; odata=verbose"      
  14.                 },      
  15.                 success: function(data) {      
  16.                        var items = data.d.results;      
  17.                  $(".card-header").html(items.length);      
  18.                 },      
  19.                 error: function(data) {      
  20.                         failure(data);      
  21.                 }      
  22.         });      
  23.       

  1. }   
• 

  Sachin Singh5y agoPosted Jun 18, 2021, 1:33 PM

  test this

  1. function getCount(status) {    
  2.         //console.log(category);    
  3.         var listName = "Learning";    
  4.         var query = "$filter=(Status eq '" + status + "')";    
  5.         var url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('" + listName + "')/items?" + query;    
  6.     
  7.          
  8.         $.ajax({    
  9.                 url: url ,    
  10.                 method: "GET",    
  11.                 async: false,    
  12.                 headers: {    
  13.                         "Accept": "application/json; odata=verbose"    
  14.                 },    
  15.                 success: function(data) {    
  16.                        var items = data.d.results;    
  17.                  $(".card-header").html(items.length);    
  18.                 },    
  19.                 error: function(data) {    
  20.                         failure(data);    
  21.                 }    
  22.         });    
  23.     
  24. }    

  Note:- siteurl= url here 
• 

  Prem M5y agoPosted Jun 18, 2021, 1:30 PM

  below are the items that we can see to my SP list:

   

   
• 

  Sachin Singh5y agoPosted Jun 18, 2021, 1:22 PM

  are you getting items.length= something? are you sure? I mean does your URL return the items?
• 

  Prem M5y agoPosted Jun 18, 2021, 1:18 PM

  Had already tried updating the code as provided by you, but still no luck.
• 

  Sachin Singh5y agoPosted Jun 18, 2021, 12:56 PM

  modify the getCount function as

  1. function getCount(status) {  
  2.         //console.log(category);  
  3.         var listName = "Learning";  
  4.         var query = "$filter=(Status eq '" + status + "')";  
  5.         var url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('" + listName + "')/items?" + query;  
  6.   
  7.         getListItems(url, function(data) {  
  8.                 var items = data.d.results;  
  9.                 $('.card-header').html(items.length);  
  10.         });  
  11.   
  12. }  

   
• 

  Prem M5y agoPosted Jun 18, 2021, 12:50 PM

  Hi Viabhav,

   

  I did checked all the library codes in the browser, which appears to be HTML code.

   

  But I'm still not able to achieve the actual output.

   

  By any chance, could you please provide me a handy code, which will give me the status count based on Status column. (similar to the sceen shot I'd shared)

   

  Aplogize, but I'm not expert in writing codes.
• 

  Vaibhav Chauhan5y agoPosted Jun 17, 2021, 1:12 PM

  Correct.

   

  Also you need to check every library you have added in the code. It should be accessible in html code.

   

   

   Please Accept Answer if it helps you 
• 

  Prem M5y agoPosted Jun 17, 2021, 1:07 PM

  Hi Vaibhav,

   

  I'm not too good into writing codes

   

  Do you mean to replace below:

  1. "text/javascript" src="/corp/sitename/js_css/jquery-3.3.1.js">  

   with: 

  1. "https://ajax.googleapis.com/ajax/libs/js_css/jquery-3.3.1.js">  

   
• 

  Vaibhav Chauhan5y agoPosted Jun 17, 2021, 12:25 PM

  Please verify the Jquery and other library path by accessing it in browser tab.

  Use below code CDN path for jquery and search for other libraries CDN.