ansaurus

Question

problem getting json data inside my JqGrid..

Answer 1

A:

Your JSON is wrong. You've included the data only, not any of the other info the grid requires (record count, page count, etc.). You must use one of these formats.

Craig Stuntz 2010-08-23 17:55:25

But I don't have problem rendering the JSON data inside my EXT JS grid. SO the data which I am fetching from server side need to send me other info as well?

Paul 2010-08-23 18:34:14

You need to read the documentation and send data in the format required by the grid. I can't make it any more clear than that.

Craig Stuntz 2010-08-23 18:54:31

Answer 2

A:

You should use jsonReader as function (see http://stackoverflow.com/questions/2835957/jquery-with-asp-net-mvc-calling-ajax-enabled-web-service/2836817#2836817 and http://www.trirand.com/jqgridwiki/doku.php?id=wiki:retrieving_data#jsonreader_as_function).

jsonReader : {repeatitems: false,
    root: function(obj) {
        return obj;
    },
    page: function (obj) { return 1; },
    total: function (obj) { return 1; },
    records: function (obj) { return obj.length; }
}

Another problem is that the data from the latestTime are not corresponds to data needed for the formatter:"date". To fix the problem you can try to use srcformat and newformat http://www.trirand.com/jqgridwiki/doku.php?id=wiki:predefined_formatter#predefined_format_types, but I am not sure if it is possible. It seems to me that only numeric date formats are supported.

In the example http://www.ok-soft-gmbh.com/jqGrid/ReadJsonData3.htm I just commented the date format of latestTime. How can see the problem with reading of data can be solved with respect of jsonReader which I suggested.

Oleg 2010-08-23 18:37:16

Thanks! I will try with jsonReader as function ....

Paul 2010-08-23 19:50:51

`jsonReader` as function is a nice feature if you want to read the data in the existing format provided by server. If you do able to make any changes in the server code you should better prepare the data for jqGrid. If makes you possible to use data paging, filtering (searching) and moreover reduce the size of data transfered.

Oleg 2010-08-23 19:58:37

thanks! a ton ...its working now when I am using as a function.. One more question.. If you see my json file you will see OrderDetailsList..Its a list which need to be populated on row click from this present grid on a different grid below this grid ...any idea how can I achieve that...

Paul 2010-08-23 21:10:54

I am not sure what you exactly want, but to be able to use `OrderDetailsList` you need to save the data somewhere. jqGrid supports `loadComplete` event which has one parameter `data` (see http://www.trirand.com/jqgridwiki/doku.php?id=wiki:events#list_of_events). The `data` is deserialized object represented the data received from the server. For example, `data[i].orderDetailsList` will represent the `OrderDetailsList` from the item with the index `i`. You can save the data somewhere and then use `onSelectRow` event to use the data and refresh the "detail" grid.

Oleg 2010-08-23 21:29:32

this is like a master details example ....i am planning to create a another action class which will be trigger on rowSelect from first grid ...one more question ..When we are submitting the selected rows to server do I need to send the rows as JSON objects and have to configure it so that my action class will send it to database ? or there is a another way to achieve it?

Paul 2010-08-23 22:12:05

Oleg 2010-08-23 22:28:34

Thanks a ton.. I will try with postData approach ..did n't worked on postData , so need to read the documentation and have to go through couple of examples...

Paul 2010-08-24 13:02:21

ansaurus

tags:

views:

answers:

problem getting json data inside my JqGrid..

related questions