RE: Q on <xsl:sort>

You told it to sort as if the data it was sorting was a number.  So it takes
'2001-04-16T04:30:32' and converts it to a number; what does this give?
Probably NaN.  So since all the data items being sorted are NaN, the sort
has to fall back on document order, and since you asked for descending, you
get reverse document order.

PC2

-----Original Message-----
From: Walter Torres [mailto:walter@xxxxxxxxx]
Sent: May 1, 2001 13:08
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject:  Q on <xsl:sort>


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