How to return HTML object on server side processing for dataTable jQuery?

Question

My point is... i have a dataTable with over 20k records, so i'm server side processing it, so the user browser stays sharp.

But, i have buttons i must 'assembly' to edit, remove or activate some records, and when i try to put html on the return of the server side processing, i get an error from dataTable, even if my json is well formatted...

so, what can i do?

I've tried using fnDrawCallback, but it runs after the data placement on the table.

Thanks in advance, Jorge Ferrari.

If you want to run callback before data placement, try fnPreDrawCallback — alpakyol
– alpakyol, Commented Mar 28, 2014 at 13:09

markpsmith · Accepted Answer · 2014-03-28 13:24:44Z

2

If I understand correctly, you can build html controls using mRender in your column definitions. I have used this to create edit links on each datatable row using a value returned by the json data as a dynamic parameter:

    'aoColumns': [
                 {
                  'mRender': function (data, type, row) {
                           var EditLinkText = ' |<a href=\'Edit/' + row[10] + '\'>Edit</a>';
                           return EditLinkText;
                  }
             }
           ]

answered Mar 28, 2014 at 13:24

markpsmith

4,9182 gold badges38 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jorge Ferrari · Accepted Answer · 2014-03-28 13:09:58Z

1

I just find out how i may do it.

i can use the fnServerData.. here's an example

// POST data to server
$(document).ready( function() {
  $('#example').dataTable( {
    "bProcessing": true,
    "bServerSide": true,
    "sAjaxSource": "xhr.php",
    "fnServerData": function ( sSource, aoData, fnCallback, oSettings ) {
       oSettings.jqXHR = $.ajax( {
    "dataType": 'json',
    "type": "POST",
    "url": sSource,
    "data": aoData,
    "success": fnCallback
      } );
    }
  } );
} );

answered Mar 28, 2014 at 13:09

Jorge Ferrari

1523 silver badges12 bronze badges

Collectives™ on Stack Overflow

How to return HTML object on server side processing for dataTable jQuery?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related