Server side searching problem

scarfeel

Hello all i got a search field from server side. I`m using Wordpress ( i integrated datatables with WP Posts and Meta Data ). The problem is, when i recieve the data i see it in Response tab, but Table is blank. Any suggestions ?

$('#example').DataTable({
                                "bSort": false,
                                "serverSide": true,
                                select: true,
                                "columnDefs": columnDef,
                                "bServerSide": true,
                                "paging": false,
                                dom: "Bfrtip",

Here is Json response filtered by my search field:

retracted

scarfeel

Bump

kthorngren

Your data looks like this:

    "data": {
        "0": {
            "DT_RowId": 197,
            "ID": 197,
            ....
            "estimated-finish": "2017-06-13",
            "date-finished": "2017-06-05"
        },
        "1": {
            "DT_RowId": 196,
            "ID": 196,
            ....
            "estimated-finish": "2017-06-12",
            "date-finished": ""
        },

I think it should be an array of objects as described here:
https://datatables.net/manual/data/#Objects

I think your JSON should look more like this:

    "data": [
        {
            "DT_RowId": 197,
            "ID": 197,
            ....
            "estimated-finish": "2017-06-13",
            "date-finished": "2017-06-05"
        },
        {
            "DT_RowId": 196,
            "ID": 196,
            ....
            "estimated-finish": "2017-06-12",
            "date-finished": ""
        },
        ....
          ]

Kevin

scarfeel

I will try it, but i think it will not work, because initial data in table ( first load when user come on page, looks exactly the same)

scarfeel

Okay, i tried it. When i put manually JSON with that structure, the PHP gives me error 500.

kthorngren

How are you defining your columns (its not shown in the code above). The structure of your columns definition will determine how the data needs to be structured in your JSON.

Kevin