My First TreeGrid – 3 level deep XML

[bobby.wallaceParticipant]

I was hoping to get a little hand holding…

I am implementing my first TreeGrid, and I need a little help on the source and hierarchy. First, the XML data:

————————————————————————-
<?xml version=”1.0″?>
<Applications>
<Application ApplicationID=”1″>
<ApplicationName>daily_darsys</ApplicationName>
<Environments>
<Environment EnvironmentID=”1″>
<EnvironmentName>Development</EnvironmentName>
<Severities>
<Severity Severity=”1″>
<SeverityLabel>High</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
<Severity Severity=”2″>
<SeverityLabel>Medium</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
<Severity Severity=”3″>
<SeverityLabel>Low</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
</Severities>
</Environment>
<Environment EnvironmentID=”2″>
<EnvironmentName>QA</EnvironmentName>
<Severities>
<Severity Severity=”1″>
<SeverityLabel>High</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
<Severity Severity=”2″>
<SeverityLabel>Medium</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
<Severity Severity=”3″>
<SeverityLabel>Low</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
</Severities>
</Environment>
<Environment EnvironmentID=”3″>
<EnvironmentName>Training</EnvironmentName>
<Severities>
<Severity Severity=”1″>
<SeverityLabel>High</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
<Severity Severity=”2″>
<SeverityLabel>Medium</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
<Severity Severity=”3″>
<SeverityLabel>Low</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
</Severities>
</Environment>
<Environment EnvironmentID=”4″>
<EnvironmentName>Production</EnvironmentName>
<Severities>
<Severity Severity=”1″>
<SeverityLabel>High</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
<Severity Severity=”2″>
<SeverityLabel>Medium</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
<Severity Severity=”3″>
<SeverityLabel>Low</SeverityLabel>
<RecipientFlag>0</RecipientFlag>
</Severity>
</Severities>
</Environment>
</Environments>
</Application>
</Applications>

——————————————————————————–
What I would like is to create a TreeGrid with three levels of hierarchy. Something like:

<ApplicationName>
<EnvironmentName>
<Severity>

Thanks in advance,
-Bobby

[bobby.wallaceParticipant]

My apologies… that was originally formatted with indents.

[Peter StoevKeymaster]

Hi bobby.wallace,

It would not be possible to display that XML in jqxTreeGrid through the supported data binding. You will have to implement some manual way to parse your XML and load it into Array which you will be then able to use in jqxTreeGrid.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[bobby.wallaceParticipant]

Could someone provide me with a Array that represents the XML example. If I were to guess, I would go with a three dimensional array, but I am still unsure of how the tree grid will use that as a source.

I could flatten the XML structure, but I am still unsure as to how to define the hierarchy.

<?xml version=”1.0″?>
<Applications>
  <Application>
    <ApplicationID>1</ApplicationID>
    <ApplicationName>daily_darsys</ApplicationName>
    <EnvironmentID>1</EnvironmentID>
    <EnvironmentName>Development</EnvironmentName>
    <Severity>1</Severity>
    <SeverityLabel>High</SeverityLabel>
    <RecipientFlag>0</RecipientFlag>
  </Application>
  <Application>
    <ApplicationID>10</ApplicationID>
    <ApplicationName>daily_darsys</ApplicationName>
    <EnvironmentID>1</EnvironmentID>
    <EnvironmentName>Development</EnvironmentName>
    <Severity>2</Severity>
    <SeverityLabel>Medium</SeverityLabel>
    <RecipientFlag>0</RecipientFlag>
  </Application>
  <Application>
    <ApplicationID>10</ApplicationID>
    <ApplicationName>daily_darsys</ApplicationName>
    <EnvironmentID>1</EnvironmentID>
    <EnvironmentName>Development</EnvironmentName>
    <Severity>3</Severity>
    <SeverityLabel>Low</SeverityLabel>
    <RecipientFlag>0</RecipientFlag>
  </Application>
</Applications>

Also, if someone could provide a 3-level tree example, that would be most helpful.

[jqwidgetsdevParticipant]

Hello bobby.wallace

Take a look at the following example:
http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxtreegrid/index.htm#demos/jqxtreegrid/javascript-tree-grid-binding-to-xml.htm

It is important to notice the following properties for the jqxTreeGrid’s SOURCE object.

hierarchy: {
keyDataField: { name: ‘EmployeeID’ },
parentDataField: { name: ‘ReportsTo’ }
},
id: ‘EmployeeID’,
root: ‘Employees’,
record: ‘Employee’,

If you are wondering about how to read the example’s XML.
Here is the WWW path: http://www.jqwidgets.com/jquery-widgets-demo/demos/sampledata/employees.xml.
Here is where it would be located on your local system \jQWidgets\demos\sampledata

I hope this helps.

Best regards.

[Author]

Posts