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: Jeff Saylor <JSaylor at diamondtechnology dot com>
- Date: Wed, 6 Sep 2000 13:35:25 -0400
- Reply-To: xsl-list at mulberrytech dot com
Steve,
Thanks for the prompt reply - the idea is great (I didn't know I could use a
function in the 'using' param - actually I am [obviously] weak in the
xsl:key arena) except that:
<xsl:key name="foo"
match="/xml/rs:data/z:row"
using="substring-before(@dCreated,'T')"/>
And using the Muenchian method for grouping:
<xsl:for-each
select="/xml/z:row/@dCreated[generate-id(.)=generate-id(key('CreatedDates',.
))]" >
<xsl:value-of select="." />
</xsl:for-each>
produces no output. Am I still missing something or is this just not
possible with the July MSXML release?
Again - appreciation in advance,
Jeffrey J. Saylor
PS weird to cite the name for something when it is named for the party I'm
typing to - should I have referred to it as "your" method? :)
-----Original Message-----
From: Steve Muench [mailto:smuench@us.oracle.com]
Sent: Wednesday, September 06, 2000 10:42 AM
To: xsl-list@mulberrytech.com
Subject: Re: Grouping by a piece of a date
| 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
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list