jQuery Grid Plugin - jqGrid - Topic: setRowData behavior

Reg on setRowData behavior

Sun, 20 Jul 2008 09:03:03 +0300

Thank you Tony,

That fixes that problem beautifully. What I was missing was the mention of the grid_id. Is this something that should go into the docs somewhere or is it a jQuery feature that everyone (except beginners like me) will know about?

Thanks again

Reg

tony on setRowData behavior

Sun, 20 Jul 2008 04:37:10 +0300

Maybe I will explain this in detail.

1. When the grid is constructed we have something like:

...

<tr id='123'><td>myval</td>..</tr>

...

After editRow we have

<td><input id='123_myname' ..val='myval' /></td>...

</tr>

So when we call after this setRowData the entry input tag is replaced with the value from setRowData.

Now - one possible solution is those from Reg

$("#"+id+"_myname","#mygrid").val("newvaluehere")

Another solution is to write additional method which will act to this case

Regards

Tony

Reg on setRowData behavior

Sat, 19 Jul 2008 16:50:16 +0300

I think I might have a similar situation. I have two columns — account and amount — in a grid where the rows represent the parts of an accounting transaction. When I add a row, the user selects an account and my javascript code then calculates what the amount would have to be based on all the other rows (it tries to force a balance across all rows in this transaction). It then sets the amount cell to this calculated amount.

But it is possible that the user does not want all of the outstanding amount to go to this account, so he (or she) has to be able to edit the amount before saving the row.

What happens is, the javascript calculates the balance, then uses

$('#tblwriteoff').setRowData(id,{ 'amount':num } );

to set the amount column on this row to the balance and the cell, which previously was editable (before I selected the account), no longer is.

So I tried

$('#' + id + '_amount').val(num);

and this is even worse; now the amount does not hold its value.

After that I tried

$('#tblwriteoff').setCell(id,'amount',num);

and still no joy. The amount is there but the cell is not editable. WHen I save the row (I am using keys:true so I press enter when the cursor is in the account cell) the amount data disappears.

Am I doing something wrong and one of these should work, or is the cell going to be not editable whatever I do?

And if so, what do you suggest for pre-populating a cell and still leaving it editable?

Thanks,

Reg

julizar on setRowData behavior

Thu, 17 Jul 2008 09:10:47 +0300

I did not want to set row to be "not editable" after SetRowData,

there is a saveRow method to do that.

tony on setRowData behavior

Thu, 17 Jul 2008 08:07:42 +0300

But I 'm not sure if after this you will have the expected behavior.

tony on setRowData behavior

Thu, 17 Jul 2008 08:05:50 +0300

This is expected behavior and not a bug. Let me try to explain:

The reason when you call this way

setRowData(rowid,{”id”:”newid”,“Name”:”NewName”)}

and all is ok is that these fields are not editable. As of the names of the

methods they operate per row and not per cell.

To work this you should set the row to be not editable after

setRowData something like

$("#rowid","#mygrid").attr("editable","0");

julizar on setRowData behavior

Thu, 17 Jul 2008 07:58:14 +0300

Yes, that is. And if i call

setRowData(rowid,{”id”:”newid”,“Name”:”NewName”)} that way,

without set value to kind the row is staying editable as it should be.

tony on setRowData behavior

Thu, 17 Jul 2008 07:47:08 +0300

Sorry maybe I do not understand.

So:

1. you call editRow;

(some fields are not editable and only Kind is editable)

2. you call setRowData(rowid,{”id”:”newid”,“Name”:”NewName”,

“Kind”:”0"}) right?

In this case the editable column Kind is overwritten with the value and it

is no more editable - right?

julizar on setRowData behavior

Thu, 17 Jul 2008 07:35:25 +0300

The thing that i want to explain is:

when i set new values of columns

with setRowData method and describe in this method all the columns

and theri values the row after that the row colsed himself(all inputs

and select are text which user can`t edit) if it was in

edit mode(editRow) and I did not call SaveRow to do that.

Describes in my third post.

tony on setRowData behavior

Thu, 17 Jul 2008 06:57:31 +0300

Do not see setRow instead. (Mybe you call it in EditPerson() function)

What I try to explain is:

If you call editRow on grid and after editRow you call setRow on same grid your data is overwritten by setRow the field has a flag editable,but with data that is overwritten - so you can anymore do edit an this until you not call

restoreRow.

Regards

Tony

julizar on setRowData behavior

Thu, 17 Jul 2008 06:18:24 +0300

I did not understand why but ...

ondblClickRow:function(rowid){
            $("#healthExpertGrid").editRow(rowid,false);

            $("#healthExpertGrid #"+rowid +" input,select").each(function(){
                $(this).attr("size","");
                $(this).css("width","96%");
                $(this).css("font-size","13px");
            })
            if($("#healthExpertGrid #"+rowid).attr("status")!=recInsert)
                    $("#healthExpertGrid #"+rowid).attr("status",recEdit);
            EditPerson();
            $("#container input,select,textarea").focus(function(){
                lastSelection = $(this).attr("id");
            })
            $("#healthExpertGrid #"+rowid).keyup(function(e){
                    var keyCode = e.keyCode || window.event.keyCode;
                    if(keyCode == 27){
                        $("#healthExpertGrid").restoreRow(rowid);
                        $("#healthExpertGrid #"+rowid).attr("status",recBrowse);
                    }
                });
        }

tony on setRowData behavior

Thu, 17 Jul 2008 06:01:23 +0300

Could you please publish the full code in ondblClickRow event?

julizar on setRowData behavior

Thu, 17 Jul 2008 05:56:47 +0300

After editRow function.

tony on setRowData behavior

Thu, 17 Jul 2008 05:23:29 +0300

When you call setRow - before or after editRow?

julizar on setRowData behavior

Thu, 17 Jul 2008 04:39:26 +0300

I have jqGrid with 3 columns,

1. id column,hidden

2. Name column text, not editable by user

3. Kind type combobox editable

on dbclick i set editRow for dbclicked row

i`m using setRowData as callback from other action to change the

name Name and id column:

$("#gridid").setRowData($("#grid").getGridParam("selrow"),

{"id":"newid",

"Name":"NewName",

"Kind":"0"}

)

after this action current row is closed for editing by the setRowData.

if i do:

$("#gridid").setRowData($("#grid").getGridParam("selrow"),

{"id":"newid",

"Name":"NewName",}

)

without set Kind column value

current row is not closed for edit wich is fine for me.

After playing a while with this behavior I noticed that if i set with

setRowData only the editable column (in my case Kind column wich is type"select") the row is closed for edit from himself again.

tony on setRowData behavior

Thu, 17 Jul 2008 03:50:06 +0300

Could you please post your code here or send me to: tony at trirand.com?

Regards

Tony

julizar on setRowData behavior

Thu, 17 Jul 2008 03:02:37 +0300

Sorry i mean setRowData instead of saveRowData.

tony on setRowData behavior

Thu, 17 Jul 2008 02:45:51 +0300

Should I mean that you want to set extraparams?

I suppose you have make typo here since the right syntax for saveRow

saveRow(rowid, succesfunc, url, extraparam, aftersavefunc,errorfunc)

Is the syntax for extraparams like this {col1:"hisval",col2:""} ?

or this {col1:"hisval",col2} which is wrong IMHO

Regards

Tony

julizar on setRowData behavior

Wed, 16 Jul 2008 14:43:50 +0300

I have a row in edit mode (editGridRow), then i do something like:

saveRowData(rowid,{

"col1":"hisval","col2",""

})

current row hav these two 2columns, and with this method i want to fill

only the first column, the second col must be filled by the user. But after i call the saveRowData this way the row is "closed" for editing after that

if i dont set secund col "col2" as "" (set only col1 value with saveRowData)

method there is no problem.

Greetings!