Subject: [xsl] Q on <xsl:sort> From: "Walter Torres" <walter@xxxxxxxxx> Date: Tue, 1 May 2001 15:08:16 -0500 |
I have this snippet... (see below) I have a four record sample set ( 1 record sample xml is below ). Each record is different date/times. My problem is that this sort is not sorting on what I thought it would. It should display... record 4 record 1 record 3 record 2 But it is... record 4 record 3 record 2 record 1 It looks like it is displaying in reverse xml order not reverse timestamp order. any ideas? Walter =========================================================== <xsl:template match='callEvent/response/interaction_list'> <xsl:apply-templates> <xsl:sort select='./interaction/timestamp' order='descending' data-type='number' /> </xsl:apply-templates> </xsl:template> <!-- timestamp NODE Template --> <xsl:template match="timestamp"> <!-- Pull the pieces apart --> <xsl:variable name='datetime' select='.' /> <xsl:variable name='year' select='substring( $datetime, 0 , 5 )' /> <xsl:variable name='month' select='substring( $datetime, 6 , 2 )' /> <xsl:variable name='day' select='substring( $datetime, 9 , 2 )' /> <td valign='top'> <!-- put the date together in American order --> <xsl:value-of select="concat($month, '/', $day, '/', $year )" /> <!-- Seperate the date and Time --> - <!-- Display the Time --> <xsl:value-of select='substring( $datetime, 12 , 9 )' /> </td> </xsl:template> =========================================================== -- sample record, 1 of 4 in my demo set -- -- the interaction NODE is repeated in this set -- <callEvent> <response> <interaction_list> <interaction id='19766'> <timestamp unix='987413416000'>2001-04-16T04:30:32</timestamp> <media_type id='103'>Phone</media_type> <channel id='1'>-</channel> <ani></ani> <dnis></dnis> <route_type>I</route_type> <events> <call_event id='34757'> <timestamp unix='987413416000'>2001-04-16T04:30:32</timestamp> <call_event_type id='98'>eMail</call_event_type> <customer id='2124'>Harris</customer> <curr_dest id='103'>Vincent</curr_dest > <to_dest id='1'>-</to_dest> <nav_code id='1'>-</nav_code> <rule id='1'>-</rule> <greeting id='1'>-</greeting> <call_type id='1'>-</call_type> <ext_call id='1'>-</ext_call> <old_call_record id='1'>-</old_call_record> <product id='1'>-</product> <reason id='198'>Case Resolution</reason> <detailed_comment>Closed issue about bad check</detailed_comment> </call_event> </events> </interaction> </interaction_list> </response> </callEvent> ===================================== eof XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] using different xsl based, Robert Seber | Thread | Re: [xsl] Q on <xsl:sort>, Francis Norton |
Re: [xsl] ordering and iteration pr, Mark Nahabedian | Date | RE: [xsl] Q on <xsl:sort>, Clapham, Paul |
Month |