Answers

• zeinerrj Posts: 11Questions: 1Answers: 2

  August 2015

  Hello haseeb293,

  I'm not sure what you're trying to do. If the table has five rows then that is what a user should see so you don't confuse them.

  However, if you what to give them additional information, such as there are three rows that are special, you might want to try:

  <script>
    var counter = 0;
    $(document).ready( function() {
      $("#exampleTable").DataTable();
  
      $("#exampleTable).rows().every( function() {
        if( $(this).hasClass( "<class name>" ) counter++;
      }
  });
  </script>
  

  Then you just display the counter information.

  Hope this helps.
• haseeb293 Posts: 3Questions: 1Answers: 0

  August 2015

  zeinerrj, the thing is that there are some rows with no data in them and rows which i do not want to get added in the counter. The text you see "showing 1 of N records" and on filtering "showing 1 of N records" this must be calculating all of the rows inside the <tbody> tag. But i want my N to be equal to what i specify this can be a static number or count of rows which has a class named "dataRows".

  Is there any option or setting which could simply set the number of records?
• haseeb293 Posts: 3Questions: 1Answers: 0

  August 2015

  The following table has 5 rows, now the usual setup of datatables will show total records as 5 and if you will search for 20 it will show two records filtered out of 5 records. Now what i need is to count the rows with class "dataRow" and set is as the total records in the table in datatables setup so that it may show "Showing 1 to 3 of 3 entries" NOT "Showing 1 to 3 of 5 entries"and on filtering "20" it shows "Showing 1 to 2 of 2 entries (filtered from 3 total entries)" NOT "Showing 1 to 2 of 2 entries (filtered from 5 total entries)"

  <table>
      <thead>
          <tr>
              <th>Serial Number</th><th>Name</th><th>Age</th>
          </tr>
      </thead>
      <tbody>
          <tr class="dataRow">
              <td>1</td><td>User1</td><td>20</td>
          </tr>
          <tr class="dataRow">
              <td>2</td><td>User2</td><td>20</td>
          </tr>
          <tr class="emptyRow">
              <td></td><td></td><td></td>
          </tr>
          <tr class="dataRow">
              <td>3</td><td>User3</td><td>25</td>
          </tr>
          <tr class="emptyRow">
              <td></td><td></td><td></td>
          </tr>
      </tbody>
  </table>
  

  I have also added this to the DataTables live here is the link: http://live.datatables.net/vafejoni/1/.
• vmaldosan Posts: 1Questions: 0Answers: 0

  August 2015

  Hi, I'd like to know this, too, since it would be useful when the data is retrieved by an external service that already pages the result. So I can show the total number of results instead of the page length the service is using.
  Is there a way to update the total number of records on a dataTable without altering the data itself?