Displaying JSON data in jquery Datatable

Question

I have a json message in the below format returned from the server. I using jquery data tables to display the data in the table. I am getting some error when trying to use jquery data table. Please let me know where I am going wrong in the configuration of jquery data table to display the below json format. The configuration for jquery data table along with the json data is given below:

 $(function  ()  {
    $('#dataTable').dataTable( {
      "bJQueryUI": true,
      "sPaginationType": "full_numbers",
      "aaData": [
        {
          "links": [
            {
              "rel": "self", // the first column data which should be displayed as link
              "href": "http://localhost:8080/16"
            }
          ],
          "Country": "INDIA",
          "state": "Karnataka",
          "city": "Bangalore",
          "cityId": 16
        },
        {
          "links": [
            {
              "rel": "self",
              "href": "http://localhost:8080/17"
            }
          ],
          "Country": "INDIA",
          "state": "Tamilnadu",
          "city": "Chennai",
          "cityId": 17
        }
      ]
    });

Pradeep · Accepted Answer · 2014-04-21 06:30:38Z

1

A little look up on the jquery datatables documentation helped me to get to the solution. The trick is to use the mData and then map the columns to the attributes from the json. The link for the same is mentioned below:

http://datatables.net/release-datatables/examples/server_side/object_data.html

answered Apr 21, 2014 at 6:30

Pradeep

8437 gold badges16 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Displaying JSON data in jquery Datatable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related