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 » XSLT 1.0 Grouping Small change reqd! please help
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + First time to Stylus Studio 20... (3)
-> + xsl:if test statement result t... (4)
-> + XSLT for dynamic target fields (4)
-> + Remove duplicates (2)
-> + XML-XSL grouping issue while d... (2)
-> + Two XML files. Two Tables. One... (3)
-> + Saxon 9.3 with XSLV (2)
-> - How do I remove the text strin... (1)
-> + Xpath of each element (3)
-> + Attributes - required vs optio... (2)
-> + XML schema to XML schema with ... (2)
-> + how to preserve the & in X... (2)
-> + how to use variables within (2)
-> + need help in XSLT programming (3)
-> + XSLT Mapper Option... Where i... (3)
-> - Selecting element based on att... (1)
-> + replace question (2)
-> - select other node based on one... (1)
-> - XSLT question... (1)
-> - Mapper and XSL (1)
-> - Copying XML as is with one cha... (1)
-> - Help with XSLT (1)
-> - XSL repeat the parent node for... (1)
-> - xls to xml (1)
-> - Stylus support non-backreferen... (1)
-> - Assigning records to existing ... (1)
-> + xsl:for-each and key() (2)
-> + tags containing a: (2)
-> - Create a namespace in output f... (1)
-> - XML Converters problem on UNIX (1)
-> - Copy XML Based on IF Condition... (1)
-> - csv counting dependencies (1)
-> + For extension function, could ... (2)
-> - XML XSLT Transformation (1)
-> + Transform XSD to another XSD (3)
-> - New to Stylus (1)
-> + my enterprise install doesn't ... (2)
-> - Replace line in XML (1)
-> - 5010 HIPAA - Example EDI files... (1)
-> - Display table in two columns f... (1)
-> + java.lang.RuntimeException (4)
-> + Select Value-Of Qualified Elem... (2)
-> + Validating different sets of r... (2)
-> + Passing complete source docume... (2)
-> - XSLT to sort XML per schema (1)
-> - XSL to select the group of row... (1)
-> + first ancestor of a type (2)
-> - Column Width Adjustment (1)
-> + XSLT breakpoint being ignored ... (6)
-> - Creating a tab delimited file (1)
-> - Invalid characters in xml (1)
-> + Creating XSLT File Based on XS... (2)
-> - Unable to filter InputStream f... (1)
-> + finding a list of values (7)
-> - TEMP directory question (1)
-> - [HELP] Template and namespace (1)
-> - The prefix "xsl" for element "... (1)
-> - Need help comparing dates in x... (1)
-> - trying to sort a list of artic... (1)
-> + Count unique values using XSLT (3)
-> + Dot "." vs. self::node() (2)
-> + Output from report and XSL do ... (2)
-> + XSL report (2)
-> + cannot see valid values in the... (2)
-> - sum function help (1)
-> + XSLT transformation problem (2)
-> + Flat To nested XML using Keys (3)
-> - XSLT Editor autocomplete funct... (1)
-> - Receiving an argument from a l... (1)
-> + Can't using the Xalan-J in Sty... (2)
-> + Need help testing to see if th... (2)
-> + Any good way to handle repeati... (2)
-> - Renaming child element name wh... (1)
-> + What to do to only how last 4 ... (2)
-> + Help to access an element with... (3)
-> - Multiplication for-each (1)
-> - XSL / X-Path query (1)
-> - Help in creating XSD (1)
-> + JAVASCRIPT Inside XSL (2)
-> + is at possible to create edita... (2)
-> + Grouping on Multiple Field (2)
-> - XSLT 1.0 Grouping Small change... (2)
-> ->XSLT 1.0 Grouping Small c...
-> + Revision bar based on the page... (2)
-> + xslt to rtf (2)
-> + XEP/FOP Error (3)
-> + XML to XML Transformation (3)
-> + This XSLT has stumped me.. (2)
-> + converting XML to EACOM format (2)
-> + Stylus with XSLT 1.0 + EXSLT T... (2)
-> + Xslt Mapper (2)
-> - xml to xsl (1)
-> - creating a website (1)
-> - XML to PDF using XML Publisher... (1)
-> - Replace nodes (1)
-> - New to XSLT, need help with a ... (1)
-> - Modify XSLT - Have List of Cha... (1)
-> - Replace nodes in one xml file ... (1)
-> - Alternate Row Colour (1)
-> - convert text to XML and then m... (1)
-> - CDATA to XML - work with trans... (1)
-- Previous [61-80] [81-100] [101-120] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Arjun ShrivatsanSubject: XSLT 1.0 Grouping Small change reqd! please help
Author: Arjun Shrivatsan
Date: 09 May 2010 10:17 PM
I have the following xml

<DisplayDefinitionTable>
<ReportDesignName>sample</ReportDesignName>
<columns>
<column_entry order_num="0" relation_to_base="ItemRevision.item_id">Item ID</column_entry>
<column_entry order_num="1" relation_to_base="ItemRevision.IMAN_manifestation. data_file.platform">Platform</column_entry>
<column_entry order_num="2" relation_to_base="ItemRevision.IMAN_manifestation. data_file.equipment_names">Equipment Names</column_entry>
</columns>
<rows>
<row>
<object_tag tag="37967" uid="UsEAAAweIY0fUB"/>
<object_tag tag="37968" uid="E4OAAAwyIY0fUB"/>
<object_tag tag="35903" uid="jvPAAAwWIY0fUB"/>
<row_element column="0" component_tag="37967" property_name="item_id">000010</row_element>
<row_element column="1" component_tag="37968" property_name="platform">S4</row_element>
<row_element column="2" component_tag="37968" property_name="equipment_names">a</row_element>
</row>
<row>
<object_tag tag="37967" uid="UsEAAAweIY0fUB"/>
<object_tag tag="37968" uid="E4OAAAwyIY0fUB"/>
<object_tag tag="35903" uid="jvPAAAwWIY0fUB"/>
<row_element column="0" component_tag="37967" property_name="item_id">000010</row_element>
<row_element column="1" component_tag="37968" property_name="platform">S4</row_element>
<row_element column="2" component_tag="37968" property_name="equipment_names">b</row_element>
</row>
<row>
<object_tag tag="37967" uid="UsEAAAweIY0fUB"/>
<object_tag tag="37968" uid="E4OAAAwyIY0fUB"/>
<object_tag tag="35903" uid="jvPAAAwWIY0fUB"/>
<row_element column="0" component_tag="37967" property_name="item_id">000010</row_element>
<row_element column="1" component_tag="37968" property_name="platform">S4</row_element>
<row_element column="2" component_tag="37968" property_name="equipment_names">c</row_element>
</row>
<row>
<object_tag tag="37967" uid="UsEAAAweIY0fUB"/>
<object_tag tag="37968" uid="E4OAAAwyIY0fUB"/>
<object_tag tag="35903" uid="jvPAAAwWIY0fUB"/>
<row_element column="0" component_tag="37967" property_name="item_id">000010</row_element>
<row_element column="1" component_tag="37968" property_name="platform">S4</row_element>
<row_element column="2" component_tag="37968" property_name="equipment_names">d</row_element>
</row>
<row>
<object_tag tag="36053" uid="k8OAAAhQIY0fUB"/>
<object_tag tag="36037" uid="0IDAAAhQIY0fUB"/>
<object_tag tag="33521" uid="0EPAAAhQIY0fUB"/>
<row_element column="0" component_tag="36053" property_name="item_id">000016</row_element>
<row_element column="1" component_tag="36037" property_name="platform">S4</row_element>
<row_element column="2" component_tag="36037" property_name="equipment_names">k</row_element>
</row>
<row>
<object_tag tag="36053" uid="k8OAAAhQIY0fUB"/>
<object_tag tag="36037" uid="0IDAAAhQIY0fUB"/>
<object_tag tag="33521" uid="0EPAAAhQIY0fUB"/>
<row_element column="0" component_tag="36053" property_name="item_id">000016</row_element>
<row_element column="1" component_tag="36037" property_name="platform">S4</row_element>
<row_element column="2" component_tag="36037" property_name="equipment_names">l</row_element>
</row>
<row>
<object_tag tag="36053" uid="k8OAAAhQIY0fUB"/>
<object_tag tag="36037" uid="0IDAAAhQIY0fUB"/>
<object_tag tag="33521" uid="0EPAAAhQIY0fUB"/>
<row_element column="0" component_tag="36053" property_name="item_id">000016</row_element>
<row_element column="1" component_tag="36037" property_name="platform">S3</row_element>
<row_element column="2" component_tag="36037" property_name="equipment_names">m</row_element>
</row>
<row>
<object_tag tag="36053" uid="k8OAAAhQIY0fUB"/>
<object_tag tag="36037" uid="0IDAAAhQIY0fUB"/>
<object_tag tag="33521" uid="0EPAAAhQIY0fUB"/>
<row_element column="0" component_tag="36053" property_name="item_id">000016</row_element>
<row_element column="1" component_tag="36037" property_name="platform">S4</row_element>
<row_element column="2" component_tag="36037" property_name="equipment_names">n</row_element>
</row>
<row>
<object_tag tag="36053" uid="k8OAAAhQIY0fUB"/>
<object_tag tag="36037" uid="0IDAAAhQIY0fUB"/>
<object_tag tag="33521" uid="0EPAAAhQIY0fUB"/>
<row_element column="0" component_tag="36053" property_name="item_id">000016</row_element>
<row_element column="1" component_tag="36037" property_name="platform">S4</row_element>
<row_element column="2" component_tag="36037" property_name="equipment_names">o</row_element>
</row>
<row>
<object_tag tag="36053" uid="k8OAAAhQIY0fUB"/>
<object_tag tag="36037" uid="0IDAAAhQIY0fUB"/>
<object_tag tag="33521" uid="0EPAAAhQIY0fUB"/>
<row_element column="0" component_tag="36053" property_name="item_id">000017</row_element>
<row_element column="1" component_tag="36037" property_name="platform">S4</row_element>
<row_element column="2" component_tag="36037" property_name="equipment_names">p</row_element>
</row>
</rows>
<SearchCriteriaTitle>Search Criteria Used: (10 Objects found)</SearchCriteriaTitle>
<SearchCriteria>platform = S4</SearchCriteria>
<SearchCriteria>Type = DMDE_ProjectRevision</SearchCriteria>
</DisplayDefinitionTable>



After studying a lot abt grouping in XSLT 1.0 including here.. we came up with this stylesheet.

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

<xsl:stylesheet
version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="keyTeamID" match="row" use="row_element[2]" />
<xsl:key name="keyEmployeeID" match="row" use="row_element[1]" /> <xsl:template match="/">
<xsl:apply-templates/>
</xsl:template>

<xsl:template match="DisplayDefinitionTable">
<html>
<head>
<title>Default xml Report</title>

</head>
<body>

<P align="Center"><img alt="UGS" src="images/company_logo.gif"/></P>
<xsl:apply-templates select="ReportDesignName" />

<table border = "1">
<xsl:apply-templates select="columns" />
<xsl:apply-templates select="rows">
</xsl:apply-templates>
</table>
<P></P>
<xsl:apply-templates select="SearchCriteriaTitle" />
<xsl:apply-templates select="SearchCriteria" />
<P> <a href="#Top">Go to top of page</a> </P>
</body>
</html>
</xsl:template>

<xsl:template match="ReportDesignName">
<P align="Center">
<font size="+2" face="Verdana"><b>
<xsl:value-of select="." />
</b></font>
</P>
<P align="right">
<font size="2" face="Verdana"><B>

</B></font>
</P>
<P align="right"> <a href="#Search Criteria Used:">Search Criteria Used </a> </P>
</xsl:template>

<xsl:template match="columns">
<tr bgcolor = "silver">
<xsl:apply-templates select="column_entry"/>
</tr>
</xsl:template>
<xsl:template match="column_entry">
<th>
<xsl:value-of select="." />
</th>
</xsl:template>

<xsl:template match="//row[position() mod 2 = 0]">
<tr>
<xsl:apply-templates select="row_element" />
</tr>
</xsl:template>

<xsl:template match="//row[position() mod 2 = 1]">
<tr bgcolor ="#FFFFAA">
<xsl:apply-templates select="row_element" />
</tr>
</xsl:template>

<xsl:template match="row_element">

<td>
<xsl:value-of select="." />
<xsl:text disable-output-escaping="yes">&amp;nbsp;</xsl:text>
</td>
</xsl:template>

<xsl:template match="SearchCriteriaTitle">
<l><b><font size="2" face="Verdana"><a name="Search Criteria Used:"></a>
<xsl:value-of select="." />
</font></b></l>
</xsl:template>

<xsl:template match="SearchCriteria">
<li>
<xsl:value-of select="." />

</li>
</xsl:template>
<xsl:template match="rows" >
<xsl:for-each select="//row[generate-id(.) = generate-id(key('keyTeamID', row_element[2]))]">
<xsl:variable name="lngTeamID"><xsl:value-of select="row_element[2]" /></xsl:variable>

<!-- Select all the Employees belonging to the Team -->

<xsl:variable name="lstEmployee" select="//row[row_element[2]=$lngTeamID]" />


<xsl:call-template name="ShowEmployeesInTeam">
<xsl:with-param name="lstEmployee" select="$lstEmployee" />

</xsl:call-template>

</xsl:for-each>
</xsl:template>
<xsl:template name="ShowEmployeesInTeam">
<xslaram name="lstEmployee" />
<!-- Show the name of the Team currently being processed -->
<tr>


<xsl:for-each select="$lstEmployee[generate-id(.) = generate-id(key('keyEmployeeID', row_element[1]))]">
<xsl:variable name="lngEmployeeID" select="row_element[1]" />
<tr><td><xsl:value-of select="$lstEmployee[row_element[1]=$lngEmployeeID]/row_element[1]" /></td>

<td>
<xsl:value-of select="$lstEmployee[row_element[1]=$lngEmployeeID]/row_element[2]" />

</td>
<td> <xsl:for-each select="$lstEmployee[row_element[1]=$lngEmployeeID]">
<xsl:value-of select="row_element[3]" />
</xsl:for-each>
</td>

</tr>
</xsl:for-each>
</tr>

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


Current output is

Item ID Platform Equipment Names

000010 S4 abcd
000016 S4 klno
000017 S4 p


Required output is

Item ID Platform Equipment Names

000010 S4 abcd
000016 S4 klno
000016 S3 m
000017 S4 p


Basically we want grouping by itemid (which seems to be happening) and then grouping by platform(which does not happen)

Can you provide some pointers and any help would be truly appreciated.

Cheers!

Posttop
(Deleted User) Subject: XSLT 1.0 Grouping Small change reqd! please help
Author: (Deleted User)
Date: 11 May 2010 10:52 AM
Hi Arjun,
this is a question related to the XSLT language only, and will be better answered on a XSLT mailist list.

Sorry,
Alberto
   
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.