<?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: Jqgrid Search on a formatted column</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/jqgrid-search-on-a-formatted-column</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/help/jqgrid-search-on-a-formatted-column/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>kirangunda on Jqgrid Search on a formatted column</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/jqgrid-search-on-a-formatted-column#p28930</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/jqgrid-search-on-a-formatted-column#p28930</guid>
        	        	<description><![CDATA[<p>Hi,</p>
<p>I have implemented Jqgrid search on sinlge column using below code. I have a textbox,when i enter some text and click on a button it will filter the data on JqGrid. Here i am doing search on Name column.</p>
<p>&#160;$(&#39;#btnSearchAssociatedClients&#39;).click(function() {<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; var grid = $(&#39;#tblAssociateClientSummary&#39;);<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; var relatedClientName = $(&#39;#txtRelatedClientName&#39;).val();<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; var postdata = grid.jqGrid(&#39;getGridParam&#39;, &#39;postData&#39;);<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; // build up the filter<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; // [&#39;equal&#39;,&#39;not equal&#39;, &#39;less&#39;, &#39;less or equal&#39;,&#39;greater&#39;,&#39;greater or equal&#39;, &#39;begins with&#39;,&#39;does not begin with&#39;,&#39;is in&#39;,&#39;is not in&#39;,&#39;ends with&#39;,&#39;does not end with&#39;,&#39;contains&#39;,&#39;does not contain&#39;]<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; // [&#39;eq&#39;,&#39;ne&#39;,&#39;lt&#39;,&#39;le&#39;,&#39;gt&#39;,&#39;ge&#39;,&#39;bw&#39;,&#39;bn&#39;,&#39;in&#39;,&#39;ni&#39;,&#39;ew&#39;,&#39;en&#39;,&#39;cn&#39;,&#39;nc&#39;]<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; var myfilter = { groupOp: "OR", rules: [] };<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; myfilter.rules.push({ field: "Name", op: "cn", data: relatedClientName });</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160; $.extend(postdata, { filters: myfilter });<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; grid.jqGrid(&#39;setGridParam&#39;, { search: relatedClientName.length &#62; 1, postData: postdata });<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; grid.trigger("reloadGrid", [{ page: 1 }]);<br />&#160;&#160;&#160; });</p>
</p>
<p>In the code the Name column is using below formatter so it will combine first name and last name.</p>
<p>var nameFormatter = function(cellValue, options, rowData) {<br />&#160;&#160;&#160; return rowData.FirstName+" "+rowData.LastName;<br />};</p>
<p><strong>Note:- The data also contains Name column which has different data.</strong></p>
<p>My problem is the search is working on Name column data, not on the displayed data.. Please provide me the solution how to implement search on formatted data.</p>
]]></description>
        	        	<pubDate>Fri, 31 May 2013 22:08:42 +0300</pubDate>
        </item>
</channel>
</rss>