aData is undefined

 

 

 

{"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') js 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> ajax django jquery datatable share improve this question 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') share improve this answer 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') share improve this answer answered Apr 21 '13 at 5:35 Nikolay Christov 59 1 3       本来来源于：http://stackoverflow.com/questions/10376538/django-jquery-datatable-adata-is-undefined-error