How to render nested json objects in a grid

[joshParticipant]

Hi,
I have this json data that i want to render to a grid,
var data = [
{
“pk”: 1,
“model”: “artefacts.eventgroup”,
“fields”: {
“groupname”: “Failed login”,
“event”: {
“pk”: 1,
“model”: “artefacts.event”,
“fields”: {
“event_id”: 2345,
“windows”: “Win 2008”
}
}
}
},
{
“pk”: 2,
“model”: “artefacts.eventgroup”,
“fields”: {
“groupname”: “unauthenticated user “,
“event”: {
“pk”: 1,
“model”: “artefacts.event”,
“fields”: {
“event_id”: 2345,
“windows”: “Win 2008”
}
}
}
},
{
“pk”: 3,
“model”: “artefacts.eventgroup”,
“fields”: {
“groupname”: “wrong username”,
“event”: {
“pk”: 2,
“model”: “artefacts.event”,
“fields”: {
“event_id”: 2345,
“windows”: “Win 2007”
}
}
}
},
{
“pk”: 4,
“model”: “artefacts.eventgroup”,
“fields”: {
“groupname”: “wrong password”,
“event”: {
“pk”: 3,
“model”: “artefacts.event”,
“fields”: {
“event_id”: 3456,
“windows”: “Win 2003”
}
}
}
}
];
As you can see, the fields windows and event_id are at level two..how do i possibly render them to grid?

[Peter StoevKeymaster]

Hi josh,

To render nested JSON objects, you should set the “map” member of the source object’s data fields. To learn how to do that, please look at: http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-datasources.htm

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[joshParticipant]

Thanks Peter Got it

[Author]

Posts