Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If I understand you correct you want to enable/disable "Edit" or "Delete" buttons of the navigator based of the selected row. So that you will have <img src="https://i.stack.imgur.com/E3zuI.png" alt="enter image description here"></p> <p>if no rows is selected or the selected row is non-editable or the standard navigator toolbar <img src="https://i.stack.imgur.com/Ouwej.png" alt="enter image description here"></p> <p>if the row is editable.</p> <p>The criteria whether the column "editable" or "readonly" seems me wrong because it is criteria column on the column and not on the row, but you can implement easy your own custom criteria.</p> <p>The implementation could be </p> <pre><code>var myGrid = jQuery("#list"); myGrid.jqGrid({ /* definition of jqGrid */ beforeSelectRow: function(rowid) { var selRowId = $(this).getGridParam('selrow'), tr = $("#"+rowid); // you can use getCell or getRowData to examine the contain of // the selected row to decide whether the row is editable or not if (selRowId !== rowid &amp;&amp; !tr.hasClass('not-editable-row')) { // eneble the "Edit" button in the navigator $("#edit_" + this.id).removeClass('ui-state-disabled'); $("#del_" + this.id).removeClass('ui-state-disabled'); } else { // unselect previous selected row // disable the "Edit" and "Del" button in the navigator $("#edit_" + this.id).addClass('ui-state-disabled'); $("#del_" + this.id).addClass('ui-state-disabled'); } return true; // allow selection or unselection }, loadComplete: function() { // just one example how to mark some rows as non-editable is to add // some class like 'not-editable-row' which we test in beforeSelectRow $("tr.jqgrow:even",this).addClass('not-editable-row'); } }).jqGrid('navGrid','#pager'); // disable "Edit" and "Delete" button at the beginning $("#edit_" + myGrid[0].id).addClass('ui-state-disabled'); $("#del_" + myGrid[0].id).addClass('ui-state-disabled'); </code></pre> <p>To enable/disable the "Edit" and "Del" buttons we add/remove the 'ui-state-disabled' class on the buttons of the navigator toolbar. In the code above I mark all rows with even numbers as "non-editable". In your case you can use any other criteria which has more sense.</p> <p>You can see the demo live <a href="http://www.ok-soft-gmbh.com/jqGrid/EdableDisableEditDelNavigatorButtons.htm" rel="noreferrer">here</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POjqgrid: how to set toolbar options based on column value in row selected
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USOleg
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POjqgrid: how to set toolbar options based on column value in row selected
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COthanks for the perfect answer. the criteria to disable/enable edit/delete column value of selected row. the scenario is: there are creator/viewer/approver in the system. I have the column which stores the status of the entries: new/submitted/approved. once the column:status has value submitted it is not editable. so for creator column:status new means editable row but column:status approved means non-editable row. hence the criteria to enable or disable the delete/edit is based on value in the column of the selected row rather than based on the row.
      singulars
      1. PO
      1. USharish
    2. CO@user668829: OK now it is clear. So use can modify my code and use `jqGrid('getCell',rowid,'status')` to get the value of "status" column of selected row. Then you can test whether the value is "submitted" and call `addClass('ui-state-disabled')` or `removeClass('ui-state-disabled')` like I do this in my answer. If the problem is solved you can "accept" my answer (see [here](http://meta.stackexchange.com/questions/5234/how-does-accepting-an-answer-work/5235#5235) for details)
      singulars
      1. PO
      1. USOleg
    3. CO@Oleg: Why do you `if (selRowId !== rowid`? If i select the editable row and than click it a second time the edit/delete buttons get disabled. By intention?
      singulars
      1. PO
      1. USStahlkocher
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload