How do I add an index column to Datatable?

Question

I want to add a row number for each row in my data table. I am using plugin from http://datatables.net The page which tells how to add the index is http://datatables.net/release-datatables/examples/api/counter_column.html

... however I don't know how to actually implement it to make it work. I know extremely little about jquery / javascript which would help in this case. I don't know where to put this code to make it work (if it helps i am also using Ruby on Rails)

The initialization code is:

jQuery ->
  $('#staffs').dataTable
    sPaginationType: "full_numbers"
    bJQueryUI: true
    }

add your datatables initialization code.

David Stetler
– David Stetler

2012-11-05 17:50:07 +00:00
Commented Nov 5, 2012 at 17:50 — David Stetler
– David Stetler, Commented Nov 5, 2012 at 17:50

Community · Accepted Answer · 2017-05-23 12:13:47Z

3

Here is an example from datatables.net site DataTables row numbers example

$(document).ready(function() {
    $('#staffs').dataTable( {
        sPaginationType: "full_numbers",
        bJQueryUI: true,
        "fnDrawCallback": function ( oSettings ) {
            /* Need to redo the counters if filtered or sorted */
            if ( oSettings.bSorted || oSettings.bFiltered )
            {
                for ( var i=0, iLen=oSettings.aiDisplay.length ; i<iLen ; i++ )
                {
                    $('td:eq(0)', oSettings.aoData[ oSettings.aiDisplay[i] ].nTr ).html( i+1 );
                }
            }
        },
        "aoColumnDefs": [
            { "bSortable": false, "aTargets": [ 0 ] }
        ],
        "aaSorting": [[ 1, 'asc' ]]
    } );
} );

Regarding your SyntaxError: reserved word "function" on line 4 (in /home/ubuntu/ruby/scoreboard/app/assets/javascripts/staffs.js.coffee)' error

take a look at this rails, getting syntax error with coffee script

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Nov 5, 2012 at 18:18

Daniel

37.2k10 gold badges123 silver badges208 bronze badges

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

5 Comments

StanM Over a year ago

right thats copy/paste from the link I provided (i seen this code already). I just dont know where to put this code to actually make it work

Daniel Over a year ago

haven't clicked on your link... edited my answer (added your two line of code...)

StanM Over a year ago

I have tried just copying and pasting it like that before but I keep getting the error 'SyntaxError: reserved word "function" on line 4 (in /home/ubuntu/ruby/scoreboard/app/assets/javascripts/staffs.js.coffee)'

Daniel Over a year ago

start by successfully running alert('oki'); , then replace it with the code I posted above

Daniel Over a year ago

also take a look at this stackoverflow.com/q/9011103/617373 and this stackoverflow.com/q/10188363/617373 accepted answers...

David Stetler · Accepted Answer · 2012-11-05 19:02:01Z

0

jquery is javascript. You need to add the code Daniel pasted between

<script language="javascript">

and

</script>

tags.

answered Nov 5, 2012 at 19:02

David Stetler

1,46110 silver badges14 bronze badges

1 Comment

StanM Over a year ago

thank you, this would work if I was keeping this inside the html file, but what worked for me was the js2coffee converter.

Manoranjan · Accepted Answer · 2016-11-28 13:39:37Z

0

I am working with latest dataTable 1.10 and gem rails datatable and ajx for

finding the DataTable row number(Serial Number)

def data outer = [] records.each_with_index do |record, index| outer << [ # comma separated list of the values for each cell of a table row # example: record.attribute, index + 1 + params[:start].to_i, record.company_name, record.id, record.patients.count, record.revenue_total ] end outer end

answered Nov 28, 2016 at 13:39

Manoranjan

969 bronze badges

Collectives™ on Stack Overflow

How do I add an index column to Datatable?

3 Answers 3

5 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related