aData is undefined

最新推荐文章于 2023-09-06 15:17:30 发布

原创最新推荐文章于 2023-09-06 15:17:30 发布 · 401 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#aData #datatable

datatable 专栏收录该内容

9 篇文章

订阅专栏

本文讨论了在Django应用中使用jQuery DataTables进行AJAX源数据加载时遇到的aData is undefined错误，并提供了解决方法。通过调整JSON响应格式和回调函数参数，可以确保数据正确呈现。

{"aaData": [["blah1", "blah2", "blah3"]]}

详情看；：

Django jquery datatable “aData is undefined” error

up vote 0 down vote favorite

I try to implement jquery datatable ajax-source usage in Django however have some problems. The ajax call is working great and get the response however after that aData is undefined error is raised in javascript.

What would be the problem ?

These are what I have so far.

views.py

def model_history(request):
    o = Model.objects.get(id=request.GET["pk"])
    items_list = list(o.lastupdate_set.all().values())
    return HttpResponse(simplejson.dumps(items_list),'application/json')

    function viewModelHistory(pk){
        url1 = "/model/history/?pk="+pk;

        $('#history').dataTable( {
            "bProcessing": true,
            "bServerSide": true,
            "sAjaxSource": url1,
            "fnServerData": function ( sSource, aoData, fnCallback ) {
              $.ajax( {
                "dataType": 'json',
                "type": "POST",
                "url": sSource,
                "data": aoData,
                "success": fnCallback
              } );
            }
          } );
}

listmodel.html

<table id="history">
                    <thead>
                        <tr>
                            <th>col1</th>
                            <th>col2</th>
                            <th>col3</th>
                            <th>col4</th>
                            <th>col5</th>
                        </tr>
                    </thead>
                    <tbody>
                    </tbody>
                </table>

asked Apr 29 '12 at 22:23

brsbilgic
1,808 4 22 58

What does fnCallback do and what parameters does it expect? – ilvar Apr 30 '12 at 4:31

add a comment

2 Answers

active oldest votes

up vote 3 down vote

It looks like you have an issue with the format of your JSON structure. jquery.datatables expects it to look something like

{"aaData": [["blah1", "blah2", "blah3"]]}

If your JSON looks like

[["blah1", "blah2", "blah3"]]

In your view.py you need to wrap your item_list in a dictionary like so:

items_list_dict = {}
items_list_dict.update({'aaData': items_list})
return HttpResponse(simplejson.dumps(items_list_dict),'application/json')

answered May 24 '12 at 21:12

Matt
31 2

add a comment

up vote 0 down vote

It will be helpful to post your JSON output, but I assume it looks like this:

[["key":"val"],["key":"val"]]

if so you need to remove your keys from the json. Datatables expects json like this:

[["val"],["val"]]

One thing you can do is make a list of list from your query

my_json = []
for item_list in items_list:
    a = [item_list.xxx_column_name_xxx]
    my_json.append(a)

items_list_dict = {}
items_list_dict.update({'aaData': my_json})
data = json.dumps(items_list_dict)

return HttpResponse(data, mimetype='application/json')

answered Apr 21 '13 at 5:35