Hello all,
I am really new to XSL and have run into a problem I can't get a handle
on. I am developing a document tracking system that will help out with
letting employees know what documents are out for review, and when those
reviews are due. I am also throwing in a list of all documents in the
library. My current XML file looks like this:
<?xml version="1.0" encoding="utf-8"?>
<?xml-stylesheet type="text/xsl" href="gatorDocLibXsl_t3.xsl"?> <DocLib>
<document>
<title>Document 1</title>
<version>3.0</version>
<category>IRS</category>
<docReview>
<complete>0</complete>
<dueDate>11/30/2007</dueDate>
<commentTemplateFile>c:\temp\reviewTemplate.xls</commentTemplateFile>
</docReview>
<adjudication>
<date>12/1/2007</date>
</adjudication>
</document>
<document>
<title>Document 2</title>
<version>0.1</version>
<category>IRS</category>
<docReview>
<complete>0</complete>
<dueDate>11/23/2007</dueDate>
<commentTemplateFile>c:\temp\reviewTemplate.xls</commentTemplateFile>
</docReview>
<adjudication>
<date>12/5/2007</date>
</adjudication>
</document>
<document>
<title>Document 3</title>
<version>0.2</version>
<category>SRS</category>
<docReview>
<complete>1</complete>
<dueDate>11/01/2007</dueDate>
<commentTemplateFile>c:\temp\reviewTemplate.xls</commentTemplateFile>
</docReview>
<adjudication>
<date>1/5/2007</date>
</adjudication>
</document>
<document>
<title>Document 4</title>
<version>1.0</version>
<category>SSS</category>
<docReview>
<complete>0</complete>
<dueDate>12/08/2007</dueDate>
<commentTemplateFile>c:\temp\reviewTemplate.xls</commentTemplateFile>
</docReview>
<adjudication>
<date>12/10/2007</date>
</adjudication>
</document>
<document>
<title>Document 1</title>
<version>2.0</version>
<category>IRS</category>
<docReview>
<complete>1</complete>
<dueDate>11/23/2007</dueDate>
<commentTemplateFile>c:\temp\reviewTemplate.xls</commentTemplateFile>
</docReview>
<adjudication>
<date>12/1/2007</date>
</adjudication>
</document>
<document>
<title>Document 1</title>
<version>1.0</version>
<category>IRS</category>
<docReview>
<complete>1</complete>
<dueDate>11/23/2007</dueDate>
<commentTemplateFile>c:\temp\reviewTemplate.xls</commentTemplateFile>
</docReview>
<adjudication>
<date>12/1/2007</date>
</adjudication>
</document>
</DocLib>
So far I have figured out how to group my output by category. I also
need to group the documents within the category by title so that I can
sort them by version number. Below is my current stylesheet for
grouping by category.
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
<!-- Define keys for processing -->
<xsl:key name="documentsByCategory" match="document" use="category"/>
<!-- Main processing -->
<xsl:template match="DocLib">
<!-- Display all documents that are under review in a table-->
<table border="1">
<caption>Documents for Review</caption>
<tr>
<th>Document Title</th>
<th>Version</th>
<th>Due Date</th>
<th>Adjudication Date</th>
<th>Comment Template</th>
</tr>
<xsl:for-each select="document">
<xsl:sort select="substring(docReview/dueDate,7,4)"/> <!--
Sort Day -->
<xsl:sort select="substring(docReview/dueDate,1,2)"/> <!--
Sort Day -->
<xsl:sort select="substring(docReview/dueDate,4,2)"/> <!--
Sort Day -->
<xsl:if test="docReview/complete='0'">
<tr>
<td><xsl:value-of select="title"/></td>
<td><xsl:value-of select="version"/></td>
<td><xsl:value-of select="docReview/dueDate"/></td>
<td><xsl:value-of select="adjudication/date"/></td>
<td><xsl:value-of
select="docReview/commentTemplateFile"/></td>
</tr>
</xsl:if>
</xsl:for-each>
</table>
<br/>
<!-- Display all documents in the library in table format. The
documents
will be grouped by category (IRS, SSS, SRS, etc), then
grouped by
document name, and then sorted by version number. -->
<!-- This loop selects the unique categories and loops through
them
iteratively making a table from each category -->
<xsl:for-each select="document[count(. |
key('documentsByCategory', category)[1]) = 1]">
<xsl:sort select="category"/>
<br/>
<table border ="1">
<caption><xsl:value-of select="category"/>
Documents</caption>
<tr>
<th>Title</th>
<th>Version</th>
<th>Review Comments/Response File</th>
</tr>
<!-- This loops through all of the documents in each
category -->
<xsl:for-each select="key('documentsByCategory',
category)">
<xsl:sort select="title"/>
<tr>
<td><xsl:value-of select="title"/></td>
<td><xsl:value-of select="version"/></td>
<!-- <td><xsl:value-of
select="docReview/reviewCommentsFile"/></td> -->
</tr>
</xsl:for-each>
</table>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
Could someone please help me out with grouping both on category and
title? I have looked through the archive postings most of the day and I
still cannot figure out how this works. I am terribly confused and
cannot find a lot of information on this on the web.
Thanks for the help,
Rob Hix
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--