RE: Generate Hierarchical Tree from non-hierarchical XML
Try: <xsl:template match="employees"> <table><xsl:apply-templates select="employee[manager = ''] "/></table> </xsl:template> <xsl:template match="employee"> <tr><td width="150"></td><td> <xsl:value-of select="name" /> <xsl:if test="../employee[manager != current()/id]"> <table> <xsl:apply-templates select="../employee[manager = current()/id] "> <xsl:sort select="id"/> </xsl:apply-templates> </table> </xsl:if> </td></tr> </xsl:template> Key points: 1) I've wrapped it in nested tables to make it easier for me to spot where the element is being called. 2) The key to this working is the apply-templates in the employee template. Since we are selecting all of the employees which match the manager value to the current id value, we are only nesting the ones we want. Finally, we are sorting by id; this is as you wanted in your output. The use of apply-templates also allows for an infinite depth of recursion. Hope this helps, Ben 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