<?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: Newbi Frustrated. Can't get tree to show...</title>
	<link>http://www.trirand.com/blog/?page_id=393/treegrid/newbi-frustrated-cant-get-tree-to-show</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/newbi-frustrated-cant-get-tree-to-show/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>selmer57 on Newbi Frustrated. Can't get tree to show...</title>
        	<link>http://www.trirand.com/blog/?page_id=393/treegrid/newbi-frustrated-cant-get-tree-to-show#p27752</link>
        	<category>TreeGrid</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/treegrid/newbi-frustrated-cant-get-tree-to-show#p27752</guid>
        	        	<description><![CDATA[<p>I&#39;m so frustrated. Been searching examples and forums for 3 days trying to get a tree grid to show.</p>
<p>Any help would be so appreciated.</p>
<p>Here is my header:</p>
<p style="padding-left: 30px;">&#60;link rel="stylesheet" type="text/css" media="screen" href="css/smoothness/jquery-ui-1.9.1.custom.css" /&#62;</p>
<p style="padding-left: 30px;">&#60;link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css" /&#62;</p>
<p style="padding-left: 30px;">&#60;link rel="stylesheet" type="text/css" media="screen" href="css/jquery.ui.accordion.css" /&#62;</p>
<p style="padding-left: 30px;">&#60;link rel="stylesheet" type="text/css" media="screen" href="css/searchFilter.css" /&#62;</p>
<p style="padding-left: 30px;">&#60;style&#62;</p>
<p style="padding-left: 30px;">body {font-size:10px;</p>
<p style="padding-left: 30px;">}</p>
<p style="padding-left: 30px;">&#60;/style&#62;</p>
<p style="padding-left: 30px;">&#60;script src="js/jquery-1.8.3.min.js" type="text/javascript"&#62;&#60;/script&#62;</p>
<p style="padding-left: 30px;">&#60;script src="js/jquery-ui-1.9.1.custom.min.js"&#62;&#60;/script&#62;</p>
<p style="padding-left: 30px;">&#60;script src="js/grid.locale-en.js" type="text/javascript"&#62;&#60;/script&#62;</p>
<p style="padding-left: 30px;">&#60;script src="js/jquery.jqGrid.min.js" type="text/javascript"&#62;&#60;/script&#62;</p>
<p>Here is my body:</p>
<p style="padding-left: 30px;">&#60;div id="wrapper"&#160; style="background-color:#FFFFFF"&#62;<br />&#160;&#60;div id="dtables" style="width:50%;float:left;"&#62;<br />&#160;&#160;&#60;h3&#62;Tables&#60;/h3&#62;<br />&#160;&#160;&#160;&#60;div id="tblOutput"&#62;<br />&#160;&#160;&#160;&#160;&#60;table id="gridPeople"&#62;&#60;/table&#62;<br />&#160;&#160;&#160;&#160;&#60;div id="plist485"&#62;&#60;/div&#62;<br />&#160;&#160;&#160;&#160;&#60;table id="gridProduct"&#62;&#60;/table&#62;<br />&#160;&#160;&#160;&#160;&#60;table id="gridProcess"&#62;&#60;/table&#62;<br />&#160;&#160;&#160;&#160;&#60;table id="gridPerformance"&#62;&#60;/table&#62;<br />&#160;&#160;&#160;&#60;/div&#62;<br />&#160;&#160;&#60;h3&#62;Status&#60;/h3&#62;<br />&#160;&#160;&#160;&#60;div&#62;<br />&#160;&#160;&#160;&#60;/div&#62;<br />&#160;&#60;/div&#62;<br />&#160;<br />&#160;&#60;div id="gauges" style="width:50%;float:right"&#62;<br />&#160;&#60;/div&#62;<br />&#60;/div&#62;</p>
<p>Here is my script:</p>
<p style="padding-left: 30px;">jQuery.extend($.fn.fmatter , {</p>
<p style="padding-left: 30px;">PointFmatter : function(cellvalue, options, rowdata) {</p>
<p style="padding-left: 30px;">if (cellvalue &#62; 90) {</p>
<p style="padding-left: 30px;">return &#39;&#60;span style="color:blue;"&#62;&#39; + cellvalue + &#39;&#60;/span&#62;&#39;;</p>
<p style="padding-left: 30px;">} else if (cellvalue &#62; 80) {</p>
<p style="padding-left: 30px;">return &#39;&#60;span style="color:green;"&#62;&#39; + cellvalue + &#39;&#60;/span&#62;&#39;;</p>
<p style="padding-left: 30px;">} else if (cellvalue &#62; 70) {</p>
<p style="padding-left: 30px;">return &#39;&#60;span style="color:orange;"&#62;&#39; + cellvalue + &#39;&#60;/span&#62;&#39;;</p>
<p style="padding-left: 30px;">} else {</p>
<p style="padding-left: 30px;">return &#39;&#60;span style="color:red;"&#62;&#39; + cellvalue + &#39;&#60;/span&#62;&#39;;</p>
<p style="padding-left: 30px;">}</p>
<p style="padding-left: 30px;">}</p>
<p style="padding-left: 30px;">});</p>
<p style="padding-left: 30px;">jQuery("#gridPeople").jqGrid({</p>
<p style="padding-left: 30px;">treeGrid: true,</p>
<p style="padding-left: 30px;">treeGridModel: &#39;adjacency&#39;,</p>
<p style="padding-left: 30px;">url:&#39;data/people_995.xml&#39;,</p>
<p style="padding-left: 30px;">datatype: "xml",</p>
<p style="padding-left: 30px;">ExpandColumn : &#39;Subjectname&#39;,</p>
<p style="padding-left: 30px;">height: &#39;auto&#39;,</p>
<p style="padding-left: 30px;">// hiddengrid: true,</p>
<p style="padding-left: 30px;">colNames:[&#39;id&#39;,&#39;Subject&#39;,&#39;measure&#39;,&#39;Week&#39;, &#39;MTD&#39;, &#39;QTD&#39;,&#39;YTD&#39;],</p>
<p style="padding-left: 30px;">viewRecords:true,</p>
<p style="padding-left: 30px;">colModel:[</p>
<p style="padding-left: 30px;">{name:&#39;id&#39;, index:&#39;id&#39;, hidden:true,key:true},</p>
<p style="padding-left: 30px;">{name:&#39;Subjectname&#39;,index:&#39;Subjectname&#39;, width:140},</p>
<p style="padding-left: 30px;">{name:&#39;SubSubjectName&#39;,index:&#39;SubSubjectName&#39;, width:140, align:&#39;right&#39;},</p>
<p style="padding-left: 30px;">{name:&#39;WTD&#39;,index:&#39;WTD&#39;, width:60, align:&#39;center&#39;, sorttype:&#39;float&#39;,formatter:&#39;PointFmatter&#39;},</p>
<p style="padding-left: 30px;">{name:&#39;MTD&#39;,index:&#39;MTD&#39;, width:60, align:&#39;center&#39;, sorttype:&#39;float&#39;,formatter:&#39;PointFmatter&#39;},</p>
<p style="padding-left: 30px;">{name:&#39;QTD&#39;,index:&#39;QTD&#39;, width:60, align:&#39;center&#39;, sorttype:&#39;float&#39;,formatter:&#39;PointFmatter&#39;},</p>
<p style="padding-left: 30px;">{name:&#39;YTD&#39;,index:&#39;YTD&#39;, width:60, align:&#39;center&#39;, sorttype:&#39;float&#39;,formatter:&#39;PointFmatter&#39;}</p>
<p style="padding-left: 30px;">],</p>
<p style="padding-left: 30px;">caption: "&#60;span style=&#39;margin-left:20px&#39;&#62;People&#60;/span&#62;"</p>
<p style="padding-left: 30px;">});</p>
<p>And here is my xml:</p>
<p style="padding-left: 30px;">&#60;?xml version="1.0&#8243;?&#62;</p>
<p style="padding-left: 30px;">&#60;Rows&#62;</p>
<p style="padding-left: 30px;">&#60;page&#62;1&#60;/page&#62;</p>
<p style="padding-left: 30px;">&#60;total&#62;2&#60;/total&#62;</p>
<p style="padding-left: 30px;">&#60;records&#62;6&#60;/records&#62;</p>
<p style="padding-left: 30px;">&#60;Row id="1&#8243;&#62;</p>
<p style="padding-left: 30px;">&#60;Subjectname&#62;Motor Vehicle Incidents&#60;/Subjectname&#62;</p>
<p style="padding-left: 30px;">&#60;SubSubjectName&#62; &#60;/SubSubjectName&#62;</p>
<p style="padding-left: 30px;">&#60;WTD&#62;70&#60;/WTD&#62;</p>
<p style="padding-left: 30px;">&#60;MTD&#62;75&#60;/MTD&#62;</p>
<p style="padding-left: 30px;">&#60;QTD&#62;80&#60;/QTD&#62;</p>
<p style="padding-left: 30px;">&#60;YTD &#62;81&#60;/YTD&#62;</p>
<p style="padding-left: 30px;">&#60;level&#62;0&#60;/level&#62;</p>
<p style="padding-left: 30px;">&#60;parent&#62;&#60;/parent&#62;</p>
<p style="padding-left: 30px;">&#60;isLeaf&#62;false&#60;/isLeaf&#62;</p>
<p style="padding-left: 30px;">&#60;expanded&#62;false&#60;/expanded&#62;</p>
<p style="padding-left: 30px;">&#60;/Row&#62;</p>
<p style="padding-left: 30px;">&#60;Row id="2&#8243;&#62;</p>
<p style="padding-left: 30px;">&#60;Subjectname&#62;Motor Vehicle Incidents&#60;/Subjectname&#62;</p>
<p style="padding-left: 30px;">&#60;SubSubjectName&#62;Motor Vehicle Incidents&#60;/SubSubjectName&#62;</p>
<p style="padding-left: 30px;">&#60;WTD&#62;0&#60;/WTD&#62;</p>
<p style="padding-left: 30px;">&#60;MTD&#62;0&#60;/MTD&#62;</p>
<p style="padding-left: 30px;">&#60;QTD&#62;0&#60;/QTD&#62;</p>
<p style="padding-left: 30px;">&#60;YTD&#62;0&#60;/YTD&#62;</p>
<p style="padding-left: 30px;">&#60;level&#62;1&#60;/level&#62;</p>
<p style="padding-left: 30px;">&#60;parent&#62;1&#60;/parent&#62;</p>
<p style="padding-left: 30px;">&#60;isLeaf&#62;true&#60;/isLeaf&#62;</p>
<p style="padding-left: 30px;">&#60;expanded&#62;false&#60;/expanded&#62;</p>
<p style="padding-left: 30px;">&#60;/Row&#62;</p>
<p style="padding-left: 30px;">&#60;Row id="3&#8243;&#62;</p>
<p style="padding-left: 30px;">&#60;Subjectname&#62;OSHA Incidents&#60;/Subjectname&#62;</p>
<p style="padding-left: 30px;">&#60;SubSubjectName/&#62;</p>
<p style="padding-left: 30px;">&#60;WTD&#62;0&#60;/WTD&#62;</p>
<p style="padding-left: 30px;">&#60;MTD&#62;0&#60;/MTD&#62;</p>
<p style="padding-left: 30px;">&#60;QTD&#62;0&#60;/QTD&#62;</p>
<p style="padding-left: 30px;">&#60;YTD&#62;0&#60;/YTD&#62;</p>
<p style="padding-left: 30px;">&#60;level&#62;0&#60;/level&#62;</p>
<p style="padding-left: 30px;">&#60;parent&#62;&#60;/parent&#62;</p>
<p style="padding-left: 30px;">&#60;isLeaf&#62;false&#60;/isLeaf&#62;</p>
<p style="padding-left: 30px;">&#60;expanded&#62;false&#60;/expanded&#62;</p>
<p style="padding-left: 30px;">&#60;/Row&#62;</p>
<p style="padding-left: 30px;">&#60;Row id="4&#8243;&#62;</p>
<p style="padding-left: 30px;">&#60;Subjectname&#62;OSHA Incidents&#60;/Subjectname&#62;</p>
<p style="padding-left: 30px;">&#60;SubSubjectName&#62;OSHA Incidents&#60;/SubSubjectName&#62;</p>
<p style="padding-left: 30px;">&#60;WTD&#62;0&#60;/WTD&#62;</p>
<p style="padding-left: 30px;">&#60;MTD&#62;0&#60;/MTD&#62;</p>
<p style="padding-left: 30px;">&#60;QTD&#62;0&#60;/QTD&#62;</p>
<p style="padding-left: 30px;">&#60;YTD&#62;0&#60;/YTD&#62;</p>
<p style="padding-left: 30px;">&#60;level&#62;1&#60;/level&#62;</p>
<p style="padding-left: 30px;">&#60;parent&#62;3&#60;/parent&#62;</p>
<p style="padding-left: 30px;">&#60;isLeaf&#62;true&#60;/isLeaf&#62;</p>
<p style="padding-left: 30px;">&#60;expanded&#62;false&#60;/expanded&#62;</p>
<p style="padding-left: 30px;">&#60;/Row&#62;</p>
<p style="padding-left: 30px;">&#60;Row id="5&#8243;&#62;</p>
<p style="padding-left: 30px;">&#60;Subjectname&#62;Vacant Rate F1, 2B, 4&#60;/Subjectname&#62;</p>
<p style="padding-left: 30px;">&#60;SubSubjectName/&#62;</p>
<p style="padding-left: 30px;">&#60;WTD&#62;0&#60;/WTD&#62;</p>
<p style="padding-left: 30px;">&#60;MTD&#62;0&#60;/MTD&#62;</p>
<p style="padding-left: 30px;">&#60;QTD&#62;0&#60;/QTD&#62;</p>
<p style="padding-left: 30px;">&#60;YTD&#62;0&#60;/YTD&#62;</p>
<p style="padding-left: 30px;">&#60;level&#62;0&#60;/level&#62;</p>
<p style="padding-left: 30px;">&#60;parent&#62;&#60;/parent&#62;</p>
<p style="padding-left: 30px;">&#60;isLeaf&#62;false&#60;/isLeaf&#62;</p>
<p style="padding-left: 30px;">&#60;expanded&#62;false&#60;/expanded&#62;</p>
<p style="padding-left: 30px;">&#60;/Row&#62;</p>
<p style="padding-left: 30px;">&#60;Row id="6&#8243;&#62;</p>
<p style="padding-left: 30px;">&#60;Subjectname&#62;Vacant Rate F1, 2B, 4&#60;/Subjectname&#62;</p>
<p style="padding-left: 30px;">&#60;SubSubjectName&#62;Vacant Rate F1, 2B, 4&#60;/SubSubjectName&#62;</p>
<p style="padding-left: 30px;">&#60;WTD&#62;0&#60;/WTD&#62;</p>
<p style="padding-left: 30px;">&#60;MTD&#62;0&#60;/MTD&#62;</p>
<p style="padding-left: 30px;">&#60;QTD&#62;0&#60;/QTD&#62;</p>
<p style="padding-left: 30px;">&#60;YTD&#62;0&#60;/YTD&#62;</p>
<p style="padding-left: 30px;">&#60;level&#62;1&#60;/level&#62;</p>
<p style="padding-left: 30px;">&#60;parent&#62;5&#60;/parent&#62;</p>
<p style="padding-left: 30px;">&#60;isLeaf&#62;true&#60;/isLeaf&#62;</p>
<p style="padding-left: 30px;">&#60;expanded&#62;false&#60;/expanded&#62;</p>
<p style="padding-left: 30px;">&#60;/Row&#62;</p>
<p style="padding-left: 30px;">&#60;/Rows&#62;</p>
]]></description>
        	        	<pubDate>Mon, 19 Nov 2012 01:18:27 +0200</pubDate>
        </item>
</channel>
</rss>