Databases
StackOverflow2013
Postsdbo
POjqGrid filterToolbar passing _search:false on search
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjqGrid filterToolbar passing _search:false on search
    primarykey
    data
    text
    <p>I have been using jqGrid for a few months now, and I have made a handful of data grids with the filterToolbar option:</p> <pre><code>$('#grid_id').jqGrid('filterToolbar'); </code></pre> <p>It has worked perfectly in the past (passing an array of POST variables to the php page defined in the url option in the jqGrid definition, of which there is one variable "_search:true"). The most recent grid I made, after I press enter on the filterToolar, it just reloads the grid... passing "_search:false" to the php script. Does anyone know why this would be happening. here is the script;</p> <pre><code>$('#processed_list').jqGrid({ url:'/phpAJA?&amp;sql=' + sql, editurl: '/phpAJAX?sql=' + sql, height: 225, width: 600, datatype: 'xml', mtype: 'POST', colModel:[ {name:"Invoice Num",index:"InvoiceNum",width:"8"}, {name:"Job Num", index:"JobNum",width:"8"}, {name:"Customer",index:"Customer",width:"16"}, {name:"Emailed To",index:"to_email",width:"16"}, {name:"Date Processed",index:"timestamp",width:"16"} ], pager: '#pager', rowNum:10, rowList:[10,20,30], sortname: 'invid', sortorder: 'desc', viewrecords: true, gridview: true, caption: 'Processed Invoices', editable: false }); $("#processed_list") .jqGrid('navGrid', '#pager', {edit: false,add: false, del: false, search: false, refresh:true},{},{},{},{},{}) .jqGrid('navButtonAdd',"#pager",{ caption:"reprint invoice", buttonicon:"ui-icon-print", onClickButton:function(){ ...some function... }, position: "last", title:"", cursor: "pointer" }) .jqGrid('filterToolbar'); </code></pre> <p>Like I said, it all works except when I try the toolbarFilter search, it just reloads the grid (passing "_search:false" to the php script).</p> <p>Any help would be greatly appreciate.</p> <p>Thanks.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJustin Ethier
    1. USjeffery_the_wind
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POjqGrid filterToolbar passing _search:false on search
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSo I figured out the problem with a little trial and error. The filterToolbar was referencing the column names in the colModel, and not the index, which it should be referencing. So in the colModel option in the jqGrid definition I have to change the names to the real names in the database, and then add the other colName option to reset the column headings in the web page.
      singulars
      1. POjqGrid filterToolbar passing _search:false on search
      1. USjeffery_the_wind
    2. COPlease post your comment as an answer, so this question does not go unanswered in the SO system.
      singulars
      1. POjqGrid filterToolbar passing _search:false on search
      1. USJustin Ethier
    3. COI commented my answer because of the posting guidelines for new users, it wouldn't let me post an answer at that time. I will post the answer now.
      singulars
      1. POjqGrid filterToolbar passing _search:false on search
      1. USjeffery_the_wind
 

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