jquery DataTables.net plugin: how to ignore specific rows when sorting

Question

After a long exhausting search, I have found no answer to my question anywhere. Basically I have dynamically creating a table based on inputs by a user and also inserting a row with only a button after every 4th entry in the table. What I need is for the sorting function to ignore the rows with the button and leave them in place while sorting the rest of the table. Does anyone know if this is even possible?

Could you post the markup & JQuery? Maybe a JSFiddle? :)

Mathew Thompson
– Mathew Thompson

2012-04-27 20:47:35 +00:00
Commented Apr 27, 2012 at 20:47 — Mathew Thompson
– Mathew Thompson, Commented Apr 27, 2012 at 20:47

Alfred · Accepted Answer · 2012-08-17 17:37:51Z

1

You don't - what to do is use DataTables fnDrawCallback to insert your fourth row on each draw. DataTables will always empty the <tbody> element on each draw, so this would be required anyway.

edited Aug 17, 2012 at 17:37

Alfred

21.5k64 gold badges175 silver badges258 bronze badges

answered Apr 27, 2012 at 22:13

Allan Jardine

5,5315 gold badges33 silver badges34 bronze badges

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

1 Comment

user1361962 Over a year ago

Thank you so much, only problem now is it puts the entries at the end of the table instead of in the appropriate spots. Code is as follows:

"fnDrawCallback": function (oSettings) {     var rows = $('.searchResultRow');     rows.each(function (index) {      if (index == 4 || index == 9) {        var insertLearn = $("<tr></tr>").addClass("searchResultRow ");        insertLearn.append(buildCell().attr('colspan', 9).html("<img     src='../img/LearnMoreAnimated_v1-1.gif' />"));         $("#results_table > tbody").append(insertLearn);     } });

user1361962 · Accepted Answer · 2012-04-30 16:27:53Z

1

"fnDrawCallback": function (oSettings) {                  }
                    var rows = $('.searchResultRow');

                    rows.each(function (index) {

                        if (index == 4 || index == 9) {
                            var insertLearn = $("<tr></tr>").addClass("searchResultRow ");

                            insertLearn.append(buildCell().attr('colspan', 9).html("<img src='../img/LearnMoreAnimated_v1-1.gif' />"));

                            $("#results_table > tbody > tr").eq(index).after(insertLearn);
                        }

                    });
                }

was how I was able to get it....thanks for the help in pointing me in the right direction.

answered Apr 30, 2012 at 16:27

user1361962

251 silver badge7 bronze badges

Collectives™ on Stack Overflow

jquery DataTables.net plugin: how to ignore specific rows when sorting

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related