XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Counting children and grandchildren
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> - XSLT slicing and orphan contro... (1)
-> + How to delete CDATA using XSL... (15)
-> + Remove only root namespace, bu... (3)
-> + String Parsing (3)
-> + Calling Java method from XSL (3)
-> + populate xsl file from xsd fil... (5)
-> + formating a number like #'###.... (3)
-> + Help with grouping children, f... (20)
-> + Need help for newbie! (3)
-> + xpath in string format (2)
-> + How to populate elements at ra... (4)
-> + Changing Date format in XLST (2)
-> + Please help....How could I rem... (2)
-> - Counting children and grandchi... (7)
-> ->Counting children and gra...
-> ->Counting children and gra...
-> ->Counting children and gra...
-> ->Counting children and gra...
-> ->Counting children and gra...
-> ->Counting children and gra...
-> + Nested tags (4)
-> + Problem with XSLT on a Soap En... (2)
-> + Problem with XSLT on a Soap En... (5)
-> + Comparison between XSLT proces... (2)
-> + Printing non-existing value (9)
-> + big input file for XSLT (14)
-> + Is there any way to store xpat... (2)
-> + Encoding special charecters (2)
-> + Sorting (3)
-> + XML to PDF using XSL:FO (3)
-> + How to find the line number in... (2)
-> + How to set a marker for paper ... (2)
-> + Not equality Function (2)
-> + Counting Elements (4)
-> + Looking for help or code samp... (2)
-> + Help needed in pattern matchin... (2)
-> + Repeaters and Ifs (2)
-> + select adjacent nodes in xpath... (3)
-> + Stripping of Empty Target Elem... (2)
-> + auto-generate Edifact Intercha... (5)
-> + Qname Error in xsl:element (2)
-> + [Newbie] Type conversion and f... (2)
-> + Do ...when (2)
-> + Using Key (3)
-> + sorting elements in option (2)
-> + NaN(not available) value repla... (3)
-> + infinite loop error when tryin... (9)
-> + Escape a character in the stri... (3)
-> + find sum of 2 elements in xml (2)
-> + placing a ' * ' by reading the... (3)
-> + Problem in dispaying Current D... (4)
-> + Merging Table Cells in XSLT re... (3)
-> + xsl fo block-container and foo... (2)
-> + Is is possible to create a .CO... (2)
-> + printing a parent node value i... (2)
-> + Mime header info setup? (3)
-> + Calculating a Date based on 4 ... (3)
-> + XSLT formatting number issue (10)
-> + map repeating elements separat... (3)
-> + Combining XML elements based o... (3)
-> + Convert XML to UTF-8 (8)
-> + XSLT and MS Access 2007 Optio... (5)
-> - WORDML list to XML list (1)
-> + [Newbie] Using lookups in XSLT... (3)
-> + Comparing 2 passed Date Values (2)
-> + ERROR XQueryMediator Error du... (2)
-> + XML / XSLT... Unordered lists ... (2)
-> + Specify image path in XSL (2)
-> + Variable within a variable (3)
-> + How to call jfreechart method ... (8)
-> + leading and trailing white spa... (2)
-> + XSLT to Html problems (6)
-> + How to set classpath, when i n... (3)
-> + Error in using functions (4)
-> + To find the occurence of a cha... (3)
-> + PLMXML to XML (4)
-> + Transform multiple node values... (2)
-> + I am in need of svg example(s)... (13)
-> + count in XSLT, Need Help Pleas... (2)
-> + Help with XML.Report and Gener... (2)
-> + for each loop and variable (5)
-> + Problem with selecting nodes f... (3)
-> + Getting "Expected elemenmt mis... (2)
-> + Help with attached XML mapping... (8)
-> + xml:space="Preserve" and Embed... (2)
-> + XSLT and Multiple Strings (2)
-> + XSL Date format (2)
-> + check element contents against... (3)
-> + XML to XML Namespace conversio... (2)
-> - Supressing subgroup headers in... (1)
-> - HTML to fo conversion using XS... (1)
-> + No Topic (2)
-> + parsing xml using xslt HELP (2)
-> + Multiple Page Headers (2)
-> + PLM Xml To Generic XML (3)
-> + XSLT/XPath Help (2)
-> + XSL Space Issue (2)
-> + wanting help with xslt custom ... (3)
-> - Update input xml content with ... (1)
-> + Error: namespace prefix xsl on... (3)
-> + Error in my xsl:if test... (2)
-> - calling javascript from XSLT (1)
-> + Error when trying to a call a ... (2)
-> - HTTP POST from XSLT (1)
-> + passing xml document as input ... (2)
-> + XSLT for WORDML table to CALS ... (2)
-- Previous [361-380] [381-400] [401-420] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Liam BSubject: 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?
Postnext
John BamptonSubject: 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() ) &gt; 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

Postnext
John BamptonSubject: 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.
Postnext
Liam BSubject: 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() ) &gt; 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::*/*)&gt;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>
Postnext
John BamptonSubject: 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::*) &gt; 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.

Postnext
Liam BSubject: 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.
Posttop
John BamptonSubject: 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!???
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.