Hello,
I'm using below code (googled), to get the count from Status column. But this is not displaying the count.
<script type="text/javascript" src="/corp/sitename/js_css/jquery-3.3.1.js"></script> <script type="text/javascript" src="/corp/sitename/js_css/jquery.dataTables.min.js"></script> <script type="text/javascript" src="/corp/sitename/js_css/dataTables.bootstrap4.min.js"></script> <script type="text/javascript" src="https://cdn.datatables.net/select/1.2.5/js/dataTables.select.min.js"></script> <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"></script> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/pdfmake.min.js"></script> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/vfs_fonts.js"></script> <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.html5.min.js"></script> <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.print.min.js"></script> <link rel="stylesheet" href="/corp/sitename/js_css/bootstrap.css"/> <link rel="stylesheet" href="/corp/sitename/js_css/dataTables.bootstrap4.min.css"/> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css"/> <style> </style><script> $(document).ready(function() { getCount('Not-Started'); getCount('In Progress'); getCount('On-Hold'); getCount('Completed'); getCount('Cancelled'); $('.card-header').each(function() { $(this).prop('Counter', 0).animate({ Counter: $(this).text() }, { duration: 1500, easing: 'swing', step: function(now) { $(this).text(Math.ceil(now)); } }); }) }); function getCount(status) { //console.log(category); var listName = "Learning"; var query = "$filter=(Status eq '" + status + "')"; var url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('" + listName + "')/items?" + query; getListItems(url, function(data) { var items = data.d.results; $('#' + status).text(items.length); }); } function getListItems(siteurl, success, failure) { $.ajax({ url: siteurl, method: "GET", async: false, headers: { "Accept": "application/json; odata=verbose" }, success: function(data) { success(data); }, error: function(data) { failure(data); } }); } </script> <div class="container"> <div class="card-deck"> <div class="card t1"> <div class="card-header" id="Not-Started" style="width: 100%;">0</div> <div class="card-body"> <h5 class="card-title"> <i class="fa fa-ban"></i> Not-Started</h5> </div> </div> <div class="card t2" style="width: 400px;"> <div class="card-header" id="In Progress" style="width: 100%;">0</div> <div class="card-body"> <h5 class="card-title"> <i class="fa fa-clock-o"></i> In Progress</h5> </div> </div> <div class="card t3"> <div class="card-header" id="On-Hold" style="width: 100%;">0</div> <div class="card-body"> <h5 class="card-title"> <i class="fa fa-pause-circle-o"></i> On-Hold</h5> </div> </div> <div class="card t4"> <div class="card-header" id="Completed" style="width: 100%;">0</div> <div class="card-body"> <h5 class="card-title"> <i class="fa fa-check"></i> Completed</h5> </div> </div> <div class="card t5"> <div class="card-header" id="Cancelled" style="width: 100%;">0</div> <div class="card-body"> <h5 class="card-title"> <i class="fa fa-close"></i> Cancelled<br/></h5> </div> </div> </div> </div>
My SharePoint List is named as "Learning". And I have below choice options in Status column:
Not-Started In Progress On-Hold Completed Cancelled
I;m getting the output as below, but no count.