jQuery Grid Plugin - jqGrid - Topic: jqGrid / JSON data - Problems with pagination and sorting. http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-json-data-problems-with-pagination-and-sorting Simple:Press Version 5.7.5.3 varaprasadd on jqGrid / JSON data - Problems with pagination and sorting. http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-json-data-problems-with-pagination-and-sorting#p26955 Discussion http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-json-data-problems-with-pagination-and-sorting#p26955 Hi All,

I need complete code for Jqgrid  with struts 1.x.. Some one help me plzzzzzzzz

]]> Tue, 17 Jul 2012 08:37:24 +0300 Arvind Yadav on jqGrid / JSON data - Problems with pagination and sorting. http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-json-data-problems-with-pagination-and-sorting#p26679 Discussion http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-json-data-problems-with-pagination-and-sorting#p26679 Right... addRowData is too bad for the performance, even the IE browser throws script error to load just 400-500 records. But changing the datatype to local increase the performance and help in loading large no. of records.

]]> Fri, 25 May 2012 22:28:08 +0300 tony on jqGrid / JSON data - Problems with pagination and sorting. http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-json-data-problems-with-pagination-and-sorting#p26277 Discussion http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-json-data-problems-with-pagination-and-sorting#p26277 Hello,

It is better not to use addRowData, but use a data parameter in the grid. Look into the docs.

Do not use datatype as function, but in data parameter you can use the function and return the object.

In this case you will need to set datatype = local

Regards

]]> Mon, 02 Apr 2012 17:49:16 +0300 dav_rms on jqGrid / JSON data - Problems with pagination and sorting. http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-json-data-problems-with-pagination-and-sorting#p26270 Discussion http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-json-data-problems-with-pagination-and-sorting#p26270 Hi,

I'm trying to read a JSON file to populate a jqGrid through jQuery. Grid loads fine. But, I couldn't able to acheive pagination and sorting.

Can someone help?. Here is my code.

==========================================================================

Grid.html

==========================================================================

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
        <link rel="stylesheet" type="text/css" media="screen" href="css/jquery-ui-1.8.18.custom/css/jquery-ui-1.8.17.custom.css" />
        <link rel="stylesheet" type="text/css" media="screen" href="plugins/jquery.jqGrid-4.3.1/css/ui.jqgrid.css" />
        <script type="text/javascript" src="js/jquery-1.7.1.min.js"></script>
        <script src="plugins/jquery.jqGrid-4.3.1/js/i18n/grid.locale-en.js" type="text/javascript"></script>
        <script src="plugins/jquery.jqGrid-4.3.1/js/jquery.jqGrid.min.js" type="text/javascript"></script>
        <script src="js/callWebService.js" type="text/javascript"></script>
        <script>
            $(document).ready(function(){
            jQuery("#list1").jqGrid({
                    datatype:function(jsonData){
                        getEmployees();
                    },
                    height:400,
                    width:1850,
                    colNames:['Employee Name','Age', 'Department', 'Salary','Description'],
                    colModel :[
                      {name:'employeeName', index:'employeeName', width:120, align:'left', sortable:false},
                      {name:'age', index:'age', width:170, align:'left', sortable:false},
                      {name:'department', index:'department', width:90, sortable:true, align:'left'},              
                      {name:'salary', index:'salary', width:140, align:'left', sortable:false},
                      {name:'description', index:'description', width:85, align:'left'}],
                    pager: jQuery('#pager2'),
                    rowNum:10,
                    rowList:[10,20,30],
                    loadonce:true,
                    viewrecords: true,
                    scroll:false
                  })

                  function getEmployees()
                  {
                        var fetchOrderDetailsFrom = 'data.json';
                        var ordersData= callWebService('GET', fetchOrderDetailsFrom);

                        var parsedOrderData = eval(" (" + ordersData + ") ");

                        for (var i=0;i<parsedOrderData.rows.length;i++)
                        {
                            $('#list1').jqGrid("addRowData",i,parsedOrderData.rows[i]);
                        }
                });
                    
            });
        </script>
    <table id="list1"></table>
    <div id="pager2"></div>
    <br />
</html>

=========================================================================

data.json

=========================================================================

{
    "total": "1",
    "page": "2",
    "records": "10",
    "rows": [
        {
            "employeeName": "Mike",
            "age": "25",
            "department": "Sales",
            "salary": "12000",
            "description": "Belongs to Sales Dept"
        },
        {
            "employeeName": "Veron",
            "age": "21",
            "department": "Corporate",
            "salary": "23000",
            "description": "Belongs to Corporate"
        },
        {
            "employeeName": "Vettal",
            "age": "29",
            "department": "Logistics",
            "salary": "21000",
            "description": "Belongs to Logistics dept."
        },
        {
            "employeeName": "Ronaldo",
            "age": "32",
            "department": "Aviation",
            "salary": "15000",
            "description": "Belongs to Aviation dept."
        },
        {
            "employeeName": "Miller",
            "age": "35",
            "department": "Transportation",
            "salary": "17000",
            "description": "Belongs to Transportation dept."
        },
        {
            "employeeName": "George",
            "age": "28",
            "department": "Inventory",
            "salary": "15000",
            "description": "Belongs to Inventory Dept"
        },
        {
            "employeeName": "Mason",
            "age": "62",
            "department": "Accounts",
            "salary": "23000",
            "description": "Belongs to Accounts"
        },
        {
            "employeeName": "Ryan",
            "age": "45",
            "department": "Logistics",
            "salary": "32000",
            "description": "Belongs to Logistics dept."
        },
        {
            "employeeName": "Steve",
            "age": "36",
            "department": "Inventory",
            "salary": "26000",
            "description": "Belongs to Inventory dept."
        },
        {
            "employeeName": "Peter",
            "age": "37",
            "department": "Aviation",
            "salary": "13500",
            "description": "Belongs to Aviation dept."
        },
        {
            "employeeName": "Steve",
            "age": "25",
            "department": "Inventory",
            "salary": "26000",
            "description": "Belongs to Inventory dept."
        },
        {
            "employeeName": "Peter",
            "age": "54",
            "department": "Aviation",
            "salary": "16600",
            "description": "Belongs to Aviation dept."
        }        
    ]
}

Please assume my JSON has more records than the example given above.

Thanks!

]]> Sat, 31 Mar 2012 16:38:52 +0300