jQuery Grid Plugin - jqGrid - Forum: TreeGrid

darkwarrior on First TreeGrid - no rows

Fri, 24 May 2013 05:47:52 +0000

After following the sample at http://goo.gl/Im5Fl l and converting it from PHP to JSP, I'm at a roadblock: the data isn't displayed in the grid.

The code is below, and the data loaded is below that.

Thanks for any assist,

DW.

$('#tree').jqGrid({
url:'ProjectTemplates_Data.jsp',
datatype:'xml',
treeGridModel:'adjacency',
mtype:'POST',
colNames:['id','Task Name'],
colModel:[
{name:'intTaskID',index:'intTaskID', width:1,hidden:true,key:true,editable:true},
{name:'txtTaskName',index:'txtTaskName', width:180, editable:true}
],
height:'auto',
treeGrid:true
});

<?xml version='1.0' encoding='utf-8'?>

<rows><page>1</page><total>1</total><records>1</records>

<row><cell>1</cell><cell>Show systemmm77</cell><cell>0</cell><cell><![CDATA[NULL]]></cell><cell>false</cell><cell>false</cell></row>

<row><cell>2</cell><cell>asd</cell><cell>1</cell><cell><![CDATA[1]]></cell><cell>false</cell><cell>false</cell></row>

</rows>

pdaniel on Multiple group totals at header row?

Wed, 22 May 2013 19:51:10 +0000

I know it;s possible in the version 4 of jqGrid to place group subtotals at the header row level, but can we do this for multiple columns? We have multiple columns we need totaled up at the group level and in looking at the sample code, it appears this is not possible. In the example below, the group by would be the account level. Thanks in advance.

Description Value Cost

Acct a 75 100

Pos 1 25 60

Pos 2 50 40

OlegK on treegrid with local data and issue with jsonmap

Fri, 10 May 2013 16:25:06 +0000

One can find the answer of the problem in my answer on the stackoverflow. The main advice one have to use datatype: "jsonstring" instead of datatype: "local" to have support of jsonmap property in colModel.

RRK on treegrid with local data and issue with jsonmap

Thu, 09 May 2013 19:33:20 +0000

I am loading a treegrid using local data. For some reason, jqGrid is displaying cell values

based on "name" property and not "jsonmap" property of the colModel.

Here is a simplified version of the grid and the local data. With the below configuration,

I get empty values in the "Qty" column. However, if in "mydata" I change "qty1″ to "qty"

I get values in the "Qty" column.

var mydata =  {"rows":[
    {id: 1221,name: "P1",qty1: "1", level: 0,parent: "NULL",isLeaf: false, 
loaded: true, expanded: true},
    {id: 1222,name: "P1-Child",qty1: "2", level: 1,parent: 1221,isLeaf: true, 
loaded: true, expanded: true}
]};

jQuery("#bomTable").jqGrid({
       treeGrid:true,
       treeGridModel:'adjacency',
       ExpandColumn:'name',
       treedatatype: "local",
       datatype: "local",
       data: mydata,
       jsonReader: {
           repeatitems: false
       },
       colNames:['ID', 'Name', 'Qty'],
       colModel:[
           {name:'id', hidden: true},
           {name:'name', index:'name'},
           {name: 'qty', jsonmap: 'qty1', index: 'qty'}
       ],
       width:'auto',
       height:'auto',
       shrinkToFit:false
   });

   jQuery("#bomTable")[0].addJSONData({
       total: 1,
       page: 1,
       records: mydata.rows.length,
       rows: mydata.rows
   }) ;

Would greatly appreciate any inputs!

tony on bug when hide first col treeGrid

Thu, 09 May 2013 13:23:12 +0000

Hello,

In you case you will need to set ExpandColumn

datatype : "local",

treeGrid : true,

treeGridModel: 'adjacency',

ExpandColumn : 'title_col2',

colNames = [ "col1", "col2"],

colModel = [ {name:'title_Col1', hidden:true}, {name:'title_col2'}]

Regards

nikopol on bug when hide first col treeGrid

Wed, 08 May 2013 15:10:10 +0000

Hi all,

I think I have discovered a little bug in JqGrid 4.4.5.

I used :

datatype : "local",

treeGrid : true,

treeGridModel: 'adjacency'

colNames = [ "col1", "col2"],

colModel = [ {name:'title_Col1', hidden:true}, {name:'title_col2'}]

I have added all rows with 'addChildNode'.

The jqGrid data was displayed as standard rows instead of treeGrid, however, if I ask a row with 'getNodeChildren' method, all children was returned correctly. This is just a display bug. This bug is not present when the first element of colModel is not hidden, like that:

colNames = [ "col2", "col1"],

colModel = [ {name:'title_col2'}, {name:'title_Col1', hidden:true}]

I have not tested other thing than datatype:local and addChildNode method

bergzilla on newbie treegrid questions...

Tue, 02 Apr 2013 00:28:07 +0000

Ugh, my name is berg and I am lord of the idiots...

Adjacency only has one n...

After correcting that, it all works great! Thanks anyone and everyone who took a look!

bergzilla on newbie treegrid questions...

Mon, 01 Apr 2013 22:56:09 +0000

Say I have a simple hierarchy of XML like…

<root>

</item>

</item>

</root>

And my treegrid is setup something like this…

var colNames = ['Label'];
var colModel = [ {name:'label', xmlmap: function (obj) { return $(obj).attr("label");}} ];

$("#myTreeGrid").jqGrid({

treeGrid: true,
treeGridModel: 'adjancency',
ExpandColClick: true,
ExpandColumn: 'Label',
datatype: 'xmlstring',
datastr: myXML,
colNames: colNames,
colModel: colModel,
xmlReader: {
root: "root",
row: "item",
repeatitems: false
},
treeReader: {
level_field: "[level]",
parent_id_field: "[parent]",
leaf_field: "[leaf]",
expanded_field: "[expanded]"
},
gridview: false,
caption: 'My Tree Sample',

});

Now this XML is a bit different than the single example that google is giving me. I was hoping this would work due to the little xmlmap trick being able to pull out attributes via the function call ie xmlmap: function (obj) { return $(obj).attr("label");} that I'm using in the colModel and being able to use attributes in the treeReader and that all seems to work well but the one thing that I can't get to work for the life of me is being able to expand/collapse the parent.

I'm getting what looks like parent and children in the tree(they've got the right icons) but they don't seem to be connected. Children are starting off fully expanded even though their expand field is set to false and clicking on the parent's expand/collapse triangle just seems to stick to expand regardless of what the field was set to.

I'm guessing I'm missing a field in my treeReader for id to connect parent and children but all I can find in the documentation available is level_field, parent_id_field, leaf_field, and expanded_field for the adjancency model. I've also tried setting the id field in the xmlReader but haven't had any luck.

Could it also be that I'm missing a field for setting the loaded boolean? I know in the standard XML treegrid example, it's recommended that the last tag for each row be set to true(I think) to keep treegrid from contacting the server for the children's contents. Could it be that my parent expand is stuck because its trying to pull more data from the server even though I don't want it to?

Does anyone have any suggestions? I feel like I'm so close to getting this to work and I'm getting tripped up on something I'm just not finding.

Also, the links that I'm guessing explain what the nested and adjancency models really mean seem to be broken. Does anyone have a simple explanation for the difference between the two? Judging from the differences in their treeReaders, they seem a bit backwards to me. Wouldn't adjacent mean things are side by side which would use the left/right fields?

And kind of a side comment that I hope doesn't come off as snarky It's kind of a bummer to me that I've got a very hierarchical XML but I still have to go thru and explicitly setup parent/child relationships via either tags or attributes.

Thanks for any advice you can drop on me!

sbel on jqGrid dropdown filtering doesn't work as expected

Mon, 25 Mar 2013 16:56:52 +0000

I need to have a dropdown filter on a column. The dropdown consists of 4 options: "All", "Opt1", "Opt2", and "Opt3". When one of the non-"All" options is selected than the grid should reload based on the options. However, when "All" is selected than the grid should reload without a filter being applied. Here is my unsuccessful attempt:

searchoptions {

value : {"":"All", "1" : "Opt1", "2" : "Opt2", "3" : "Opt3" }

}

The problem is that when I select "All", the last selected filter is applied for some reason. Please advise.

25e8

AB on Tree Grid - Bind to List - Sorting not working

Mon, 18 Mar 2013 11:27:46 +0000

Hello,

i have created a treegrid. If i bind data from Linq to SQL - sorting works fine. But if i bind same data with List then sorting did not work.

You can download my demo app From Here

Please help me out.

knissanka on Jqgrid: focus goes to the scroll bar when select it in IE

Thu, 14 Mar 2013 13:33:02 +0000

I m using IE9

tony on Jqgrid: focus goes to the scroll bar when select it in IE

Thu, 14 Mar 2013 08:27:56 +0000

Hello,

It seems to be a problem in IE.

Here some links.

In which version of IE is this. Does it happen in IE 10?

Regards

knissanka on Jqgrid: focus goes to the scroll bar when select it in IE

Thu, 14 Mar 2013 08:11:17 +0000

I m using a jqgrid and has done inline editing as well. But my issue is if I select a editable field in the jqgrid and if I selects the scroll bar then the focus goes to scroll bar from the editable field. Can I overcome this? I want to retain the focus to the selected editable field rather than the focus goes o the scroll bar. This is only happening in IE. Chrome and Firefox working correctly.

ThaDafinser on Pagination for treegrid

Tue, 12 Mar 2013 17:11:13 +0000

I'm just facing another problem, which maybe comes out of my implementation?

When i load a tree node which is closed and loaded: false, the ajax request don't get executed.

I found out it's because of the first time i use datatype: 'local'

And then manually change it to json...

grid.jqGrid('setGridParam', { dataType: 'json' });

grid.jqGrid()[0].addJSONData(data); //Apply the faked "local" data...

It's fine with pagination (second page get's loaded with ajax), but it doesn't work with the tree ajax loading..?

ThaDafinser on Pagination for treegrid

Tue, 12 Mar 2013 15:37:48 +0000

Hello togehter,

as mentioned in the wiki, pagination is currently not possible:

http://www.trirand.com/jqgridw.....imitations

Because I need this feature for one list, i though about what's needed for this, and i don't think it's much.

When only the "level: 0" rows get counted, the paginator would just be perfect. What do you think about that?

Best regards

AB on Tree Grid - Export to CSV + Filtering

Tue, 12 Mar 2013 09:48:09 +0000

tony said:
Hello,

If you use the commetrtial version of jqGrid, please post your problem here

If this is not the case then you will need to check your code for filtering and export.

Kind Regards

I am using free MIT license license version.

tony on Tree Grid - Export to CSV + Filtering

Tue, 12 Mar 2013 08:27:27 +0000

Hello,

If you use the commetrtial version of jqGrid, please post your problem here

If this is not the case then you will need to check your code for filtering and export.

Kind Regards

AB on Tree Grid - Export to CSV + Filtering

Mon, 11 Mar 2013 16:51:55 +0000

Hello,

I am just beginner with JQGrid. I have created a treegrid with it.

I have tried to implement "Export to CSV" but its throwing below error.

--------------------------

   at System.Web.UI.ControlCollection.get_Item(Int32 index)
   at System.Web.UI.WebControls.TableCellCollection.get_Item(Int32 index)
   at Trirand.Web.Mvc.JQGrid.RenderCSVToStream(DataGrid grid, String fileName)
   at Trirand.Web.Mvc.JQGrid.ExportToCSV(Object dataSource, String fileName)
   at JQGridDemo.Controllers.IncomeDtlController.ExportToCSV() in d:R&DJQGridJQGridControllersIncomeDtlController.cs:line 216
   at lambda_method(Closure , ControllerBase , Object[] )
   at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
   at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41()
   at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass37.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49()

-------------------------------------------

As well when i do filtering it only gives one single node with expand option, when i expand it - after that i am not able to do any operation.

-----------------------------

It will be really helpful, if anybody can give me example of treegrid with Export to CSV and filtering feature.

80e

tony on Tree Grid - On Click of root node expand all level nodes under it

Tue, 05 Mar 2013 12:05:29 +0000

Hello,

Thanks for the explanation and the test case. I will look into this problem.

Regards

kishork on Tree Grid - On Click of root node expand all level nodes under it

Mon, 04 Mar 2013 22:49:26 +0000

I'm new to jqGrid.

Our use case needs us to *expand all nodes under root node on click*

I tried setting the expanded property to true for all non-leaf nodes & non root nodes, however doing so makes the level 1 node disappear also the other nodes expand.

Here is the jsFiddle: http://jsfiddle.net/SQzAC/1/ (If you click the root node you will notice that level 1 was hidden)

I guess I am using the API in a wrong way and instead of setting the expanded property at load time I should set the expanded property for all non-leaf and non-root nodes in loadComplete event.

What is the right way to achive the desired result? TIA