jQuery DataTables fnRender Increment Column

Question

I'm trying to create a row inside my datatable that increments +1 each row. I've been told the easiest way to do this would be using fnRender. Now I've used fnRender to change data that's already in a column from the serverside processor, but never to create a new column alone.
Any help would be awesome!

Here's my current code:

oTable = $('#testingz').dataTable({
    "bProcessing": true,
    "bServerSide": true,
    "bJQueryUI": true,
    "sPaginationType": "full_numbers",
    "aaSorting": [ [1,'desc'] ],
    "sDom": '<""l>rt<"F"fp>',
        "sAjaxSource": "server_processing.php",
        "aoColumnDefs": [ 
            {
                "fnRender": function ( o, val ) {
                return '<a href="http://honedge.com/' + o.aData[0] + '">' + o.aData[0] + '</a>';
                },
                "aTargets": [ 0 ]
            }
        ]
});

not 100% sure what you are asking. Would adding var ctr=0; above oTable and then ctr++ inside fnRender not do what you need? — charlietfl
– charlietfl, Commented Jun 16, 2012 at 0:32

Allan Jardine · Accepted Answer · 2012-06-16 08:21:38Z

1

Do you mean something like this: http://datatables.net/release-datatables/examples/api/counter_column.html

answered Jun 16, 2012 at 8:21

Allan Jardine

5,5315 gold badges33 silver badges34 bronze badges

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

3 Comments

Kevin Murphy Over a year ago

Essentially this is what I need, I just need the numbers to stay "attached" to a certain row regardless of sorting and searching. It's used to give a rank to a player when it's initially grabbed from the database, so the first person would be rank 1. In that example, no matter the case, the first row is always indexed as 1. Say the 35th person has an index of 35. If i were to search for that player with a username, his index would read 1. I need it to read 35 no matter what :P

Allan Jardine Over a year ago

In which case, rather than using fnDrawCallback as my example does - just loop over the data updating it with the column index once at initialisation time.

Kevin Murphy Over a year ago

Sounds exactly like what I want to do- i just have no clue how to... Silly me.

Collectives™ on Stack Overflow

jQuery DataTables fnRender Increment Column

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related