jQuery Grid Plugin - jqGrid

The problem why I can't get value using jquery is because the definition of id of the column:

RowId is not just a simple number, but string combined from 3 columns which can contain non standard characters.

ie: '#Field_1_Field_2_Field_3_Column_name' where Field_1 is "stra#+ n – ge čar"

The definition from php file:

My question is how to escape these strange characters that will mathc jqgrid definition ( ie: that I will get the same string for column id as jqgrid ). I tryed javascript encodeURIComponent(rowid) function but it is not working (my knowledge of javascript is very limited:(

First of, thank you for replying to my post, I am bashing my head against the wall for two days with this problem.
I will try to explane better.

When grid is in edit mode I would like to select value of column A ( edittype : select ) when inside dataEvent 'click' in column B ( column goes into inline edit mode on row select)
ColModel definition of column A (supplier_short_name) and column B (category_entity_id).

If I try to get the value the jqgrid way

I get html string despite the fact that formatter of column A is set to select ( formatter:'select'). So instead the value of the column I get html construct of the column ( <select class= .... </select>)
So the only solution is to get the value with direct jquery request which is

The rowid in my case is defined by values in 3 different columns. Values are not just numbers but can be anything. That is defined in php script:

When jqgid is constructed the id of a column is #RowId_ColumnName where RowId is not just a number but combined value of 3 columns ( user input values which I can not control )

So my question is which function encodes the string value_in_column_1,value_in_column_2,value_in_column_3 to an id of the row?

Example:

regards, Tomaž

Oleg thanks for the help, much appreciated. You probably saved me hours of testing

I am not sure that I full understand what you want. So I write two main problems which I see

1. You choose on the server side ids of the rows in a complex way and the values have special characters
2. The dataUrl of the 'category_entity_id' column should contain the value from the 'supplier_short_name' column from the same row.

Yes you are correct, that was my probem, but thanks to you it is almost solved

• make a simple ids
• if you have two grids on the same page don't use the same ids
• don't use for other elements on the page the same ids which could be returned from the server as rowIds

Make simple ids – of course I don't know why I was thinking that id of row must be made from columns which are unique in sql table.
( This is my first javascript/jquery/jqgrid program, so maby to much information at once   

To your main problem. It seems that your problem is not so difficult to solve. Somewhere, typically inside of onSelectRow or ondblClickRow, so you have rowId, you call editRow function. I suggest that before the call of editRow you change dataUrl of the 'category_entity_id' column. Let us the column 'category_entity_id' has index i_category_entity_id (it seems 1 in your colModel). You can do something like following

var myGrid = jQuery("#link_categories");
var newUrl = 'link_categories.php?oper=grid_lookup_category_entity_id&value=' +
                    encodeURIComponent(myGrid.getCell(rowId,'supplier_short_name'));
var cm = myGrid.getGridParam("colModel");

jQuery.extend(cm[i_category_entity_id], { editoptions: {dataUrl: newUrl}});

I tryed suggested code but it is returning error: i_category_entity_id is not defined. Even if index is changet to category_entity_id so it is the same as column name, the same type of error is shown. Definition of the column is

I also tryed to put the code below to onSelectRow event (before I call editRow) and dataEvent type 'click', but despite the fact, that dropdown is filled correctly, the value in column is reseted to the first value in select.
Example: drop down values are 1,2 and 3. Current value is set to 3, but when row goes into edit mode the value is reseted to 1 (because 1 in the first place of dropdown menu)

Belo is the whole code:

Regards, Tomaž