数据表，Javascript和Json

Question

I have a Django Python webapp , i have a function :

def showreport(newrequest) :
        rep1 = get_report_data(newrequest,2)
        data={['columns':rep1[0],'rows':rep1[1]}
        return JsonResponse(data,safe=False)

i call this function from javascript in HTML page , the data return is an array with two elements, 1 represent columns and the other the data.

I want to present in the HTML page the data in a DataTable object , and since the columns and data is dynamic i want to create the DataTable dynamically

In the HTML

In JavaScript $(document).ready(function () {

 $("#showresults").on('click', function(evt) {
  evt.preventDefault();
 $('#show_loading').show();
$('#theTable').hide();
froms = document.getElementById('startdate').value;
tos = document.getElementById('todate').value;        
    $.ajax({
            type: "POST",
            url: 'showreport',
            data: {
                'start_date' : froms,
                'end_date' :tos,
                   'csrfmiddlewaretoken': '{{ csrf_token }}'
            },
            success: function (data, textStatus, jqXHR) {

               $('#show_loading').hide();          
   var rowSet=data['rows'];
 var columnset =data['columns'];

       $('#theTable').DataTable({
    "processing": true,
    searching: false,
    paging: false,
   "bInfo" : false,
 columns:  [columnset]  ,
    data: [rowSet]
   } ); 
$('#theTable').show();

            },
            error: function (XMLHttpRequest, textStatus, errorThrown) {
                $('#show_loading').hide();
                alert("Error, please try again!");
            }
});  
        });    

    });

Now the problem i have is that the Columns are not presented and the data is presenting only 1 row and it is not separated to columns.

In inspect mode , i can see {"rows": [["Test1", "Test2"],["Test3", "Test4"] etc..., "columns": ["col1","col2"]}

What am i doing wrong.

Thanks, N

Answer 1

I think you have an array of an array :)

try

change this

columns: [columnset],
data: [rowSet]

to this

columns: columnset,
data: rowSet