Databases
StackOverflow2013
Postsdbo
POImplementing search feature on jqgrid?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POImplementing search feature on jqgrid?
    text
    copied!<p>I tried so hard, I don't understand what is missing in my code.</p> <p>ASP:</p> <pre><code>SEARCHFIELD = Request.QueryString("SEARCHFIELD") SEARCHSTRING = Request.QueryString("SEARCHSTRING") SEARCHOPER = Request.QueryString("SEARCHOPER") </code></pre> <p>JavaScript:</p> <pre><code>var lastsel; $(function() { $("#list").jqGrid({ url: 'orders.cs.asp?Process=ViewOrders', datatype: 'xml', mtype: 'Get', height: '100%', colNames: ['Actions','ID #','Customer', 'Date', 'Status','Total','Tracking #'], colModel: [ {name:'Actions', index:'Actions', width:65, sortable:false, search:false}, {name:'ID', index:'ID', width:30}, {name:'Customer', index:'Customer', width:150}, {name:'Date', index:'Date', width:150}, {name:'TransactStatus', index:'TransactStatus', width:130, editable:true, edittype:"select", editoptions:{value:"Pending:Pending;Awaiting Payment:Awaiting Payment;Awaiting Fulfillment:Awaiting Fulfillment;Awaiting Shipment:Awaiting Shipment;Awaiting Pickup:Awaiting Pickup;Partially Shipped:Partially Shipped;Completed:Completed;Shipped:Shipped;Cancelled:Cancelled;Declined:Declined;Refunded:Refunded"}}, {name:'Total', index:'Total', width:80, align:"right"}, {name:'ShipTrackingNumber', index:'ShipTrackingNumber', width:126, editable:true}, ], pager: jQuery('#pager'), rowNum: 10, rowList: [10,20,30], sortname: 'Date', sortorder: 'desc', viewrecords: true, subGrid : true, subGridUrl: 'orders.cs.asp?Process=ViewOrderDetails', subGridModel: [ { name: ['Quantity','Product','-', '-', '-'], width : [65,350,50,50,50], param: ['invdate'] } ], imgpath: 'js/jqGrid/themes/basic/images', onSelectRow: function(id) { if(id &amp;&amp; id!==lastsel) { $('#list').restoreRow(lastsel); $('#list').editRow(id,true); lastsel=id; } }, loadComplete: function(){ var ids = jQuery("#list").getDataIDs(); for(var i=0;i&lt;ids.length;i++){ var cl = ids[i]; be = "&lt;input style='height:22px;width:20px;' type='button' value='E' onclick=jQuery('#list').editRow("+cl+"); &gt;&lt;/ids&gt;"; se = "&lt;input style='height:22px;width:20px;' type='button' value='S' onclick=jQuery('#list').saveRow("+cl+"); /&gt;"; ce = "&lt;input style='height:22px;width:20px;' type='button' value='C' onclick=jQuery('#list').restoreRow("+cl+"); /&gt;"; jQuery("#list").setRowData(ids[i],{Actions:be+se+ce}) } }, editurl: "orders.cs.asp?Process=EditOrder", }).navGrid("#pager",{edit:true,add:false,del:false}); }); </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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