Search

14 Sat, December 28th, 2013 Melinda Salas Molestie Sed

system, or "School results 2013-2014" in a news article.

using DataTables in SharePoint 2013 for a variety of

the list of SharePoint 2013 on premise version. 2

pages within SharePoint Online 2013 because it does not

DataTables on a SharePoint 2013 page, and wanted to

after sort) April 1, 2013, 6:24 p.m. April 2,

Hi, I used the following code inside a function where I initialize the table. Hopefully this will help you: $.ajax({ method: 'GET', url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('Personas')/items?$select=Title,Nombre,Paterno,Materno,Identificacion&$top=20000", headers: {'Accept' : 'application/json; odata=verbose'}, success: function(data) { $('#tblMyHTMLTable').DataTable({ "bDestroy": true, "bProcessing": true, "aaData" : data.d.results, "aoColumns" : [ { "mData": "YourTableField1" }, { "mData": "YourTableField2" }, { "mData": "YourTableField3" } ] }); } });

I resolved the issue. I changed: $('#example').dataTable( to $('#exa').dataTable( so that it matches my table ID. Thanks again!

hello has anyone used data tables to check for empty fields(send all the empty field to a column in the table) in your list and then render to aspx page. Previously this one was done using xsl and the data view web part

Hi, I have selected all checkboxes and now trying with below code to get selected checkbox data but it only returns the data which page is opened at that time like If I clicked on 1st page it will return only 1st page selected checkbox data. $('#aspnetForm').on('submit', function(e){ debugger; var form = this; var email=new Array(); // Iterate over all checkboxes in the table $('#CustomerRecordsTable ').DataTable().$('input[type="checkbox"]').each(function(){ // If checkbox doesn't exist in DOM if($.contains(document, this)){ // If checkbox is checked if(this.checked){ debugger; //var val1= $(this).closest('tr').find('td:eq(6)').text(); email.push($(this).closest('tr').find('td:eq(1)').text()); } } }); $.each(email,function(key, value) { alert(key +" : "+value) }); });

Please help on how to use scrolly right. function LoadProtocolDocuments() { var call = $.ajax({ url: _spPageContextInfo.webAbsoluteUrl + "/_api/Web/Lists/GetByTitle('current%20studies')/items?$select=BaseName,FileRef,PROTOCOL/Title,SITE/Title,Editor/Name,*&$expand=PROTOCOL,SITE,Editor&$Top=2000", deferRender: true, scrollY: 200, scrollCollapse: true, scroller: true, initComplete: function () { this.api().row( 1000 ).scrollTo(); }, serverSide: true, responsive: true, type: "GET", dataType: "json", headers: { Accept: "application/json;odata=verbose" } }); call.done(function (data,textStatus, jqXHR){ $('#example').dataTable({ "bDestroy": true, "bProcessing": true, deferRender: true, scrollY: 200, scrollCollapse: true, scroller: true, initComplete: function () { this.api().row( 1000 ).scrollTo(); }, "aaData": data.d.results, "aoColumns": [ { "mData": "BaseName" }, { "mData": "PROTOCOL" }, { "mData": "SITE" }, { "mData": "Modified" }, { "mData": "Editor" }, { "targets": 0, "data": "FileRef", "render": function (data, type, full, meta) { return '<a href="' + data + '">View</a>'; } }, ], fixedColumns: false }); }); call.fail(function (jqXHR,textStatus,errorThrown){ alert("Error retrieving Tasks: " + jqXHR.responseText); }); } // A $( document ).ready() block. $( document ).ready(function() { LoadProtocolDocuments(); $(".col-md-4").hide(); });