Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
json formatting help
29/07/2014
17:36
Avatar
_Chris
New Member
Members
Forum Posts: 2
Member Since:
29/07/2014
sp_UserOfflineSmall Offline

My returned json looks like this:

{"SUCCESS":true,"ERRORS":[],"DATA":{"COLUMNS":["COL_ID","COL_NAME"],"DATA":[["B5E34D73-955D-AB23-9D0D-3BF6C4FF4505","Test Name 1"],["D9A3A435-EACE-073F-1ABC-050BD038D23C","Test Name 2"]]}}

 

So I tried this:

"jsonReader":{root:"DATA","repeatitems":false,"subgrid":{"repeatitems":false}},

"colModel":[{"name":"","index":"1","jsonmap":"data","sorttype":"text","width":80,"editable":true}],

 

I suspect that the problem is that my column names and data are separated in the json response -- how do I handle this in jqGrid?

 

OR

 

Better yet, is there a way to call a jQuery function after the json call, but before the grid renders the data so that I can convert the json to the proper format expected by jqGrid???

01/08/2014
18:46
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

Better yet, is there a way to call a jQuery function after the json call, but before the grid renders the data so that I can convert the json to the proper format expected by jqGrid???

See docs.

 

Your json have two data tags, which is a little bit confused. Correct this and maybe you will get the data rigth.

 

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.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
57 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information