jQuery Grid Plugin - jqGrid - Topic: Getting the unique ID for a row when inline editing

tony on Getting the unique ID for a row when inline editing

Thu, 08 Jan 2009 08:04:36 +0200

Hello,

I do not understand right what is used - inline editing or cell editing? Both are diffrent things.

Regards

Tony

pkinsman on Getting the unique ID for a row when inline editing

Tue, 06 Jan 2009 09:27:32 +0200

Thanks again. I actually tried this a while ago but couldn't get it to work. Now that I see it's working for you I'll give it another shot!

geek on Getting the unique ID for a row when inline editing

Mon, 05 Jan 2009 15:10:01 +0200

The rowID is the real ID. When setting up your grid you specify what the ID is. In my case, I am using an xmlReader which looks like this:

xmlReader: {
root: "DocumentElement",
        row: "Table1" ,
        page: "DocumentElement>currentpage",
        total: "DocumentElement>totalpages",
        records: "DocumentElement>totalrecords",
        repeatitems: false,
        id: "guidBranch"
}

You can alternatively specify the ID by using the key property in your colModel definition like this:

colModel: [
{name:'guidBranch' ,index:'guidBranch', key=true},
]

At this point, when any of the aforementioned events are fired (i.e. afterSaveCell) the rowID passed in this even is your "real" ID which is presumably your primary key.

Hopefully this helps, again 🙂

pkinsman on Getting the unique ID for a row when inline editing

Mon, 05 Jan 2009 09:57:57 +0200

geek said:

I am doing exactly this in my own implementation. I do not display the ID column at all. I simply reference the rowid provided to tell me the ID corresponding to the data I am saving/deleting.

Hmmm actually I don't get it. How are you using the rowid to get the real ID? Maybe you can post an example?

pkinsman on Getting the unique ID for a row when inline editing

Wed, 31 Dec 2008 13:39:26 +0200

Thanks so much for your quick reply! I will give this a shot.

geek on Getting the unique ID for a row when inline editing

Wed, 31 Dec 2008 13:17:54 +0200

When using inline editing you can add handlers for any of events listed in the documentation (Cell Editing -> Events) (http://www.secondpersonplural....../index.htm)

Nearly all of these events provide the following to your handler:

rowid - is the rowid (this is the unique row id you are referring to)

cellname is the name of the cell (name from colModel)

value - the value of the cell

iRow - the index of the row (do not mix with rowid)

iCol - the index of the column

I am doing exactly this in my own implementation. I do not display the ID column at all. I simply reference the rowid provided to tell me the ID corresponding to the data I am saving/deleting.

Hope this helps!

pkinsman on Getting the unique ID for a row when inline editing

Wed, 31 Dec 2008 12:51:43 +0200

I have searched the forums and have not been able to find an answer to this question, even though I am sure I am not the first to encounter this issue.

I noticed that you have to set each field as "editable" in order to have jqGrid post the value back to the server. So, I have the make the primary key editable in order to make inline editing work, so I know which record to update on the server side.

I was OK with this, but then they asked me to add a delete feature. I have noticed that the value of editable text fields comes back looking something like "<input class="editable" name="ftevalue" id="1_ftevalue" style="width: 99%;" type="text">". If you make the field non-editable, you get back the actual value of the field.

So, if I make the ID field non-editable, the delete feature works (because the value will come back properly), but now my inline editing is broken!

Please help!