This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: Grouping by a piece of a date
- To: <xsl-list at mulberrytech dot com>
- Subject: Re: Grouping by a piece of a date
- From: "Steve Muench" <smuench at us dot oracle dot com>
- Date: Wed, 6 Sep 2000 07:41:44 -0700
- References: <3A6A4957259DD311AFDF00902773C740359B45@gebo.pandemonium.fr>
- Reply-To: xsl-list at mulberrytech dot com
| given xml with date attributes, I want to be able to group them by day.
| Using the Muenchian method I can group by the entire value, but I can't
| figure out how to group by only a piece of it. For example, given the
| following XML:
|
| <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
| xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
| xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
:
| <rs:data>
| <z:row iID="1" dCreated="1900-01-01T01:00:00"/>
| <z:row iID="2" dCreated="1900-01-02T01:00:00"/>
| <z:row iID="3" dCreated="1900-01-02T02:00:00"/>
| <z:row iID="4" dCreated="1900-01-04T01:00:00"/>
| </rs:data>
| </xml>
If I've not misunderstood what you're going for, then
you should be able to use the substring-before() function
in the <xsl:key> declaration like this:
<xsl:key name="foo"
match="/xml/rs:data/z:row"
using="substring-before(@dCreated,'T')"/>
This way, an attempt to lookup:
key("foo","1900-01-02")
should find the <z:row> elements:
<z:row iID="2" dCreated="1900-01-02T01:00:00"/>
<z:row iID="3" dCreated="1900-01-02T02:00:00"/>
Because both of these have the substring-before their
"dCreated" attribute value of "1900-01-02".
______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG
Author "Building Oracle XML Applications", O'Reilly
http://www.oreilly.com/catalog/orxmlapp/
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list