title: jqGrid just show 10 rows
body: <p>I'm very confuse for this problem due I'm new in jqGrid.
  my data just show 10 rows. this my script;</p>
  
  <pre><code>jQuery("#list").jqGrid({
      url:'dounfinish.php?q=1',
      datatype: 'json',
      mtype: 'POST',
      closeafteredit:true,
      colNames:['id','Date', 'Line','Model','Lotno','Qty','PIC'],
      colModel :[ 
              {name:'id', index:'id', hidden:true, width:55}, 
              {name:'Date', index:'Date', width:90, editable:true, search:true, stype:'text',searchoption:{sopt:['cn']}}, 
              {name:'Line', index:'Line', width:80, editable:true, search:true, stype:'text',searchoptions:{sopt:['cn']}},
              {name:'Model', index:'Model', width:180, editable:true, search:true, stype:'text',searchoption:{sopt:['cn']}},
              {name:'Lotno', index:'Lotno', width:80, editable:true, search:true, stype:'text',searchoption:{sopt:['cn']}}, 
              {name:'Qty', index:'Qty', width:80, editable:true, search:true, stype:'text',searchoptions:{sopt:['cn']}},
              {name:'PIC', index:'PIC', width:180, editable:true, search:true, stype:'text',searchoption:{sopt:['cn']}}
              ],
  //      pager: jQuery('#pager'),
      gridview:true,
      pager: '#pager',
      width: '100%',
      height: '100%',
      rowNum:10,
      rowList:[10,20,30],
      sortname: 'Date',
      sortorder: "desc",
      viewrecords: true,
      loadonce: true,
  //      imgpath: 'themes/basic/images',
      caption: 'DAILY CHECK QTY',
      editurl:'process3.php',
      prmNames:{oper:'action',editoper:'editbaldefect',id:'def_id'}
  });
  </code></pre>
  
  <p>the case like:</p>
  
  <pre><code>loadonce: true result View 1 - 10 of 10 --&gt; column filter can work.
  loadonce: false result View 1 - 10 of 3500 --&gt; column filter not working.
  </code></pre>
  
  <p>Why?? </p>
  
  <hr>
  
  <p>at developer tools show:</p>
  
  <pre><code>{"page":1,"total":33223,"records":"332222","rows":[]}
  </code></pre>
  
  <p>but at php page appears:
  <img src="https://i.stack.imgur.com/hhfro.png" alt="enter image description here"></p>
  
  <hr>
  
  <p>UPDATE</p>
  
  <p>my jqgrid using <code>datetype : json</code> and also need <code>loadonce : true</code>.I already trial like this:</p>
  
  <ol>
  <li>change loadonce : false --> result all records show but can't use toolbar filter</li>
  <li>change loadonce : true --> result only show 10 records but toolbar filter can work</li>
  <li>loadonce : true, rowNum: 50 --> data show only 50 (next button disable)</li>
  <li>check query at phpmyadmin --> result all data can show (query OK)</li>
  <li>using another table (OK one) --> result still not work</li>
  <li>Using another page then attach jqgrid --> still not work</li>
  </ol>
  
  <p>why jqgrid just retrieve 10 records only however this table actually have 100.000 records?
  and why just this table whereas another table can work.</p>