HOW TO jqGrid common solutions

Allow FireFox to work with RTL (Right To Left) languages

jqGrid fully supports RTL in FireFox versions 3.x and Internet Explorer versions >=6 The default settings in FireFox are not compatible with RTL. In order to change this:

  1. In the url bar in FireFox type about:config and confirm the alert dialog.
  2. In the Find bar type layout.scrollbar.side
  3. Double click on it and change the value from 0 to 1
RTL support is available from version 3.6 and up

Configuring jqGrid to use only the new API

This should be done in the installation procedure following these steps:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<title>My First Grid</title>
 
<link rel="stylesheet" type="text/css" media="screen" href="css/ui-lightness/jquery-ui-1.7.1.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css" />
 
<script src="js/jquery-1.3.2.min.js" type="text/javascript"></script>
<script src="js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script type="text/javascript">
	jQuery.jgrid.no_legacy_api = true;
</script>
<script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>
 
</head>
<body>
...
</body>
</html>

Note the callling of

<script type="text/javascript">
	jQuery.jgrid.no_legacy_api = true;
</script>

This line should be after the language file and before the jqGrid JS file

New jqGrid API is available from version 3.6 and up

Client side sorting, but server side paging

In order to have this we should define two events in the grid - loadComplete and onPaging. Below is the code how can be this achieved

jQuery("#gridid").jqGrid({
...
datatype: 'json', // can be xml
loadComplete : function () {
   jQuery("#gridid").jqGrid('setGridParam',{datatype:'local'});
},
onPaging : function(which_button) {
   jQuery("#gridid").jqGrid('setGridParam',{datatype:'json'});
},
...
});

In order local sorting to work properly a sorttype parameter in colModel should be set

Discussion

pablo medici, 2011/12/05 20:12

Hi, i'm new in jqgrid. I've tried client side sorting with server side paging. While the server-side paging worked fine, the sorting didn't. When i try to sort the data disappears. Any ideas?

raghu krishna, 2011/12/06 06:29

Hi, Is there any possibility to disable a row in jqGrid?

You could leave a comment if you were logged in.

QR Code
QR Code wiki:howto_grid_base (generated for current page)