JqGrid set select a row with a particular data value

Question

I have a requirement to set select a row when the grid is loading ,based on the data value of a column in a particular row. ( In my case select the row with invoice number IVAXVL18066996 / refer the attachment ).

I am researching solution for awhile and still can not find favorable answer. I ll really appreciate if someone can help here with this matter

Thanks in advance

Have you tried the answer from here? https://stackoverflow.com/questions/15095433/select-a-row-in-jqgrid-based-on-cell-value — Madalinul, Feb 22 '18 at 08:53

score 0 · Answer 1 · answered Feb 27 '18 at 07:10

with the suggestions of @Madalinul and @Mark I sorted the problem. The fix is as followed

  loadComplete : function(data)
       {
         var rowIds = grid.jqGrid('getDataIDs');

         for (i = 0; i < rowIds.length; i++) {
             invNumberFromGrid = grid.jqGrid ('getCell', rowIds[i], 'invoiceNumber');

             if(invNumberFromGrid === generatedInvoiceNumber){
                 grid.jqGrid('setSelection', rowid, true);
                 break;
             }
         }
       }

All credit goes to them and the community. Many thanks

JqGrid set select a row with a particular data value

1 Answers1