Answers

• kthorngren Posts: 21,343Questions: 26Answers: 4,954

  November 2023 Answer ✓

  Use page.info() to get that info. Use messageTop or messageBottom as a function to get the page.info() then place it in the export where desired. See this example.

  Kevin
• badijd Posts: 9Questions: 4Answers: 0

  November 2023 edited November 2023

  Thank you kthorngren! I was able to get this to work; however, I feel there has to be something to make it a bit easier.
  In the export button I call a function:

  messageTop: exportinfo
  

  function exportinfo() {
    var table = $('#example').DataTable();
    var info = table.page.info();
      
    return table.page.info().recordsTotal;
  };
  

  This can be expanded to display the following:
  Exported 17 records

  If I am using searchPanes or Search and export the results I want to display:
  Exported 2 records (filtered from 17 total records)

  How do I capture when the view has been filtered?
• kthorngren Posts: 21,343Questions: 26Answers: 4,954

  November 2023 edited November 2023 Answer ✓

  Use recordsDisplay to determine if there are filtered records. Something like this:
  https://live.datatables.net/veluwize/1/edit

          var info = table.page.info();
          
          if (info.recordsDisplay === info.recordsTotal) {
            records = info.recordsTotal + ' entries';
          } else {
            records = info.recordsDisplay + ' entries (filtered from ' + info.recordsTotal + ' total entries)';
          }
  
          return records;
  

  Kevin
• badijd Posts: 9Questions: 4Answers: 0

  November 2023

  Thank you for the quick response. Works perfect!