jQuery Grid Plugin - jqGrid - Topic: getRowData only geting visible rows, does not work with paging

giorgio79 on getRowData only geting visible rows, does not work with paging

Sun, 16 Jan 2011 20:22:40 +0200

Thanks Tony.

The grid has a unique HTML id "#list".

However, I noticed the grid rows have a column called "id" as well that have repeating numbers!

These need to be unique as well for "data" param to work

I was under the impression rowids are internal unless I set a "key" column as per the docs?

So it seems there is a bug, namely that "id" column name should not be used.

Giving id rows inside the array unique values DID solve the problem.

Thanks

It seems like this is a bug, and others stumbled on it as well:

http://stackoverflow.com/quest.....uring-save

tony on getRowData only geting visible rows, does not work with paging

Sun, 16 Jan 2011 19:55:25 +0200

Hello,

It seems you do not read the docs and post in this forum.

THE GRID SHOULD HAVE UNIQUIE ID.

Topic closed for me.

Regards

Tony

giorgio79 on getRowData only geting visible rows, does not work with paging

Sun, 16 Jan 2011 17:18:55 +0200

Here is a live url for testing ( I am using Firefox 3.6):

http://s53452.gridserver.com/j....._test.html

The "Change value" under the grid does an alert for grid_data and it is unchanged

and here is the video

(The conversation topic did change from getRowData, but it seems the topic is locked )

giorgio79 on getRowData only geting visible rows, does not work with paging

Sun, 16 Jan 2011 17:00:33 +0200

Guys, first and foremost thanks for your patience.

Oleg: I would LOVE to be wrong 🙂

Tony: In the same example that I posted, just replace the scc button call with this to get grid_data edit some value, although I do change a cell programmatically. But it has no effect. Just recording a video, so you can see.

        jQuery("#scc").click( function() {
           $("#list").setRowData(1,{first_name:"HUHAHUA"});

           var rowdataString = JSON.stringify(grid_data);
           alert(rowdataString);

           });

tony on getRowData only geting visible rows, does not work with paging

Sun, 16 Jan 2011 16:52:21 +0200

Hello,

Then your question should be quite diffrent. Right?

This is not true. Tell me how you try to do it?

SetCell method and setRowData used in celEdit and inline edit affect correctly the array data.

Please check your code again

Regards

Tony

OlegK on getRowData only geting visible rows, does not work with paging

Sun, 16 Jan 2011 16:49:49 +0200

You are wrong Giorgio!

The object accessible under the data parameter contain current local data saved in the jqGrid inclusive all modification of local data which are already saved.

Best regards
Oleg

giorgio79 on getRowData only geting visible rows, does not work with paging

Sun, 16 Jan 2011 16:42:25 +0200

Thanks Tony, I tried but grid_data contains the startup values, but it does not contain any changes made to it via editing in the grid.

tony on getRowData only geting visible rows, does not work with paging

Sun, 16 Jan 2011 16:35:57 +0200

Hello,

Please do not post similar questions several times.

Thank you

Regards

Tony

tony on getRowData only geting visible rows, does not work with paging

Sun, 16 Jan 2011 16:34:23 +0200

Hello,

You can do it reading carefully the docs.

You already have a

…

data: grid_data,

…

grid_data is array which elements can be accesed easy.

Just for the record

var mysearchelement;

$.each(grid_data, function(){

if(this.id=="the_id_that_i_want_to_serch){

mysearchelement = this;

return false;

}

})

Regards

Tony

giorgio79 on getRowData only geting visible rows, does not work with paging

Sun, 16 Jan 2011 16:28:45 +0200

Ouch, just found out getRowData only returning visible rows. (Using javascript array as source)

(Just like setCell can only set visible rows, that I recently found:

http://www.trirand.com/blog/?p.....-it-fails/)

Is this a bug introduced recently? Perhaps I will try an earlier version? If this is not a bug, how can I get all rows??? If I cannot, I guess jqGrid is useless for me.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8″ />
<title>My First Grid</title>

<link rel="stylesheet" type="text/css" media="screen" href="../../js/themes/custom-theme/jquery-ui-1.7.3.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css" />

<style>
html,
body {
    margin: 0;
    padding: 0;
    font-size: 75%;
}
</style>

<script src="js/jquery-1.4.2.min.js" type="text/javascript"></script>
<script src="js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>

<script type="text/javascript">
var lastgridsel;
$(function(){

var grid_data =
   [
   {id:"1",whoaaa:"hehehe",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"1",completed:"1"},
   {id:"2",whoaaa:"hahaha",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"0",completed:"0"},
   {id:"3",whoaaa:"huhuhu",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"bhjbjhbj",selected:"0",completed:"1"},
   {id:"1",whoaaa:"hehehe",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"1",completed:"1"},
   {id:"2",whoaaa:"hahaha",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"0",completed:"0"},
   {id:"3",whoaaa:"huhuhu",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"bhjbjhbj",selected:"0",completed:"1"},
   {id:"1",whoaaa:"hehehe",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"1",completed:"1"},
   {id:"2",whoaaa:"hahaha",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"0",completed:"0"},
   {id:"3",whoaaa:"huhuhu",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"bhjbjhbj",selected:"0",completed:"1"},
   {id:"1",whoaaa:"hehehe",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"1",completed:"1"},
   {id:"2",whoaaa:"hahaha",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"0",completed:"0"},
   {id:"1",whoaaa:"hehehe",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"1",completed:"1"},
   {id:"2",whoaaa:"hahaha",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"0",completed:"0"},
   {id:"3",whoaaa:"huhuhu",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"bhjbjhbj",selected:"0",completed:"1"},
   {id:"1",whoaaa:"hehehe",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"1",completed:"1"},
   {id:"2",whoaaa:"hahaha",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"0",completed:"0"},
   {id:"3",whoaaa:"huhuhu",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"bhjbjhbj",selected:"0",completed:"1"},
   {id:"1",whoaaa:"hehehe",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"1",completed:"1"},
   {id:"2",whoaaa:"hahaha",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"0",completed:"0"},
   {id:"3",whoaaa:"huhuhu",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"bhjbjhbj",selected:"0",completed:"1"},
   {id:"1",whoaaa:"hehehe",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"1",completed:"1"},
   {id:"2",whoaaa:"hahaha",ko:"9",first_name:"John",last_name:"Kan",username:"huhuhu",password:"KAKSYAKA",selected:"0",completed:"0"},

   ];

jQuery("#list").jqGrid({
       cellEdit:true,
       cellsubmit: "clientArray",
       editurl:'clientArray',
       datatype: "local",
       loadonce: true,
       data: grid_data,
       gridview:true,
       rowNum: 20,
       //scroll:1,
       height: '100%',
       viewrecords: true,
       colNames:['id','whoaaa','KO','First Name','Last Name','Username','Password','Selected','Completed'],
       colModel:[
           {name:'id',index:'id',width:60,sorttype:"int",hidden:true},
           {name:'whoaaa',index:'whoaaa',width:90,sorttype:"text"},
           {name:'pr',index:'pr',width:30,sorttype:"int"},
           {name:'first_name',index:'first_name',width:100,sorttype:"text",editable:true},
           {name:'last_name',index:'last_name',width:100,sorttype:"text",editable:true},
           {name:'username',index:'username',width:100,align:"right",sorttype:"text",editable:true},
           {name:'password',index:'password',width:100,align:"right",sorttype:"text",editable:true},
           {name:'selected',index:'selected',width:90,editable:true, edittype:'checkbox', editoptions: { value:"1:0"}, formatter: "checkbox", formatoptions: {disabled : false},sorttype:"text",searchoptions: { sopt: ['eq'], value:":All;1:Yes;0:No" }, stype: 'select',sortable:true},
           {name:'completed',index:'completed',width:100,editable:true, edittype:'checkbox', editoptions: { value:"1:0″}, formatter: "checkbox", formatoptions: {disabled : false},sorttype:"text",searchoptions: { sopt: ['eq'], value:":All;1:Yes;0:No" }, stype: 'select', sortable:true},
           ],
       multiselect: true,
       filterToolbar: true,
       height: "200″,
       //toolbar:[true,"both"],
       pager: "#pager",
       caption: "Accounts" });


       jQuery("#list").jqGrid('navGrid','#pager',
       {view:false,add:false,del:false}
       ).jqGrid('navButtonAdd', '#pager',{id:"showhide",caption:"Show/Hide Columns"});

       jQuery("#showhide").click(function() {
           jQuery("#list").setColumns();
           return false;
       });

       jQuery("#list").jqGrid('filterToolbar', {autosearch:true});
       //$("#list").searchGrid({ } );

       jQuery("#scc").click( function() {
           //alert('click');
           var rowdata= $("#list").jqGrid('getRowData');
           //alert(rowdata);
           var rowdataString = JSON.stringify(rowdata);
           alert(rowdataString);
           //console.log(rowdata);
           $("#list").setRowData(1,{first_name:"HUHAHUA"});
           });
});

</script>

</head>
<body>

<table id="list"></table>
<div id="pager"></div>

<a href="javascript:void(0)" id="scc">Change value</a>
</body>
</html>