Referencing nested JSON Objects in Datatables

Question

I have the following JSON:

[
       {
       "id":"78",
        "packaging": "0",
        "created_at": "2013-01-28 13:46:41",
        "updated_at": "2013-01-28 13:46:41",
        "Clients": {
                      "id": "6",
                      "Name": "Some Name",
                      "Address": "0000000",
                      "Email":"[email protected]"
           }
     },
     {
       "id":"79",
        "packaging": "0",
        "created_at": "2013-01-28 13:46:41",
        "updated_at": "2013-01-28 13:46:41",
        "Clients": {
                      "id": "9",
                      "Name": "Some Other Name",
                      "Address": "0000001",
                      "Email":"[email protected]"
           }
     }
]

I have verified that it is valid JSON on Jsonlint.com.

I have managed to reference the unnested data as below:

    {"sTitle":"Id","mData":"id"},
    {"sTitle":"Created At","mData":"created_at"},
    {"sTitle":"Updated At.","mData":"updated_at"},

Now I want to be able to reference the Clients' Name on datatables.

How do I do this using mData?

did you trying using the conventional "Clients.Name"?

Ohgodwhy
– Ohgodwhy

2013-05-06 06:19:19 +00:00
Commented May 6, 2013 at 6:19 — Ohgodwhy
– Ohgodwhy, Commented May 6, 2013 at 6:19
Yes dot notation.Trying that right away. Thanks.

watkib
– watkib

2013-05-06 06:22:42 +00:00
Commented May 6, 2013 at 6:22 — watkib
– watkib, Commented May 6, 2013 at 6:22
The conventional "Clients.Name" works. Thank you man.

watkib
– watkib

2013-05-06 06:25:52 +00:00
Commented May 6, 2013 at 6:25 — watkib
– watkib, Commented May 6, 2013 at 6:25

ShuklaSannidhya · Accepted Answer · 2013-05-06 06:24:12Z

2

Try this-

{"sTitle":"Client ID","mData":"Clients.id"},
{"sTitle":"Client Name","mData":"Clients.Name"},
{"sTitle":"Client Address","mData":"Clients.Address"}

answered May 6, 2013 at 6:24

ShuklaSannidhya

9,0469 gold badges35 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Referencing nested JSON Objects in Datatables

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