SSDN - Counting children and grandchildren

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Liam B

Subject: Counting children and grandchildren
Author: Liam B
Date: 12 Feb 2009 10:46 AM

Hello all

I need to test if a node has more than one child element AND no grandchildren.

This is what i'm using at the moment but it's not having any effect.

"count(Data_For_Visio[last()-1]>1) and count(descendant::Data_For_Visio[last()]=0)"

Any ideas where i'm going wrong?

John Bampton

Subject: Counting children and grandchildren
Author: John Bampton
Date: 13 Feb 2009 12:47 AM

I used this xml

<?xml version="1.0" encoding="UTF-8"?>

<Data_For_Visio>
<g></g>
<h></h>
</Data_For_Visio>

And this XSL

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
<xsl:template match="/">

<xsl:if test="count(child::Data_For_Visio/node() ) > 1 and count(child::Data_For_Visio/child::*/node()) = 0 ">
<xsl:text>Data_For_Visio has more than one child and no grandchildren</xsl:text>
</xsl:if>

</xsl:template>
</xsl:stylesheet>

Make sure there is no whitespace in the xml elements and it works

John Bampton

Subject: Counting children and grandchildren
Author: John Bampton
Date: 13 Feb 2009 03:13 AM

It would be better if you posted your xml so that we could understand the problem a bit better. Cheers John Bampton.

Liam B

Subject: Counting children and grandchildren
Author: Liam B
Date: 13 Feb 2009 06:09 AM

Hi John,

Thanks for your responses.

The data is for an orgchart, and when a person has two or more subordinates, but those subordinates have no subordinates then apply a different transorm to those subordinates. For example in the following XML i wish to apply a different transform to Jon Snow, Moira Stewart, Jimmie Krankie and Alex Zane only.

This is My XML:

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="..\styles\orgchartstest.xsl" ?>
<dataroot>
<Data_For_Visio Employee_ID="123" Person_Name="Terry Wogan" Reports-To="1" Position_Title="Finance - Corporate Services Manager" Substantive="">
<Data_For_Visio Employee_ID="615" Person_Name="Cliff Richard" Reports-To="123" Position_Title="Management Accountant" Substantive="">
<Data_For_Visio Employee_ID="654" Person_Name="Sue Barker" Reports-To="615" Position_Title="Accounting Assistant" Substantive=""/>
</Data_For_Visio>
<Data_For_Visio Employee_ID="616" Person_Name="Dermot O'Leary" Reports-To="123" Substantive="">
<Data_For_Visio Employee_ID="683" Person_Name="Cat Deeley" Reports-To="616" Position_Title="Accounting Assistant" Substantive=""/>
</Data_For_Visio>
<Data_For_Visio Employee_ID="632" Person_Name="David Dimbleby" Reports-To="123" Position_Title="Finance Manager" Substantive="">
<Data_For_Visio Employee_ID="656" Person_Name="Jon Snow" Reports-To="632" Position_Title="Procurement and Contracts Assistant" Substantive=""/>
<Data_For_Visio Employee_ID="657" Person_Name="Moira Stewart" Reports-To="632" Position_Title="Payroll Admin" Substantive="" />
<Data_For_Visio Employee_ID="983" Person_Name="Jimmie Krankie" Reports-To="632" Position_Title="Payroll Input Assistant" Substantive=""/>
<Data_For_Visio Employee_ID="1210" Person_Name="Alex Zane" Reports-To="632" Position_Title="Procurement and Contracts Assistant" Substantive=""/>
</Data_For_Visio>
<Data_For_Visio Employee_ID="648" Person_Name="Raghesh Omar" Reports-To="123" Position_Title="Team Co-Ordinator" Substantive=""/>
</Data_For_Visio>
</dataroot>

And this is the XML i'm using to transform it(Including the updated test supplied by yourself):

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

<xsl:output method="html" />

<xsl:template match="/">
<html>
<head>

<script type="text/javascript" language="JavaScript" src="..\scripts\jquery.js"><xsl:comment></xsl:comment></script>
<link type="text/css" rel="stylesheet" href="../styles/orgcharts.css"><xsl:comment></xsl:comment></link>
</head>
<body>
<table cellspacing="0" cellpadding="0" class="roottable">
<tr>
<xsl:apply-templates select="dataroot" />
</tr>
</table>
</body>
</html>
</xsl:template>

<xsl:choose>
<xsl:when test="count(child::Data_For_Visio/node() ) > 1 and count(child::Data_For_Visio/child::*/node()) = 0 ">

<xsl:template match="Data_For_Visio">
<td valign="top" class="open">

<div>

<div class="last">
<div class="wrapperbox">
<div class="boxc">

<div class="box">
<b><xsl:value-of select="@Person_Name" /></b>
<p><xsl:if test="count(.//Data_For_Visio)">
<xsl:text> (</xsl:text>
<xsl:value-of select="number(count(.//Data_For_Visio))" />
<xsl:text>)</xsl:text>
</xsl:if>
<xsl:comment></xsl:comment>
</p>
<p><xsl:value-of select="@Position_Title"/></p>
<p><xsl:value-of select="@Organisation"/></p>
<xsl:choose>
<xsl:when test="@Substantive != @Person_Name">
<b><xsl:text>Substantive: </xsl:text><xsl:value-of select="@Substantive"/></b>

</xsl:when>
<xsl:when test="@Substantive !=Null">
<b><xsl:text>Substantive: </xsl:text><xsl:value-of select="@Substantive"/></b>
</xsl:when>
</xsl:choose>

</div>
</div>
</div>
</div>

<xsl:if test="*">
<div class="linemiddle"><div class="openclose" ></div></div>
</xsl:if>
<div class="tablewrapper">
<table cellspacing="0" cellpadding="0" align="center">
<tr>
<xsl:apply-templates select="*" />
<xsl:comment></xsl:comment>
</tr>
</table>
</div>
</div>
</td>
</xsl:template>
</xsl:when>
<xsl:otherwise>
<xsl:template match="Data_For_Visio">
<td valign="top" class="open">
<xsl:if test="parent::* and count(parent::*/*)>1">
<div>
<xsl:attribute name="class">
<xsl:choose>
<xsl:when test="not(preceding-sibling::*)">leftabove</xsl:when>
<xsl:otherwise>rightabove</xsl:otherwise>
</xsl:choose>
</xsl:attribute></div>
<div>
<xsl:attribute name="class">
<xsl:choose>
<xsl:when test="not(following-sibling::*) or not(preceding-sibling::*)">nolines</xsl:when>
<xsl:otherwise>above</xsl:otherwise>
</xsl:choose>
</xsl:attribute></div>
</xsl:if>
<div>

<div class="wrapperbox">
<div class="boxc">

<div class="box">
<b><xsl:value-of select="@Person_Name" /></b>
<p><xsl:if test="count(.//Data_For_Visio)">
<xsl:text> (</xsl:text>
<xsl:value-of select="number(count(.//Data_For_Visio))" />
<xsl:text>)</xsl:text>
</xsl:if>
<xsl:comment></xsl:comment>
</p>
<p><xsl:value-of select="@Position_Title"/></p>
<p><xsl:value-of select="@Organisation"/></p>
<xsl:choose>
<xsl:when test="@Substantive != @Person_Name">
<b><xsl:text>Substantive: </xsl:text><xsl:value-of select="@Substantive"/></b>

</xsl:when>
<xsl:when test="@Substantive !=Null">
<b><xsl:text>Substantive: </xsl:text><xsl:value-of select="@Substantive"/></b>
</xsl:when>
</xsl:choose>

</div>
</div>
</div>

<xsl:if test="*">
<div class="linemiddle"><div class="openclose" ></div></div>
</xsl:if>
<div class="tablewrapper">
<table cellspacing="0" cellpadding="0" align="center">
<tr>
<xsl:apply-templates select="*" />
<xsl:comment></xsl:comment>
</tr>
</table>
</div>
</div>
</td>
</xsl:template>
</xsl:otherwise>
</xsl:choose>

</xsl:stylesheet>

John Bampton

Subject: Counting children and grandchildren
Author: John Bampton
Date: 13 Feb 2009 09:59 AM

here is the condtion that you need

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
<xsl:template match="/">

<xsl:for-each select="//Data_For_Visio">
<xsl:choose>
<xsl:when test="count(child::*) > 1 and count(child::*/child::*) = 0 ">
more than one child and no grandchildren
</xsl:when>
<xsl:otherwise>
the condition fails
</xsl:otherwise>
</xsl:choose>
</xsl:for-each>

</xsl:template>
</xsl:stylesheet>

Cheers, John Bampton.

Liam B

Subject: Counting children and grandchildren
Author: Liam B
Date: 13 Feb 2009 12:47 PM

Thanks John,

It's abit late in the day in the UK so i'll have to check whetehr this works on monday. But thanks you very much for your help thus far.

John Bampton

Subject: Counting children and grandchildren
Author: John Bampton
Date: 19 Feb 2009 08:20 AM

i love it when 125 people check out my handy work.

Hey you didn't thank me!???

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.