DataTable paging issue
DataTable paging issue
I have a web page with a table that displays data from a database. There is a main being displayed and an additional that is hidden and only displays with jquery when the user clicks a button that is on the first main .
The problem that I am getting is when I use the datatables plugin, it finds all the rows and counts them, so I have 11 rows of data and 11 additional hidden rows under each main row. It then displays at the button of the table "Showing 1 to 10 of 22 entries". I don't want Datatables to count or see the hidden rows. Is there a way to fix this problem.
The problem that I am getting is when I use the datatables plugin, it finds all the rows and counts them, so I have 11 rows of data and 11 additional hidden rows under each main row. It then displays at the button of the table "Showing 1 to 10 of 22 entries". I don't want Datatables to count or see the hidden rows. Is there a way to fix this problem.
This discussion has been closed.
Replies
Having said that, there is a workaround - use a bit of jQuery / Javascript before the table is initialised and remove the hidden rows, then reattach them with fnDrawCallback. A bit nasty, but that's the only way to do it with DataTables at the moment.
Allan