Thanks!

Anyway I pass the id using editData in the beforeSubmit event and works ok...

I think you mixed colModel with the real JSON data in the jsonReader.

Try with the default options of jsonReader - i.e. do not set in your grid

Regards

Tony

I have:

rows :[
{id: "11",cell:["11","ADMISTRACIÓN LEGAL Y FINANZAS"]},
{id: "4",cell:["4","ASEGURADORA, ARREDADORA FINANCIERA Y OTROS AFINES"]},
{id: "16",cell:["16","CAJA DE AHORRO, COOPERATIVA O AFINES"]},
{id: "10",cell:["10","CENTROS EDUCATIVOS Y AFINES"]},
{id: "2",cell:["2","COMERCIALIZADORA DE PRODUCTOS ELECTRÓDOMESTICOS, COMPUTACIÓN, MAN"]},
{id: "1",cell:["1","EDITORIAL, VENTA DE LIBROS (MAYOR O DETAL) Y AFINES"]},
{id: "14",cell:["14","EMPRESAS DE CONSULTORÍA, DESARROLLO DE SOFTWARE Y AFINES"]},
{id: "17",cell:["17","EMPRESAS DE SERVICIOS EN GENERAL"]},
{id: "15",cell:["15","FUNDACIÓN SIN FINES DE LUCRO"]},
{id: "9",cell:["9","INMOBILIARIAS, ADMINISTRADORAS DE BIENES RAÍCES Y AFINES"]}
]}

And in my grid i have

            colNames:['Codigo','Nombre'],
            colModel :[
              { name: "co_sector", index: "co_sector", key: true, width: 20, editable: false, search: false, hidden:true },
              { name: "nb_sector", index: "nb_sector", width: 90, editable: true, editoptions: {size: "60", maxlength: "60"}, editrules:{requerided:true}}
            ],

            jsonReader: {
        repeatitems : true,
        id: "co_sector"
            },

But I don't receive "co_sector" when edit or delete a row...

to be correct you JSON response should look like:

“rows” :[
      {"id": "11","cell":["11","ADMISTRACIÓN LEGAL Y FINANZAS"]}
 ]}

I still receive the row number as id and not the primary key value...

Try with this

jsonReader: {
        repeatitems : true,
        id: "id"
            },

There is a bug when id:"0" (only) since java interpret "0" as false.

I have corrected this.

Regards

Tony

jsonReader: {
        repeatitems : true,
        id: "0"
            },

How looks your jsonReader like?

Regards

Tony

 rows :[
      {id: "11",cell:["11","ADMISTRACIÓN LEGAL Y FINANZAS"]}
 ]}

And, say, this is the row 3 when i show those data in the grid and when I edit i received the "id" parameter as "3" and not as "11"...

why ?

<row ID=”3″>

should be

<row id=”3″>

or change the xmlReader to read the ID instead of id

<row ID="3">
<cell>3</cell>
<cell>Alex Bokun</cell>
<cell>+5296418677</cell>
<cell>Gsmart 300</cell>
<cell>34523452345</cell>
<cell>Inactive</cell>
</row>

Thank you for this, but sorry this is not a bug.

The for statement is called after constructing the multiselect and subgrid

additinal columns, so this must work - check your code again.

Check your server code again and pay attention on what you return from

server -  Is the name exactly as those from colModel.

Regards

Tony

      for (var i=0; i<ts.p.colModel.length;i++) {
            if (ts.p.colModel[i].key===true) {
                ts.p.keyIndex = i;
                break;
            }
            i++;
        }

So because of two increments my key column was skipped. I changed it to

if(ts.p.multiselect) n=1;
else n=0;
        for(i=0;i<this.p.colNames.length;i++){
            if (ts.p.colModel[i+n].key===true) {
                ts.p.keyIndex = i;
                break;
            }
        }

Now it works 🙂

   colModel :[
              { name: "co_sector", index: "co_sector", width: 20, editable: true, search: false },
              { name: "nb_sector", index: "nb_sector", width: 90, editable: true, editoptions: {size: "60", maxlength: "60"}, editrules:{requerided:true}}
            ],
      
And I hides the "co_sector" (that it is my PK)

jQuery("#list").hideCol(["co_sector"]);   

When I submit the data in a "edit" action I receive the co_sector as part of the QueryString.

For delete operation I just add the "co_sector" data in the beforeSubmit method of the delete options. My code is:

 { height:90, width:300,  reloadAfterSubmit:false,
              beforeSubmit: function() {
                 var sr = jQuery("#list").getGridParam('selrow');
                 var rowData = jQuery("#list").getRowData(sr);
            
                  this.delData = {"co_sector" : rowData['co_sector']};
                  retarr = {"co_sector" : rowData['co_sector']};
                  return retarr;
              }
            }, // del options

HTH

Please explain me how to use id sent from server...

i have

{name:'UserId', key: true, index:'users.UserId', width:30, sorttype:"int"}

in my colmodel. but when editing or deleting server gets parameter id={number of current row}. But i need userId...