jQuery Grid Plugin - jqGridForum

Topic RSS

Related Topics sp_TopicIcon

Custom JSON Parsing - Arrays

Tags: json array parse

09/12/2011
18:51

bpcm

Member

Members

Forum Posts: 6

Member Since:
09/12/2011

Offline

Hello,

I'm having an issue with parsing a JSON string that contains an array:




{"max":20,"total":1,"rows":[{"line":"THIRD_LINE","cell":123456789,"aptitudeHashSet":[{"skillName":"Swimming"
,"value":1,"id":3,"color":"RED"},{"skillName":"Shotput","value":5,"id":1,"color":"WHITE"},{"skillName"
:"Track","value":5,"id":2,"color":"GREEN"}],"name":"jon smith","id":1,"region":"The end","available"
:true}],"page":1}


What I would like to have displayed in JQgrid is something like:





name
region
cell
line
SWIMMING ('skillName')
swimmingColor
~~next skill etc


Jon Smith
The end
123456789
FIRST_LINE
1 ('value')
RED
~~next skill etc






 In our DB we have a persons table that references a skills table with a list of skills.

Is this possible or do I need to generate a customized JSON string from the server?

Thanks,
bpcm

name	region	cell	line	SWIMMING ('skillName')	swimmingColor	~~next skill etc
Jon Smith	The end	123456789	FIRST_LINE	1 ('value')	RED	~~next skill etc

15/12/2011
17:37

bpcm

Member

Members

Forum Posts: 6

Member Since:
09/12/2011

Offline

Anyone have any insight on this issue?

16/12/2011
11:01

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

You will need to configure your JSON reader. Reading docs us usefull thing.

http://www.trirand.com/jqgridw.....#json_data

Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

16/12/2011
18:07

bpcm

Member

Members

Forum Posts: 6

Member Since:
09/12/2011

Offline

tony said:

Hello,

You will need to configure your JSON reader. Reading docs us usefull thing.

http://www.trirand.com/jqgridw.....#json_data

Regards

Hello,

I can seem to display data in the table using 'dot notation' but when I edit a 'person', jqGrid returns:

{"id":"12″,"name":"jon smith","region":"The end","line":"FIRST_LINE","skillName":"Swimming","color":"GREEN","value":"5″}

I think the problem is that I have unnamed arrays within an array; jqGrid ignores them
It does not return an array of skills.I would like it to return:

"id":"1″,"name":"jon smith","region":"The end","line":"FIRST_LINE",aptitudeHashSet": [{"skillName":"Swimming","color":"silver","value":"5"}, {"skillName":"Shotput","color":"purple","value":"9"}]}

I think it needs to match format of servers JSON:

{"max":20,"total":1,"rows":[{"line":"THIRD_LINE","cell":123456789, "aptitudeHashSet":[{"skillName":"Swimming" ,"value":1,"id":3,"color":"RED"}, {"skillName":"Shotput","value":5,"id":1,"color":"WHITE"}, {"skillName" :"Track","value":5,"id":2,"color":"GREEN"}], "name":"jon smith","id":1,"region":"The end","available" :true}], "page":1}

colModel:[ ...{
                name:'name',
                width:300,
                editable:true,
                editrules:{required:true}
            },{ width:52,
                editable:true,
                jsonmap:"aptitudeHashSet.1.value"
            }...];

jsonReader:{
root:"rows",
repeatitems:false}

Somehow I have configured jqgrid incorrectly. It seems the colmodel flattens out the arrays.

Thank you, bpcm

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
30 Guest(s)

Currently Browsing this Page:
1 Guest(s)