Rails : Rails 3 dataTables TypeError: Object [object Object] has no method 'dataTable'

Question

I have a table which has been rendered in my view as shown below:

<table border="1", id="pretty" class="tablesorter">
    <thead>
    <tr>
        <th>LeaveID</th>
        <th>Student ID</th>
        <th>Leave Start Date</th>
        <th>Leave End Date</th>
        <th>Leave Reason</th>
        <th>Leave Duration</th>
        <th>Academic Response</th>
        <th>Warden Response</th>
        <th>Leave Status</th>
    </tr>
    </thead>
    <% @leaves.each do |leave| %>
    <tbody>
    <tr>
        <td><%= link_to leave.leave_id_prefix+(leave.leave_id).to_s()+'/'+leave.academic_session, generateReport_path(:id_param => leave.student_id) %><br></td>
        <td><%= leave.student_id %></td>
        <td><%= leave.leave_from %><br></td>
        <td><%= leave.leave_to %><br></td>
        <td><%= leave.leave_reason %><br></td>
        <td><%= leave.leave_duration %></td>
        <td><%= leave.academic_status %></td>
        <td><%= leave.warden_status %></td>
        <td><%= leave.status%></td>
    </tr>
    </tbody>
    <% end %>

</table>

and JavaScript in the View is as shown below to make the rendered table a dataTable.

    <script>
      $(document).ready(function(){
          $("#pretty").dataTable();
      });
    </script>

I have followed the Ryan Bates' Railcasts http://railscasts.com/episodes/340-datatables?view=asciicast for this purpose.

I have also downloaded the required js and css files to my app.

But I always get this error of

    TypeError: Object [object Object] has no method 'dataTable'

How should I go about it.. Any insight will be welcomed..!

make sure jquery is loaded first and then your datatable js... — bipen
– bipen, Commented Mar 8, 2013 at 10:59
thanks @bipen but it seems dataTable is not working properly.. I am not able to sort the data or search through data.. Do i have to add something into dataTable function.? — ph3n0m_aks
– ph3n0m_aks, Commented Mar 8, 2013 at 11:14
@ph3n0m_aks have you found any solution to your problem? I am getting the same error as you. — DoodleKana
– DoodleKana, Commented Apr 2, 2014 at 15:51

Denim Datta · Accepted Answer · 2013-11-13 12:36:00Z

1

Make sure your Jquery files is above and called before the following code

<script>
   $(document).ready(function(){
       $("#pretty").dataTable();
   });
</script>

edited Nov 13, 2013 at 12:36

Denim Datta

3,8124 gold badges30 silver badges53 bronze badges

answered Nov 13, 2013 at 12:15

gideonlouw

111 bronze badge

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

1 Comment

DoodleKana Over a year ago

I am loading jquery-1.9.0.js before jquery.dataTables.js (1.1 beta) still getting this same error.

sjain · Accepted Answer · 2013-03-08 11:54:16Z

0

UPDATE:

Just found the error in your code:

Replace

<table border="1", id="pretty" class="tablesorter">

with

<table id="pretty" border="1" class="tablesorter">

edited Mar 8, 2013 at 11:54

answered Mar 8, 2013 at 11:45

sjain

23.4k30 gold badges115 silver badges190 bronze badges

2 Comments

ph3n0m_aks Over a year ago

i am using 1.9.2, and it's working fine.. But I am not able to incorporate the sort, searching capability of dataTables onto my table.. any ideas there??

ph3n0m_aks Over a year ago

it's still not working.. I am not able to paginate or sort or filter any data from my datatable. I dunno where I am going wrong..!

bpeterson76 · Accepted Answer · 2013-05-07 16:00:26Z

0

make sure you load your jquery script first and the dataTables js script later...

for sorting

Using the aaSorting initialization parameter, you can get the table exactly how you want to present the information.

 $('#example').dataTable( {
    "aaSorting": [[ 4, "desc" ]]
});

you can go thorugh the documentation here

edited May 7, 2013 at 16:00

bpeterson76

12.9k6 gold badges51 silver badges82 bronze badges

answered Mar 8, 2013 at 11:20

bipen

36.6k9 gold badges51 silver badges62 bronze badges

Comments

Sampat Badhe · Accepted Answer · 2014-07-07 09:40:43Z

0

your <tbody> tag should be out of loop, this creates of <tbody> for each <tr>, In this case dataTable will not work.

<tbody>
  <% @leaves.each do |leave| %>
    <tr>
      <td><%= ..... %></td>
      <td><%= ..... %></td>
      <td><%= ..... %></td>
      <td><%= ..... %></td>
      <td><%= ..... %></td>
    </tr>
  <% end %>
</tbody>

answered Jul 7, 2014 at 9:40

Sampat Badhe

9,1057 gold badges40 silver badges53 bronze badges

Collectives™ on Stack Overflow

Rails : Rails 3 dataTables TypeError: Object [object Object] has no method 'dataTable'

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related