Sorting a database js generated table

Question

I want to create a table displaying db information using ejs and nodes.js.

<table class="table table-striped table-hover" id="loaded-table">
    <thead>
        <tr>
            <th>First</th>
            <th>Second</th>
            <th>Third</th>
            <th>Fourth</th>
            <th>Fifth</th>
        </tr>
    </thead>
    <tbody>
    <% for(var i=0; i < data.length; i++) { %>
        <tr>
            <td> <%= data[i].prsnl_firstName %> </td>
            <td> <%= data[i].prsnl_lastName %> </td>
            <td> <%= data[i].prsnl_city %> </td>
            <td> <%= data[i].prsnl_email %> </td>
            <td> <%= data[i].prsnl_age %> </td>
        </tr>
    <% } %>
    </tbody>
</table>

But I also want it to be sortable. Like in wikipedia, where you click on one of the th and the table is sorted by that column. The problem is, trying to use a jquery plugin doesn't work because the table is literally none existent at the moment of executing the code. Is there a way to do so?

Sergio Rivas · Accepted Answer · 2016-09-17 13:30:57Z

1

Ok, you can use your JQuery plugin (Example http://tablesorter.com/docs/), but you have to make sure you execute the sortable behavior after the table is created, you have to scenarios:

1) The table is created when the page is rendered, for this case you will need run using document on ready

$(document).ready(function(){ 
       $("#myTable").tablesorter(); 
});

2) If your table is created after some trigger, just run $("#myTable").tablesorter(); or equivalent after the trigger.

answered Sep 17, 2016 at 13:30

Sergio Rivas

5633 silver badges9 bronze badges

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

1 Comment

user3187759 Over a year ago

I'm sorry, something isn't working. when i do it with a normal table it works but for a generated table, it shows the table but doesn't do anything

Collectives™ on Stack Overflow

Sorting a database js generated table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related