Answered by Juvian: http://stackoverflow.com/users/3308055/juvian
Regarding to the problem of getting children and subchildren of selected, you need to deal with recursion: Here is an example: http://jsfiddle.net/36gg3ro1/1/ google.visualization.events.addListener(chart, 'select', function(){ var children=[] var selected=chart.getSelection()[0].row; function getChilds(index){ // recursive function, adds children of index (row) var childs=chart.getChildrenIndexes(index); // get children indexes of current index for(var i = 0; i < childs.length;i++){ // for each children children.push(data.getValue(childs[i],0)) // add the title getChilds(childs[i]) // and call the function with this children index, to get their children and so on >> this is recursive } } getChilds(selected) // start recursive function with selected index console.log(children) }) On Tuesday, 2 December 2014 13:05:33 UTC+2, Mohamed El Ghandour wrote: > > Hi, > I have an organizational chart with many levels, the image below is taken > from a part of it. > I try to get all the childs and sub childs of a selected node, like if > "Power Business Unit" node selected it get all the 3 childs and for every > single child do the same. I got the first level but I can't get the depth > of the tree to provide the number of loops to reach the last child. > > 1- How can I get the last child in the chart? how to get the depth of the > tree? > 2- Is there a zoom in/zoom out toolbar or something, that I can add to the > chart? > > that is my code of drawing: > > google.load('visualization', '1', { packages: ['table', > 'orgchart'] }); > google.setOnLoadCallback(drawChart); > function drawChart() { > > var data = new google.visualization.DataTable(); > data.addColumn('string', 'NODE'); > data.addColumn('string', 'PARENT'); > data.addColumn('string', 'NODEID'); > > > data.addRows(JSON.parse(document.getElementById("<%=HiddenField1.ClientID%>").value)); > // > var chart = new > google.visualization.OrgChart(document.getElementById('chart_div')); > > function selectHandler() { > var selectedItem = chart.getSelection()[0]; > if (selectedItem) { > var oInd = data.getValue(selectedItem.row, 2); > > var arrLoop = > chart.getChildrenIndexes(selectedItem.row); > var arrConcat = > chart.getChildrenIndexes(selectedItem.row); > > > for (var i = 0; i < arrLoop.length; i++) { > var arr2 = new > Array(chart.getChildrenIndexes(arrLoop[i]).length); > arr2 = chart.getChildrenIndexes(arrLoop[i]); > for (var j = 0; j < arr2.length; j++) { > arrConcat.push(arr2[j]); > } > arrConcat.concat(arr2); > } > > var arrChilds = new Array(arrConcat.length); > > for (var i = 0; i < arrConcat.length; i++) { > arrChilds[i] = data.getValue(arrConcat[i], 2); > } > drawTable(oInd, arrChilds); > } > } > > google.visualization.events.addListener(chart, 'select', > selectHandler); > > chart.draw(data, { allowHtml: true }); > > //for (var i = 0; i < data.getNumberOfRows() ; i++) { > // chart.collapse(i, true); > //} > } > > > > > > <https://lh4.googleusercontent.com/-VFmgSBVUuNE/VH2ZgKPiKTI/AAAAAAAAAHI/lk0m4QlzCkw/s1600/OrgChart.JPG> > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.