<?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 Options 3.5.2</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/problem-with-search-options-352</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/problem-with-search-options-352/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>tony on Problem with Search Options 3.5.2</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/problem-with-search-options-352#p8781</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/problem-with-search-options-352#p8781</guid>
        	        	<description><![CDATA[<p>As of your code you should</p>
</p>
<p>....navGrid(&#39;<strong>#pager</strong>&#39;,<br />{<br />&#160;edit:false,add:false,del:false,search:true,refresh:true<br />},<br />{}, // edit options<br />{}, // add options<br />{}, //del options<br />{multipleSearch:true} // search options<br />);&#160;</p>
<p>Regards</p>
<p>Tony</p>
]]></description>
        	        	<pubDate>Wed, 19 Aug 2009 05:26:37 +0300</pubDate>
        </item>
        <item>
        	<title>Jim P on Problem with Search Options 3.5.2</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/problem-with-search-options-352#p8718</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/problem-with-search-options-352#p8718</guid>
        	        	<description><![CDATA[<p>Tony,</p>
<p>I can&#39;t get the search options to work in latest release (3.5.2).&#160; Below is my advance search attempt.&#160; The filter option does not appear on the pager bar.&#160; I&#39;ve looked at the examples and have read the download notes.&#160; What am I doing wrong?&#160;</p>
<p>Thanks,&#160;&#160;</p>
<p>Jim</p>
</p>
<p>MY CSS &#38; JS:</p>
<p>&#60;link rel="stylesheet" type="text/css" media="screen" href="../css/ParViewForms.css" /&#62;<br />&#60;link rel="stylesheet" type="text/css" media="screen" href="../css/basic.css"&#160; /&#62;<br />&#60;link rel="stylesheet" type="text/css" media="screen" href="../css/jquery.autocomplete.css" /&#62;<br />&#60;link rel="stylesheet" type="text/css" media="screen" href="../css/ui.jqgrid.css" /&#62;<br />&#60;link rel="stylesheet" type="text/css" media="screen" href="../css/jquery.searchFilter.css" /&#62;<br />&#60;link rel="stylesheet" type="text/css" media="screen" href="../css/jquery-ui-1.7.2.custom.css" /&#62;</p>
<p>&#60;script src="jquery.js" type="text/javascript" &#62;&#60;/script&#62;<br />&#60;script src="js3-5/grid.locale-en.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js3-5/jquery.jqGrid.min.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/localdata.js" type=&#39;text/javascript&#39;&#62;&#60;/script&#62;<br />&#60;script src="js/jquery.autocomplete.min.js" type="text/javascript"&#62;&#60;/script&#62;</p>
<p>MY Grid:</p>
<p>&#160; &#60;script&#62;<br />// ********************************************************************************************<br />//&#160; Single List Option<br />// ********************************************************************************************<br />&#160;&#160; &#160;$(document).ready(function()<br />&#160;&#160;{<br />&#160;&#160;$("#CClist").jqGrid(<br />&#160;&#160;&#160;{url:&#39;Users.cfc?method=GetClosedCases&#38;thisBizOrg=&#60;cfoutput&#62;#session.bizorg_objid#&#38;thisDSN=#Application.DSN#&#38;thisAcctTyp=#session.AcctTyp#&#38;thisTZOff=#session.TZOff#&#38;thisTZ=#session.TZ#&#38;thisSiteID=#form.Site_ID#&#38;thisAltSiteID=#form.Alt_Site_ID#&#38;thisDatetyp=#form.Datetyp#&#38;thisFromDate=#form.from_date#&#38;thistoDate=#form.to_date#&#38;thisFldName=#form.FieldName#&#38;thisTestC=#form.testcondition#&#38;thisQData=#Form.QData#&#38;thisSrt1=#form.srt1#&#38;thisSO1=#form.srtOrd1#&#39;&#60;/cfoutput&#62;, //CFC that will return the users<br />&#160;&#160;&#160;&#160;datatype: &#39;json&#39;, //We specify that the datatype we will be using will be JSON<br />&#160;&#160;&#160;&#160;colNames:[&#39;Case ID&#39;,&#39;Site ID&#39;,&#39;Reported Problem&#39;,&#39;Closing Summary&#39;,&#39;Condition&#39;,&#39;Status&#39;,&#39;Priority&#39;,&#39;Contact&#39;,&#39;Created&#39;,&#39;Sort Date&#39;,&#39;Closed&#39;,&#39;Sort Closed&#39;,&#39;Alt Site ID&#39;,&#39;Cust Ref No&#39;,&#39;Acct Name&#39;,&#39;Email&#39;], //Column Names<br />&#160;&#160;&#160;&#160;//The Column Model to define the data. Note you can make columns non sortable, specify width, alignment, etc.<br />&#160;&#160;&#160;&#160;colModel :[<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; {name:&#39;id_number&#39;,index:&#39;id_number&#39;, align:"center", sorttype:"text", width: 70},<br />&#160;&#160;&#160;&#160;&#160;{name:&#39;site_id&#39;,index:&#39;site_id&#39;,&#160; align:"center",sorttype:"text", width: 60},<br />&#160;&#160;&#160;&#160;&#160;{name:&#39;title&#39;,index:&#39;title&#39;,&#160; align:"left", width: 100, sorttype:"text"},<br />&#160;&#160;&#160;&#160;&#160;{name:&#39;closing_summary&#39;,index:&#39;closing_summary&#39;,&#160; align:"left", width: 100, sorttype:"text"},&#160;&#160;&#160;&#160;&#160;<br />&#160;&#160;&#160;&#160;&#160; &#160;{name:&#39;condition&#39;,index:&#39;condition&#39;,&#160; align:"center", sorttype:"text", width: 54},<br />&#160;&#160;&#160;&#160;&#160;{name:&#39;status&#39;,index:&#39;status&#39;,&#160; align:"center", sorttype:"text", width: 60},<br />&#160;&#160;&#160;&#160;&#160;{name:&#39;priority&#39;,index:&#39;priority&#39;,&#160; align:"center", sorttype:"text", width: 60},<br />&#160;&#160;&#160;&#160;&#160;{name:&#39;last_name&#39;,index:&#39;last_name&#39;,&#160; align:"center", sorttype:"text", width: 60},<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; {name:&#39;creation_time&#39;,index:&#39;creation_time&#39;, align:"center", width: 90, formatter:&#39;date&#39;, formatoptions:{srcformat: &#39;m/d/Y H:i:s&#39;,newformat: &#39;&#60;cfoutput&#62;#session.myGridDateFormat#&#60;/cfoutput&#62;&#39;}},&#160;// m/d/Y H:i:s<br />&#160;&#160;&#160; &#160;&#160;{name:&#39;sort_creation_time&#39;,index:&#39;sort_creation_time&#39;, align:"center", hidden: true},<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; {name:&#39;case_close_date&#39;,index:&#39;case_close_date&#39;, align:"center", width: 90, formatter:&#39;date&#39;, formatoptions:{srcformat: &#39;m/d/Y H:i:s&#39;,newformat: &#39;&#60;cfoutput&#62;#session.myGridDateFormat#&#60;/cfoutput&#62;&#39;}},&#160;// m/d/Y H:i:s<br />&#160;&#160;&#160; &#160;&#160;{name:&#39;sort_case_close_date&#39;,index:&#39;sort_case_close_date&#39;, align:"center", hidden: true},&#160;&#160;&#160;&#160;&#160;<br />&#160;&#160;&#160;&#160;&#160;{name:&#39;alt_site_id&#39;,index:&#39;alt_site_id&#39;,&#160; align:"center", sorttype:"text", width: 60},<br />&#160;&#160;&#160;&#160;&#160;{name:&#39;x_cust_ref_no&#39;,index:&#39;x_cust_ref_no&#39;, search:true, sorttype:"text", width: 60},<br />&#160;&#160;&#160;&#160;&#160;{name:&#39;name&#39;,index:&#39;name&#39;, search:false, sortable:false, width:60},<br />&#160;&#160;&#160;&#160;&#160;{name:&#39;e_mail&#39;,index:&#39;e_mail&#39;, search:false, sortable:false, width: 80, formatter:&#39;email&#39;}<br />&#160;&#160;&#160;&#160;],<br />&#160;&#160;&#160;&#160;autowidth: true,<br />&#160;&#160;&#160;&#160;cellEdit: false,<br />&#160;&#160;&#160;&#160;pager: $(&#39;#pager&#39;), //,#pager2 The div we have specified, tells jqGrid where to put the pager<br />&#160;&#160;&#160;&#160;rowNum: &#60;cfoutput&#62;#session.maxlines#&#60;/cfoutput&#62;, //Number of records we want to show per page&#160;<br />&#160;&#160;&#160;&#160;sortorder: "", //Default sort order - desc<br />&#160;&#160;&#160;&#160;recreateFilter : true,<br />&#160;&#160;&#160;&#160;sortname: "priority", //Default sort column<br />&#160;&#160;&#160;&#160;viewrecords: true, //Shows the nice message on the pager<br />&#160;&#160;&#160;&#160;caption: &#39;Case Query&#39;, //Grid Name<br />&#160;&#160;&#160;&#160;height:&#39;auto&#39;,</p>
<p>&#160;&#160;&#160; mtype:&#39;GET&#39;,<br />&#160;&#160;&#160;&#160;postdata: "",&#160;&#160;<br />&#160;&#160;&#160;&#160;toolbar:[false,"top"],//Shows the toolbar at the top. I will decide if I need to put anything in there later.</p>
<p>&#160;&#160;&#160;&#160;// main grid code below<br />&#160;&#160;&#160;&#160;//The JSON reader. This defines what the JSON data returned from the CFC should look like<br />&#160;&#160;&#160;&#160;jsonReader: {<br />&#160;&#160;&#160;&#160;&#160;root: "ROWS",<br />&#160;&#160;&#160;&#160;&#160;page: "PAGE",<br />&#160;&#160;&#160;&#160;&#160;total: "TOTAL",<br />&#160;&#160;&#160;&#160;&#160;records:"RECORDS",<br />&#160;&#160;&#160;&#160;&#160;userdata: "USERDATA",<br />&#160;&#160;&#160;&#160;&#160;cell: "",<br />&#160;&#160;&#160;&#160;&#160;id: "0",<br />&#160;&#160;&#160;&#160;&#160;subgrid: {root: "ROWS", repeatitems: true, cell: "",id:"0"}<br />&#160;&#160;&#160;&#160;&#160;}<br />&#160;&#160;&#160;&#160;}<br />&#160;&#160;&#160;);&#160;&#160;&#160;</p>
<p>}).navGrid(&#39;#CCList&#39;,<br />{<br />&#160;edit:false,add:false,del:false,search:true,refresh:true<br />},<br />{}, // edit options<br />{}, // add options<br />{}, //del options<br />{multipleSearch:true} // search options<br />);&#160;&#160;<br />&#60;/script&#62;</p>
</p>
<p>**MY Divs</p>
<p>&#60;div id="search"&#62;&#60;/div&#62;<br />&#60;div id="g1"&#62;<br />&#160;&#160;&#160;&#160;&#160; &#60;table id="CClist" cellpadding="0" cellspacing="0"&#62;&#60;/table&#62;<br />&#160;&#160;&#160;&#160;&#160; &#60;div id="pager" style="text-align:center;"&#62;&#60;/div&#62;<br />&#160;&#60;/div&#62;</p>
]]></description>
        	        	<pubDate>Mon, 17 Aug 2009 15:01:57 +0300</pubDate>
        </item>
</channel>
</rss>