.Hi There,
Please pardon me if I’ve posted in wrong forum. (help forum)
I’m working on dynamic column for jqGrid.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
$.ajax({ mtype:'GET', dataType: "json", //dataType T has to be in UPPER case url:'illumina/xhr_manage_samples_pipeline', success: function(data){ column_name=data.column; //get column names model=data.model; //holds model for column sample_details=data.sample_details; //row datum //json reader $("#grid_illumina_manage_samples2").jqGrid({ jsonReader: { repeatitems: false, id: "", }//json_reader ends colNames: column_name, colModel: model, data: sample_details, pager: '#pager_illumina_manage_samples2', gridview: true, });//grid ends }//successs ends });//ajax ends |
My data looks (json_encoded):
|
1 2 3 4 5 6 |
{"column": ["Sample group Name","Sample list"], "model":[{"name":"sample_group_name"},{"name":"sample_name"}], "sample_details":[{"sample_group_name":"dell_man","sample_name":"A101,A11,B100","sample_count":3}, {"sample_group_name":"asdsad","sample_name":"10,210","sample_count":2}]} |
On PHP side, my associative array looks like:
|
1 2 3 4 5 6 7 8 9 10 11 12 |
$data=array(); //creat an empty array $data['column'][]= 'Sample group Name'; $data['model'][]['name']="sample_group_name"; $data['column'][]= 'Sample list'; $data['model'][]['name']="sample_name"; //query to add sample_group, and list.. push them in $data echo json_encode($data); //dataType is important on the json GET ajax |
In console.log – I get exact data, column model, column names, however data is not loaded in my grid.
The reason I’m going for this approach is I’ve dynamic columns.
Here for the sake of example, and showing issue facing, I’ve restricted to the ones which will be there by default, for which row data has to be loaded.
Any help shall be highly appreciated,
Hello,
Thank you very nuch for the test case. Only this way we can help quick and in time.
No to the problem.
It seems you forgot to set the datatype to the appropriate type. In your case this is local, since you use a array. We have tested your code and it works when a datatype is set to local and not work when it is left (since default is xml). Here is the working code:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
$.ajax({ mtype:'GET', dataType: "json", //dataType T has to be in UPPER case url:'illumina/xhr_manage_samples_pipeline', success: function(data){ column_name=data.column; //get column names model=data.model; //holds model for column sample_details=data.sample_details; //row datum //json reader $("#grid_illumina_manage_samples2").jqGrid({ jsonReader: { repeatitems: false, id: "" }//json_reader ends colNames: column_name, colModel: model, datatype: "local", data: sample_details, pager: '#pager_illumina_manage_samples2', gridview: true });//grid ends }//successs ends });//ajax ends |
Kind Regards,
Will
Guriddo Support Team
Dear Will,
Thanks much for the lightening fast reply.
It works after adding local in datatype, indeed. It makes sense to me.
I’ve follow up query on jsonReader. How do I know/understand what to set in it?
Don’t know if should put a follow up question, or create a new thread? Let me whichever works well with you. 🙂
Right now, I’ve jsonReader as:
1)
|
1 2 3 4 5 6 7 8 9 |
jsonReader: { repeatitems: false, id: "", }, //json reader ends |
In my another grid, I’ve it as:
2)
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
jsonReader: { repeatitems: false, id: "", root: function (obj) { return obj; }, records: function (obj) { return obj.length; }, page: function () { return 1; }, total: function () { return 1; } }, //json reader ends |
These are copy paste from solutions on stackoverflow. I’m clueless when to use what, and tweak as and when need dictates.
My apologies for putting a broad question. I’d be thankful to you if you could share pertinent blog/URL which can help me explain jsonReader. That would help me gain knowledge, and I’d not have to put naive questions on it, if stuck due to this. (for that I should know the problem is due to jsonReader :-/ )
Thanks again for your tremendous help, and your time. 🙂
You rock!
Regards,
–pG
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
