Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You have two main problems. The first one: the sorting. It's very easy to solve. jqGrid with <code>datatype: 'json'</code> ask the get <em>only one page of sorted data</em>. If the user change the sorting order or go to the next page for example the new request with another parameters will be send to the server.</p> <p>If you want that the data will be loaded <strong>only once from the server</strong> and then will be <em>locally</em> sorted or paged you need just add <code>loadonce: true</code> option to the grid. You have to returns still correctly sorted data to have correct sort order initially.</p> <p>For performance reason you should always include <code>gridview: true</code> to the list of used options.</p> <p>The next your problem with two formats of JSON data returned from the server you can solve in the simple way. You can modify the <code>jsonReader</code> to the following:</p> <pre><code>jsonReader: { repeatitems: false, id: "InternetAddress", root: function (obj) { if ($.isArray(obj)) { return obj; } if ($.isArray(obj.items)) { return obj.items; } return []; }, page: function () { return 1; }, total: function () { return 1; }, records: function (obj) { if ($.isArray(obj)) { return obj.length; } if ($.isArray(obj.items)) { return obj.items.length; } return 0; } } </code></pre> <p>The corresponding demos: <a href="http://www.ok-soft-gmbh.com/jqGrid/PSolano1.htm" rel="nofollow">the first one</a> and <a href="http://www.ok-soft-gmbh.com/jqGrid/PSolano2.htm" rel="nofollow">the second one</a> use the same code, but read different formatted JSON data (the data which you posted). Both produce the same results. I changed <code>rowNum</code> to <code>rowNum: 2</code> to demonstrate that local paging work. Additionally you can consider to use <code>height: 'auto'</code> instead of fixed value <code>height: 500</code>. The <code>rowNum</code> which you use will define the height of the grid.</p> <p>Additionally I included in the second demo the line</p> <pre><code>$("#list2").jqGrid('filterToolbar', {stringResult: true, defaultSearch: 'cn', searchOnEnter: false}); </code></pre> <p>to demonstrate the power of <a href="http://www.trirand.com/jqgridwiki/doku.php?id=wiki%3atoolbar_searching" rel="nofollow">local data filtering</a>. I added one more option <code>ignoreCase: true</code> to have case insensitive filtering/searching of data.</p>
    singulars
    1. This table or related slice is empty.
    1. POGetting and sorting from JSON on jqGrid
      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. POGetting and sorting from JSON on jqGrid
      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. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COExcellent answer @Oleg... just FYI; what I had before was because I found some answers from you to others developers :)
      singulars
      1. PO
      1. USPSolano
    2. CO@PSolano: OK! If the problem is solved you can mark the answer as ["accepted"](http://meta.stackexchange.com/a/5235/147495). I recommend you additionally use your right to vote up to 30 questions or answers **per day** (see [here](http://meta.stackexchange.com/a/5213/147495)). Just do this if you find any *helpful* information on the stackoverflow. It helps other visitors in searching on the stackoverflow. The searching engine use voting as the main criteria.
      singulars
      1. PO
      1. USOleg
    3. COIs there any reason why your two examples http://www.ok-soft-gmbh.com/jqGrid/PSolano1.htm and http://www.ok-soft-gmbh.com/jqGrid/PSolano2.htm don't display <X> of <Y> on pager section? It works fine if I'm not using JSON datatype.
      singulars
      1. PO
      1. USPSolano
 

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