jqGrid passing row number instead of id column

greetings Demosthenes, , I am not able to completely look at the flow of your JSON return, so I will guess that in your  "JSON handler" you have references for all of the "Values" Except for the "id" value, you seem to have a Constant there as "1", as here -

Value = [i][b]1[/b][/i]

Select allOpen in new window

shouldn't that be a reference also, but if you have a "1" there, it would always show one, no matter the id ?
Or maybe I don't see your intent?

Alexandre, I tried this before but whenever I used the jsonReader any row that is clicked on becomes highlighted, and stays highlighted.  I even have multiselect:false and it still high lights any and all rows that are clicked on.

        <script>
        
          /* setup the grid */
          $(function () {
            $('#list').jqGrid(
              {
              url: '/capplanning/SitePages/jsonhandler.aspx?wherefrom=Category One',
              datatype: 'json',
              mtype: 'GET',

        colNames: ['category_id','category_type','category_value'],
        colModel: [{ name:'category_id'},
                   { name: 'category_type', sortable: true, editable:false},
                   { name: 'category_value', sortable: true, editable:true}],
              pager: '#pager',
              caption: 'Category One',
              loadonce: 'true',
              height: '100%',
              cellEdit: true,
                      cellsubmit: 'remote',
                      cellurl: '/capplanning/SitePages/jsonhandler.aspx?editedgrid=editcategory1',
              autowidth: true,
              rowNum: 9999,
            jsonReader : {
                    root:"rows",
                    cell: "cell",
                    id: "id"
   }
              /*rowList:[10,15,20]*/
              });
          /*End grid setup*/

          $('#list').jqGrid('filterToolbar',{stringResult: true,searchOnEnter : false}); /* set up Filter toolbar */
          $('#list').jqGrid('navGrid', '#pager', { edit: false, add: true, del: true }); /* Show the bottom bar "Pager"*/
          $('#list').jqGrid('navButtonAdd', '#pager',                                    /* Set up Filter toggle button*/
            {
            caption: '',
            title: 'Show/Hide Filters',
            buttonicon: 'ui-icon-arrowthickstop-1-e',
            onClickButton: function ()
              {
              this.toggleToolbar();
              if ($.isFunction(this.p._complete))
                {
                if ($('.ui-search-toolbar', this.grid.hDiv).is(':visible'))
                  {$('.ui-search-toolbar', this.grid.fhDiv).show();}
                else
                  {$('.ui-search-toolbar', this.grid.fhDiv).hide();}
                this.p._complete.call(this);
                fixPositionsOfFrozenDivs.call(this);
                }
              }
            });
          $('#list')[0].toggleToolbar();                                                 /* call the function so the Filters are hidden on startup*/

          });
        </script>

Select allOpen in new window

                 

    {"rows":[
                      {"id":"2","cell":["2","CategoryOne","Cost Reduction"]},
                      {"id":"3","cell":["3","CategoryOne","Maintenance"]},
                      {"id":"4","cell":["4","CategoryOne","New Growth"]}
                      ]}

Select allOpen in new window

I don't know how to delete a comment so I will just post that I had changed the id column name and forgot to change it in the new jsonReader section.  I changed

              jsonReader : {
                    root:"rows",
                    cell: "cell",
                    id: "id"
   }

Select allOpen in new window

to

              jsonReader : {
                    root:"rows",
                    cell: "cell",
                    id: "category_id"
   }

Select allOpen in new window

So it matches the column in the colModel.

I just threw in some code I found on the internet to deal with the rows highlighting, it seems to work so I will post it.

          $('#list').jqGrid().focusout(function ()                                       /* unselect row after lose focus::fix for row sel issue */
            {
            $('#list').jqGrid("resetSelection");
            });

Select allOpen in new window

I don't see how that behavior can be related to the jsonReader config itself.
It might indeed be a side effect for the fact that with it you are reading the data correctly.

Do you use any custom CSS?

I remembered that resetSelection option, but I'm not sure how it behaves with the celledit.

Works well?

No, I am grasping at straws now.  Here seems to be the issue.
json returns this

                      {"rows":[
                      {"id":"2","cell":["2","CategoryOne","Cost Reduction"]},
                      {"id":"3","cell":["3","CategoryOne","Maintenance"]},
                      {"id":"4","cell":["4","CategoryOne","New Growth"]}
                      ]}

Select allOpen in new window

 My colum model looks like this.

colNames: ['category_id','category_type','category_value'],
        colModel: [{ name:'category_id'},

Select allOpen in new window

When my reader code looks like this: the row number is only passed
              jsonReader : {
                    root:"rows",
                    cell: "cell",
                    id: "category_id"
                    }

When my reader code looks like this: the id is passed correctly BUT, all my rows start highlighting, the type of behavior you would expect if the grid had no id or key set.
              jsonReader : {
                    root:"rows",
                    cell: "cell",
                    id: "category_id"
                    }

should have been

              jsonReader : {
                    root:"rows",
                    cell: "cell",

Select allOpen in new window

                   id: "id"
                    }

What I am thinking is as a workaround maybe I can just deselect the last selected row if that is possible but so far I havent found good code for that.  I could keep
              jsonReader : {
                    root:"rows",
                    cell: "cell",
                    id: "id"
                    }
And just unselect the last selected row.  Or unselect every row except the one being clicked on or selected.