<?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: Problem with Search and Sort</title>
	<link>http://www.trirand.com/blog/?page_id=393/treegrid/problem-with-search-and-sort</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/treegrid/problem-with-search-and-sort/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>kraxxus on Problem with Search and Sort</title>
        	<link>http://www.trirand.com/blog/?page_id=393/treegrid/problem-with-search-and-sort#p22978</link>
        	<category>TreeGrid</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/treegrid/problem-with-search-and-sort#p22978</guid>
        	        	<description><![CDATA[<p>Hi guys,</p>
<p>i am a little confused about these features. With local data in "adjacency" mode sort does nothing, in "nested" sorts only roots items.</p>
<p>But when I use providing data by url sorting works great in nested. But when i want to searching it doesnt work.</p>
<p>I use this code for providing</p>
<p>if( (integer)$_REQUEST["nodeid"]&#160;&#62;0) {<br /> $n_lft = (integer)$_REQUEST["n_left"];<br /> $n_rgt = (integer)$_REQUEST["n_right"];<br /> $n_lvl = (integer)$_REQUEST["n_level"];</p>
<p>$n_lvl = $n_lvl+1;<br /> $SQL = "SELECT account_id, name, acc_num, debit, credit, balance, level, lft, rgt FROM accounts WHERE lft &#62; ".$n_lft." AND rgt &#60; ".$n_rgt." AND level = ".$n_lvl." ORDER BY lft";<br />} else { <br /> // initial grid<br /> $SQL = "SELECT account_id, name, acc_num, debit, credit, balance, level, lft, rgt FROM accounts WHERE level=0 ORDER BY lft";<br />}</p>
<p>But search request don&#180;t contain $_REQUEST["nodeid"]. So always i send the init grid.</p>
<p>Is here way to do searching on treegrid with providing data?</p>
</p>
<p>Here is my config:</p>
<p>var grid = $("#GroupHierarchyGrid");<br /> grid.jqGrid({<br /> url: &#39;/_layouts/SPTools/GroupHierarchyGridProvider.aspx?Source=&#39; + window.location.href,<br /> treedatatype: "xml",<br /> mtype: "POST",<br /> colNames: ["id", "spid", "Title", "Members", "TaskListUrl", "Users"],<br /> colModel: [<br /> { name: &#39;id&#39;, width: 25, align: "center", hidden: true, key: true },<br /> { name: &#39;spid&#39;, width: 25, align: "center", hidden: true },<br /> { name: &#39;name&#39;, search: true, stype: &#39;text&#39; },<br /> { name: &#39;Members&#39;, align: "left", search: true, stype: &#39;text&#39; },<br /> { name: &#39;TaskListUrl&#39;, align: "left", stype: &#39;text&#39;, search: true },<br /> { name: &#39;Users&#39;, align: "left", search: true, stype: &#39;text&#39; }<br /> ],<br /> treeGrid: true,<br /> treeGridModel: &#39;nested&#39;,<br />ExpandColumn: &#39;name&#39;,<br /> height: &#39;auto&#39;,<br /> width: &#39;800&#39;,<br /> pager: "#ptreegrid",<br /> caption: "Treegrid"<br /> })</p>
<p> grid.jqGrid(&#39;filterToolbar&#39;, {<br /> searchOnEnter: true<br /> , stringResult: true<br />&#160;, defaultSearch: &#39;cn&#39;}<br /> });</p>
<p>&#160;Thank You very match</p></p>
]]></description>
        	        	<pubDate>Fri, 29 Apr 2011 13:34:26 +0300</pubDate>
        </item>
</channel>
</rss>