Configure DataTables to handle array of arrays

Question

Is it possible to configure DataTables to hanlde array of objects instead of default array of arrays for aaData propery?

Here is my JSON:

{
    "sEcho": 1,
    "iTotalRecords": "57",
    "iTotalDisplayRecords": "57",
    "aaData": [
        {
            "userid": "tM4Ga0zX",
            "password": "ZKwMEiIa",
            "vpn_password": "K3lS2yn9",
            "status_id": 0,
            "expire_account": "0000-01-01 00:00:00",
            "created": "2014-02-11 09:29:02"
        },
        {
            "userid": "tM4Ga0zX",
            "password": "ZKwMEiIa",
            "vpn_password": "K3lS2yn9",
            "status_id": 0,
            "expire_account": "0000-01-01 00:00:00",
            "created": "2014-02-11 09:29:02"
        },
        {
            "userid": "tM4Ga0zX",
            "password": "ZKwMEiIa",
            "vpn_password": "K3lS2yn9",
            "status_id": 0,
            "expire_account": "0000-01-01 00:00:00",
            "created": "2014-02-11 09:29:02"
        }
    ]
}

davidkonrad · Accepted Answer · 2014-02-11 21:02:57Z

1

Yes, add an aoColumns-definition your initialization :

..
"aoColumns": [
  { "mDataProp": "userid" }, 
  { "mDataProp": "password" },
  { "mDataProp": "vpn_password" },
  { "mDataProp": "status_id" },
  { "mDataProp": "expire_account" },
  { "mDataProp": "created" }
]
..

fiddle with your data as above -> http://jsfiddle.net/6tK7K/

Important : If you use dataTables v 1.9.2 or above, use the property name "mData" instead. As the docs says :

Note that prior to DataTables 1.9.2 mData was called mDataProp. The name change reflects the flexibility of this property and is consistent with the naming of mRender. If 'mDataProp' is given, then it will still be used by DataTables, as it automatically maps the old name to the new if required.

answered Feb 11, 2014 at 21:02

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

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

2 Comments

Roman Newaza Over a year ago

Thanks! How does jsfiddle work if there is no DataTables plugin included?

davidkonrad Over a year ago

You are welcome! See the fiddle, to the left there is "External Resources", just added datatables.js and the corresponding css from a CDN. Allan Jardine has now his own CDN up running, cdn.datatables.net - but I think it is still in a kind of beta.

Collectives™ on Stack Overflow

Configure DataTables to handle array of arrays

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related