Search

@app.route('/get_table_data', methods=['POST']) def get_table_data(): cnx = mariadb.connect(user='root', password='', database='test') cursor = cnx.cursor() cursor.execute("SELECT I

@app.route('/get_table_data', methods=['POST']) def get_table_data(): result = process_request() #process request and save in result return jsonify(result) #return JSON string

@allan, I noticed this comment in the Server Side docs for the data return parameter:

https://datatables.net/manual/server-side#Returned-data

I think the problem is that you are not returning the data correctly. According to the server side doc you need to return the following parameters: draw, recordsTotal, recordsFiltered and data.

I presume that the error is happening for the #returnsDueByStateTable table? The reason for that is that the data being returned from the server for each row is in the format:

I noticed you have "files":[] in the JSON response. Not sure if that is the source of the unknown field error. 'files` is not one of the required or optional fields that server side is ex…

https://datatables.net/manual/server-side#Returned-data

According to the documentation here https://editor.datatables.net/manual/php/getting-started#Return-data, you can access the data before json_encoding it. There is no further mention of how to access

I've just seen this post, that solves my problem: https://datatables.net/manual/server-side#Returned-data

Yes, use DT_RowClass. See the documentation here.

Based on this server-side#Returned-data, there don't seem to be a way i can modified the pages listing.

Do you mean you want to add a draggable attribute to the tr elements? If so, createdRow or rowCallback is the correct way to do it.

http://editor.datatables.net/manual/php/getting-started#Return-data

Per the forum rules, please link to a test case showing the issue.

You can use the DT_RowClass property to have DataTables automatically add a class to a row (documentation - that page is about server-side processing, but the DT_RowId, etc, parameters will work for …

<div id="return"></div> ~~~~~ $(document).ready(function (e) { $("#uploadForm").on('submit',(function(e) { e.preventDefault(); $.ajax({

Yes - recordsFiltered is not the page length. It would be worth reading over the documentation for those parameters:

Excellent suggestion - and the manual was certainly wrong! Thanks for pointing this out!

"recordsTotal": 17, "recordsFiltered": 10,