Answers

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

  April 2020 edited April 2020

  I don't think "data": JSON.parse(JSON.stringify("{{ table }}")), is going to work. There seems to be a few things wrong with this statement. I've not tried rendering data into the Javascript portion of the page this way so I'm not sure how it would work. I use Flask not Django and with my pages I have a route that renders the HTML page then another route that handles fetching the data via Ajax. I would do something like this:

  from django.shortcuts import render, redirect, reverse, render_to_response
  from .models import rt_reg_res
  from django.http import HttpResponse, JsonResponse
  
  def units(request):
      """Return webpage"""
      return render(request, 'runtime.html')
  
  def get_units(request):
      """Return data form ajax request"""
      #. Datatables defaults looking for the data in the `data` object
      data  ={ "data":  [
      {
        "id": "1",
        "run_date": "2020/04/24",
        "ref_vs_new": "1.72562",
        "cts_suite": "rt_cts",
        "cts_avg": "-1.5",
        "cts_tavg": "7.6",
        "cts_testcase_count": "15 / 16",
      },
      ]
  }
      return JsonResponse(data)
  

  I think Django uses JsonResponse to return JSON data.

      var b2 = $('#table_id').DataTable( {
          "ajax": "<path to server>/get_units". // Fetch data from Django route
          "columns": [
              {
                 "className":      'details-control',
                 "orderable":      false,
                 "data":           null,
                 "defaultContent": ''
              },
              { "data": "id" },
              { "data": "run_date" },
              { "data": "ref_vs_new" }
          ],
          "order": [[1, 'asc']],
      } );
  

  You may need to fix the Python code as I'm not familiar with Django syntax and methods.

  Take a look at the Data Sources docs and Ajax docs for more details.

  Kevin
• spatan01 Posts: 2Questions: 1Answers: 0

  May 2020

  Hi Kevin,

  Thank you so very much for the help, I have finally resolved the issue, and build the desired table

  I have followed Data Sources docs and get the solution there

  Once again, thank you, as your shared data helped me a lot

  Regards,
  Matso