jQuery Grid Plugin - jqGrid - Topic: Custom JSON Parsing - Arrays http://www.trirand.com/blog/?page_id=393/help/custom-json-parsing-arrays Simple:Press Version 5.7.5.3 bpcm on Custom JSON Parsing - Arrays http://www.trirand.com/blog/?page_id=393/help/custom-json-parsing-arrays#p25442 Help http://www.trirand.com/blog/?page_id=393/help/custom-json-parsing-arrays#p25442

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

]]> Fri, 16 Dec 2011 18:07:45 +0200 tony on Custom JSON Parsing - Arrays http://www.trirand.com/blog/?page_id=393/help/custom-json-parsing-arrays#p25436 Help http://www.trirand.com/blog/?page_id=393/help/custom-json-parsing-arrays#p25436 Hello,

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

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

Regards

]]> Fri, 16 Dec 2011 11:01:27 +0200 bpcm on Custom JSON Parsing - Arrays http://www.trirand.com/blog/?page_id=393/help/custom-json-parsing-arrays#p25434 Help http://www.trirand.com/blog/?page_id=393/help/custom-json-parsing-arrays#p25434 Anyone have any insight on this issue?

]]> Thu, 15 Dec 2011 17:37:48 +0200 bpcm on Custom JSON Parsing - Arrays http://www.trirand.com/blog/?page_id=393/help/custom-json-parsing-arrays#p25363 Help http://www.trirand.com/blog/?page_id=393/help/custom-json-parsing-arrays#p25363 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

]]> Fri, 09 Dec 2011 18:51:05 +0200