How to get select's value in jqGrid when using <select> editoptions on a column

Question

I have a couple of columns in jqGrid with edittype="select". How can I read the option value of the value currently selected in a particular row?

e.g.: When I provide the following option, how do I get "FE" for FedEx, etc.

editoption: { value: “FE:FedEx; IN:InTime; TN:TNT” } 

getRowData() for the rowId/cellname returns only the text/displayed component of the select.

If I set a "change" data event on the column, the underlying fires change events only on mouse clicks, and not keyboard selects (there's numerous references to generic selects and mouse/keyboard issues).

Bottomline, when a new value is selected, I need to know the option value at the time of the change, and also prior to posting to the server.

Answer 1

You have to set the formatter of the column to 'select'

Example from the wiki:

colModel : [ {name:'myname', edittype:'select', formatter:'select', editoptions:{value:"1:One;2:Two"}} ... ]

See more here jqgridwiki

I was having the same problem and this worked like a charm