This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Is it possible to filter for all "distinct" nodes having a"specific" date?


Hi.  I am trying to get all the "distinct" records (by "pagename") for a specific date.  If I filter for just the "distinct" records it works.  If I filter for just the "specific" date it works.  If I do both at the same time it doesn't work.  Does anyone have any idea what I need to do differently?  Thanks

Please see the xml & xsl files below ...

[xsl file]

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; >

 <xsl:template match="/">
 
  <html>
  <body>
  
  <!-- GET ALL [RECORD] ELEMENTS WITH SPECIFIC DATE & DISTINCT 'pagename':  DOES NOT WORK IF BOTH ARE SPECIFIED -->
  <!-- <xsl:apply-templates select="records/record[translate(date,'/','')='31502' and not(preceding-sibling::record/pagename = pagename)]"/> -->
  
  <!-- GET ALL [RECORD] ELEMENTS WITH SPECIFIC DATE:  WORKS! -->
  <xsl:apply-templates select="records/record[translate(date,'/','')='31502']"/>
  
  <!-- GET ALL [RECORD] ELEMENTS WITH DISTINCT 'pagename':  WORKS! -->
  <!-- <xsl:apply-templates select="records/record[not(preceding-sibling::record/pagename = pagename)]"/> -->
    
  </body>
  </html>
 
 </xsl:template>
 
 <xsl:template match="record">
  
  PageName: <xsl:value-of select="pagename"/>
  Date:  <xsl:value-of select="date"/>
  <br></br>
   
 </xsl:template>
 
</xsl:stylesheet>




[xml file]



<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="test 1.xsl"?>

<records>
   
 <record>
    <pagename>A</pagename>
    <hits>100</hits>
    <date>21502</date>
 </record>
  
 <record>
    <pagename>A</pagename>
    <hits>200</hits>
    <date>21502</date>
 </record>
  
 <record>
    <pagename>B</pagename>
    <hits>100</hits>
    <date>21502</date>
 </record>
  
 <record>
    <pagename>B</pagename>
    <hits>200</hits>
    <date>21502</date>
 </record>
  
 <record>
    <pagename>C</pagename>
    <hits>100</hits>
    <date>21502</date>
 </record>
  
 <record>
    <pagename>C</pagename>
    <hits>100</hits>
    <date>21502</date>
 </record>
 
 <record>
    <pagename>A</pagename>
    <hits>100</hits>
    <date>31502</date>
 </record>
  
 <record>
    <pagename>A</pagename>
    <hits>200</hits>
    <date>31502</date>
 </record>
  
 <record>
    <pagename>B</pagename>
    <hits>100</hits>
    <date>31502</date>
 </record>
  
 <record>
    <pagename>B</pagename>
    <hits>200</hits>
    <date>31502</date>
 </record>
  
 <record>
    <pagename>C</pagename>
    <hits>100</hits>
    <date>31502</date>
 </record>
  
 <record>
    <pagename>C</pagename>
    <hits>200</hits>
    <date>31502</date>
 </record>
  
</records>






THANKS










 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]