Cart
|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Forming a Tree
 I am trying to form a tree on a raw XML, my input XML looks like - <?xml version="1.0"?> <Root> <row BookId="1" BookTitle="abc1" TopicId="1" ParentTopicId="1" TopicTitle="Topic1"/> <row BookId="1" BookTitle="abc1" TopicId="2" ParentTopicId="1" TopicTitle="Topic11"/> <row BookId="1" BookTitle="abc1" TopicId="4" ParentTopicId="4" TopicTitle="Topic12"/> <row BookId="1" BookTitle="abc1" TopicId="3" ParentTopicId="2" TopicTitle="Topic21"/> <row BookId="1" TopicId="1" SiteId="1" SortOrder="0" SiteTitle="Site1" /> <row BookId="1" TopicId="2" SiteId="2" SortOrder="0" SiteTitle="Site2" /> <row BookId="1" TopicId="3" SiteId="3" SortOrder="0" SiteTitle="Site3" /> <row BookId="1" TopicId="4" SiteId="4" SortOrder="1" SiteTitle="Site4" /> <row BookId="1" TopicId="4" SiteId="1" SortOrder="0" SiteTitle="Site1" /> </Root> and my XSL is - <?xml version='1.0'?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="Root"> <TreeNodes> <xsl:apply-templates select="row[@BookTitle and not(preceding::row/@BookId=@BookId)]" /> </TreeNodes> </xsl:template> <xsl:template match="row"> <TreeNode> <xsl:variable name="node1" select="."/> <xsl:attribute name="BookId"><xsl:value-of select="@BookId"/></xsl:attribute> <xsl:attribute name="Text"><xsl:value-of select="@BookTitle"/></xsl:attribute> <!-- Topic node --> <xsl:for-each select="//row[@ParentTopicId=@TopicId and @BookId=$node1/@BookId and @TopicTitle]"> <TreeNode> <xsl:variable name="node2" select="."/> <xsl:attribute name="TopicId"><xsl:value-of select="@TopicId"/></xsl:attribute> <xsl:attribute name="ParentTopicId"><xsl:value-of select="@ParentTopicId"/></xsl:attribute> <xsl:attribute name="Text"><xsl:value-of select="@TopicTitle"/></xsl:attribute> <!-- Sub-Topic1 --> <xsl:for-each select="//row[@ParentTopicId=$node2/@TopicId and @ParentTopicId!=@TopicId and @BookId=$node1/@BookId and @TopicTitle]"> <TreeNode> <xsl:variable name="node3" select="."/> <xsl:attribute name="TopicId"><xsl:value-of select="@TopicId"/></xsl:attribute> <xsl:attribute name="ParentTopicId"><xsl:value-of select="@ParentTopicId"/></xsl:attribute> <xsl:attribute name="Text"><xsl:value-of select="@TopicTitle"/></xsl:attribute> <!-- Sub-Topic2 --> <xsl:for-each select="//row[@ParentTopicId=$node3/@TopicId and @ParentTopicId!=@TopicId and @BookId=$node1/@BookId and @TopicTitle]"> <TreeNode> <xsl:variable name="node4" select="."/> <xsl:attribute name="TopicId"><xsl:value-of select="@TopicId"/></xsl:attribute> <xsl:attribute name="ParentTopicId"><xsl:value-of select="@ParentTopicId"/></xsl:attribute> <xsl:attribute name="Text"><xsl:value-of select="@TopicTitle"/></xsl:attribute> <!-- Site --> <xsl:for-each select="//row[@BookId=$node4/@BookId and @TopicId=$node4/@TopicId and @SiteId]"> <xsl:sort select="@SortOrder" data-type="number"/> <TreeNode> <xsl:call-template name="SiteDetails"> <xsl:with-param name="site" select="."/> </xsl:call-template> </TreeNode> </xsl:for-each> </TreeNode> </xsl:for-each> <!-- Site --> <xsl:for-each select="//row[@BookId=$node3/@BookId and @TopicId=$node3/@TopicId and @SiteId]"> <xsl:sort select="@SortOrder" data-type="number"/> <TreeNode> <xsl:call-template name="SiteDetails"> <xsl:with-param name="site" select="."/> </xsl:call-template> </TreeNode> </xsl:for-each> </TreeNode> </xsl:for-each> <!-- Site --> <xsl:for-each select="//row[@BookId=$node2/@BookId and @TopicId=$node2/@TopicId and @SiteId]"> <xsl:sort select="@SortOrder" data-type="number"/> <TreeNode> <xsl:call-template name="SiteDetails"> <xsl:with-param name="site" select="."/> </xsl:call-template> </TreeNode> </xsl:for-each> </TreeNode> </xsl:for-each> </TreeNode> </xsl:template> <xsl:template name="SiteDetails"> <xsl:param name="site"/> <xsl:attribute name="TopicId"><xsl:value-of select="$site/@TopicId"/></xsl:attribute> <xsl:attribute name="SiteId"><xsl:value-of select="$site/@SiteId"/></xsl:attribute> <xsl:attribute name="Text"><xsl:value-of select="$site/@SiteTitle"/></xsl:attribute> </xsl:template> </xsl:stylesheet> I am applying transformation using .NET classes. Can the above XSL optimized to gain performance ? Can I avoid '//row' to achieve the same? Thanks in advance. Venkatesh _________________________________________________________ There is always a better job for you at Monsterindia.com. Go now http://monsterindia.rediff.com/jobs XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list 
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! 
Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|
