XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Manu GuptaSubject: XML-XSL grouping issue while displaying
Author: Manu Gupta
Date: 15 Jul 2011 05:57 AM
Originally Posted: 15 Jul 2011 05:55 AM
Hi All,
I am newbie to XML-XSL based programming. Currently I am facing issue with displaying XML node in sorted order along with grouping on nodes.

In the attached XML there is node for "Products" and under this node there are certain nodes which is unordered. I need to order these child nodes of "Products" and display the First letter for each group. The group here I mean is if 2 child nodes have "A" as starting letter then XSL should display its "label" node value and Group "B" for starting letter "B". For e.g. -
Product Category
A
Analyzer
Applied Discovery

B
Background Screening
Backup Disaster Recovery

D
Direct

and so on...

Can you all techies help achieving this for me. It would be great help


Sample XML
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="sietmap-sorting.xsl"?>
<site-map id="gp0hweiw" Version="3.1.1.0">
<segment id="0" priority="-1" enabled="true" default="true" rule-name="Primary">
<node id="gp0hweiz" allow-children="true" visible-in-breadcrumbs="true" visible-in-sitemap="true">
<label key="">home</label>
<description/>
<link type="page" target="">
<value>home</value>
<query-string preserve-qs-data="false"/>
</link>
<aliases/>
</node>
<node id="gpqb7v4e" allow-children="true" visible-in-breadcrumbs="true" visible-in-sitemap="true">
<label key="">Products</label>
<description/>
<link type="page" target="">
<value>product-index</value>
<query-string preserve-qs-data="false"/>
</link>
<aliases/>
<node id="gpzlwli6" allow-children="true" visible-in-breadcrumbs="true" visible-in-sitemap="true">
<label key="">Analyzer</label>
<description>Product - Analyzer</description>
<link type="page" target="">
<value>products/analyzer</value>
<query-string preserve-qs-data="false"/>
</link>
<aliases/>
</node>
<node id="gpzlwli7" allow-children="true" visible-in-breadcrumbs="true" visible-in-sitemap="true">
<label key="">Backup Disaster Recovery</label>
<description>Backup Disaster Recovery</description>
<link type="page" target="">
<value>products/backup-disaster-recovery</value>
<query-string preserve-qs-data="false"/>
</link>
<aliases/>
</node>
<node id="gpzlwli9" allow-children="true" visible-in-breadcrumbs="true" visible-in-sitemap="true">
<label key="">Applied Discovery</label>
<description>Applied Discovery</description>
<link type="page" target="">
<value>products/applied-discovery</value>
<query-string preserve-qs-data="false"/>
</link>
<aliases/>
</node>
<node id="gpzlwlvp" allow-children="true" visible-in-breadcrumbs="true" visible-in-sitemap="true">
<label key="">Background Screening</label>
<description/>
<link type="url" target="_blank">
<value>http://www.xyz.com/checks-screening.aspx</value>
<query-string preserve-qs-data="false"/>
</link>
<aliases/>
</node>
<node id="gpzlwlw0" allow-children="true" visible-in-breadcrumbs="true" visible-in-sitemap="true">
<label key="">Direct</label>
<description></description>
<link type="page" target="">
<value>products/direct</value>
<query-string preserve-qs-data="false"/>
</link>
<aliases/>
</node>
</node>
</segment>
</site-map>





Unknownsample-map.xml
Product XML

Posttop
Ivan PedruzziSubject: XML-XSL grouping issue while displaying
Author: Ivan Pedruzzi
Date: 20 Jul 2011 11:47 PM


Fun grouping execise, see if the following helps

Ivan

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="g" match="site-map/segment/node[label = 'Products']/node" use="substring(label, 1,1)"/>
<xsl:template match="/">
<xsl:variable name="Products" select="site-map/segment/node[label = 'Products']"/>
<xsl:for-each select="$Products/node">
<xsl:sort select="label"/>
<xsl:variable name="key" select="substring(label, 1,1)"/>
<xsl:variable name="group" select="key('g', $key)"/>
<xsl:if test="generate-id($group[1]) = generate-id(.)">
<xsl:value-of select="concat($key,'&#10;')"/>
<xsl:for-each select="$group">
<xsl:value-of select="concat(label,'&#10;')"/>
</xsl:for-each>
</xsl:if>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
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.