<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: achieve rowspan ,using pager</title>
	<link>http://www.trirand.com/blog/?page_id=393/discussion/achieve-rowspan-using-pager</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/discussion/achieve-rowspan-using-pager/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>ss on achieve rowspan ,using pager</title>
        	<link>http://www.trirand.com/blog/?page_id=393/discussion/achieve-rowspan-using-pager#p30931</link>
        	<category>Discussion</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/discussion/achieve-rowspan-using-pager#p30931</guid>
        	        	<description><![CDATA[<p>Hi,</p>
<p>Â </p>
<p>I have a jqGrid table with rowspan attribute set.It renders fine, if I am on the same page.As soon as I change the page,rendering is lost i.e. doesn't display data correctly.Please help me to achieve rowspan across pages.</p>
<p>Â </p>
<p>My code :</p>
<p>Â $(function () {<br />
Â Â  Â Â Â  Â <br />
Â Â  Â Â Â  Â  //]]&#62;<br />
Â Â  Â <br />
Â Â  Â <br />
Â Â Â Â Â Â Â Â Â Â Â  'use strict';<br />
var prevCellVal = { cellId: undefined, value: undefined };<br />
var prevCell1Val = { cellId: undefined, value: undefined };<br />
var prevCell2Val = { cellId: undefined, value: undefined };<br />
Â Â Â Â Â Â Â Â Â Â Â  var mydata =[{<br />
Â Â  Â "email": "abc.def@abc.com",<br />
Â Â  Â "name": "abc, def",<br />
Â Â  Â "address": "USA"<br />
Â Â  Â <br />
},<br />
{<br />
Â Â  Â "email": "abc.dFef@abc.com",<br />
Â Â  Â "name": "abSFc, def",<br />
Â Â  Â "address": "USA"<br />
},<br />
{<br />
Â Â  Â "email": "awwwwwwwwwwwwwbc.def@abc.com",<br />
Â Â  Â "name": "abc, def",<br />
Â Â  Â "address": "USA"<br />
},<br />
{<br />
Â Â  Â "email": "abwwwwwwwwwwwwDc.def@abc.com",<br />
Â Â  Â "name": "aDbc, def",<br />
Â Â  Â "address": "UK"<br />
},<br />
{<br />
Â Â  Â "email": "FEabc.def@abc.com",<br />
Â Â  Â "name": "FDabc, def",<br />
Â Â  Â "address": "UK"<br />
},<br />
{<br />
Â Â  Â "email": "abDc.def@abc.com",<br />
Â Â  Â "name": "abc, def",<br />
Â Â  Â "address": "UK"<br />
},<br />
{<br />
Â Â  Â "email": "aDbc.def@abc.com",<br />
Â Â  Â "name": "aDbc, def",<br />
Â Â  Â "address": "UK"<br />
},<br />
{<br />
Â Â  Â "email": "abc.def@abc.com",<br />
Â Â  Â "name": "abc, def",<br />
Â Â  Â "address": "USA"<br />
},<br />
{<br />
Â Â  Â "email": "abwefwec.def@abc.com",<br />
Â Â  Â "name": "abwqewfdec, def",<br />
Â Â  Â "address": "USA"<br />
},<br />
{<br />
Â Â  Â "email": "awfwfwbc.def@abc.com",<br />
Â Â  Â "name": "awvferbc, def",<br />
Â Â  Â "address": "USA"<br />
},<br />
{<br />
Â Â  Â "email": "awwwwwwwwwwwwwwwwbc.def@abc.com",<br />
Â Â  Â "name": "abwvfwc, def",<br />
Â Â  Â "address": "USA"<br />
}];<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  Â <br />
Â Â Â Â Â Â Â Â Â Â Â  $("#list").jqGrid({<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  datatype: 'local',<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  data: mydata,<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  colNames: ['Email', 'Name', 'Address'],<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â  colModel: [<br />
Â Â Â Â Â Â Â  { name: 'email', width: 70, align: 'center',<br />
Â Â Â Â Â Â Â  Â <br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  cellattr: function (rowId, val, rawObject, cm, rdata) {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  var result;</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  if (prevCellVal.value == val) {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  result = ' style="display: none" rowspanid="' + prevCellVal.cellId + '"';<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  else {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  var cellId = this.id + '_row_' + rowId + '_' + cm.name;</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  result = ' rowspan="1" id="' + cellId + '"';<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  prevCellVal = { cellId: cellId, value: val };<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  return result;<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }<br />
Â Â Â Â Â Â Â  },<br />
Â Â Â Â Â Â Â  { name: 'name', width: 80, align: 'center',</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  cellattr: function (rowId, val, rawObject, cm, rdata) {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  var result;</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  if (prevCell1Val.value == val) {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  result = ' style="display: none" rowspanid="' + prevCell1Val.cellId + '"';<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  else {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  var cellId = this.id + '_row_' + rowId + '_' + cm.name+$('#list').jqGrid.getGridParam('page');</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  result = ' rowspan="1" id="' + cellId + '"';<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  prevCell1Val = { cellId: cellId, value: val };<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  return result;<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }<br />
Â Â  Â Â Â  Â Â Â  Â Â Â  Â Â Â  Â  },<br />
Â Â Â Â Â Â Â  { name: 'address', width: 90,</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  cellattr: function (rowId, val, rawObject, cm, rdata) {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  var result;</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  if (prevCell2Val.value == val) {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  result = ' style="display: none" rowspanid="' + prevCell2Val.cellId + '"';<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  else {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  var cellId = this.id + '_row_' + rowId + '_' + cm.name+$('#list').jqGrid.getGridParam('page');</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  result = ' rowspan="1" id="' + cellId + '"';<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  prevCell2Val = { cellId: cellId, value: val };<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  return result;<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }}<br />
Â Â Â Â Â  Â <br />
Â Â Â  ],<br />
Â Â Â Â Â Â Â Â Â Â  rowList:[5,10,20],<br />
rowNum:5,<br />
Â Â  Â Â Â  Â Â Â  pager: '#pager',<br />
Â Â  Â <br />
Â Â Â  gridview: true,<br />
Â Â Â  viewrecords: true,<br />
Â Â Â  height: '100%',<br />
Â Â Â  caption: 'Grid with rowSpan attributes',</p>
<p>Â Â Â  beforeSelectRow: function () {<br />
Â Â Â Â Â Â Â  return false;<br />
Â Â Â  },<br />
Â Â  gridComplete: function () {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  var grid = this;</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  $('td[rowspan="1"]', grid).each(function () {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  var spans = $('td[rowspanid="' + this.id + '"]', grid).length + 1;</p>
<p>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  if (spans &#62; 1) {<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  $(this).attr('rowspan', spans);<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }<br />
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  });<br />
Â Â Â Â Â Â Â Â Â Â Â  }<br />
});<br />
//$("#list").jqGrid('navGrid','#pager',{edit:false,add:false,del:false,reload:true}).trigger('reloadGrid');;<br />
Â Â  Â // $('#jQGridDemo').jqGrid('navGrid', '#jQGridDemoPager',<br />
});<br />
Â Â  </p>
<p>Â </p>
<p>HTML is :</p>
<p>....</p>
<p>&#60;body&#62;<br />
 &#60;table id="list"&#62;&#60;tr&#62;&#60;td /&#62;&#60;/tr&#62;&#60;/table&#62;<br />
 &#60;div id="pager"&#62;&#60;/div&#62;<br />
 &#60;/body&#62;</p>
<p>...</p>
<p>Â </p>
<p>Please help me with this.Appreciate your help!</p>
<p>Â </p>
<p>Thanks,</p>
<p>SS</p>
]]></description>
        	        	<pubDate>Fri, 08 Aug 2014 11:22:38 +0300</pubDate>
        </item>
</channel>
</rss>