Hide specific rows using the DataTables plugin?

Question

I have a webpage with a table that displays data from a database. The display shows the primary <tr>and secondary <tr>, which is hidden and is displayed only with jquery when the user presses the button located on the first primary <tr>.

The problem I get is when I use the datatables plugin, it finds all the rows and counts them, so I have 11 rows of data and 11 extra hidden rows under each main row. Then it is displayed on the button of the table "Display from 1 to 10 of 22 entries". I do not want Datatables to count or see hidden strings. I have a way to fix this problem. Everyone <tr>'shas identifiers and classes, so I thought there might be an easy way to sort this data correctly.

Also, when I click on the main <tr>one to display the hidden <tr>, it does not slide down below the main <tr>one that I clicked on, instead it goes above all the main ones <tr>'s. Does anyone know why?

Datatables Website []>

Answer 1

the query you make to count the rows should use the ": visible" attribute. Therefore, your query should look something like this:

var entries = $("tr:visible").length;