Answers

• kthorngren Posts: 20,252Questions: 26Answers: 4,761

  February 2020

  There is nothing obvious. But you don't show how you are loading the table. Datatables might not know about the data you are loading. Please let us know the method you are using to populate the table.

  Kevin
• markmnei Posts: 3Questions: 1Answers: 0

  February 2020 edited February 2020

  Hello

  Thank you for the reply. I am using Django with Jinga2. The table and the data shows up fine. It just whtn I type something obvious (some I know in the table) ... it say **** No matching records found ****. When I click on the column head, no sorting action happens.

  The table is relatively large large ... 1803 records. But it does aopload fast and all records are shown on the page.

  Please advise if you see something off in my setup.

  Thank you again

                <div>
                  <table class="display" style="width:100% ; font-size: x-small"
                         id="mytable">
                      <thead>
                      <tr>
                          <th scope="col">#</th>
                          <th scope="col">fld1</th>
                          <th scope="col">fld2</th>
                          <th scope="col">fld3</th>
                          <th scope="col">fld4</th>
  .
  .
  .
                      </tr>
                      </thead>
                      {% for item in merge_df %}
                          <tbody>
                          <tr>
                              <td>{{ forloop.counter }}</td>
                              <td>{{ item.fld1}}</td>
                              <td>{{ item.fld2}}</td>
                              <td>{{ item.fld3}}</td>
                              <td>{{ item.fld4}}</td>
  ..
  ..
                          </tr>
                      {% endfor %}
                      </tbody>
                  </table>
  

  Edited by Kevin:  Syntax highlighting. Details on how to highlight code using markdown can be found in this guide
• kthorngren Posts: 20,252Questions: 26Answers: 4,761

  February 2020 Answer ✓

  Please use Markdown code formatting so we can see your code correctly.

  Is your table built and loaded before you initialize Datatables? If it comes after then Datatables won't know about the data loaded into the table. Please post a link to your page or a test case replicating the problem so we can take a look.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin
• markmnei Posts: 3Questions: 1Answers: 0

  February 2020

  I identified the problem. Adding this:

      var n = document.createElement('script');
      n.setAttribute('language', 'JavaScript');
      n.setAttribute('src', 'https://debug.datatables.net/debug.js');
      document.body.appendChild(n);
  

  helped me figure out where the problem is.