Display rows based on a parameter

rabs · March 17th, 2009, 01:07 PM

This is in xslt 1.0

I have the following xsl.

Code:

<xsl:variable name="numPr" select="$dcrl/pressreleasestoreturn" />
<xsl:for-each select="$dcr">
                    <xsl:sort order="descending" select="concat(substring(date,7,4), substring(date,1,2), substring(date,4,2))"/>
                    <xsl:variable name="numtext" select="$dcrl/textreturnsize"/>
                    <xsl:choose>
                      <xsl:when test="$numtext != ''">
                        <a href="$PAGE_LINK[/press-releases/detail]dcr={@dcr}"><xsl:value-of select="substring(title,1,$numtext)"/></a><br/>
                      </xsl:when>
                      <xsl:otherwise>
                        <a href="$PAGE_LINK[/press-releases/detail]dcr={@dcr}"><xsl:value-of select="title"/></a><br/>
                      </xsl:otherwise>
                    </xsl:choose>  
                  </xsl:for-each>

I need to display a number of rows based on the value of $numPr.

How do I limit the number of rows displayed, after the rows have been sorted by date - I need to display the latest articles, based on $numPr.

My xml is below....

Code:

<Properties>
   -   <Data>
   -     <Result >
   -       <Externals>  
     <PressRelease>
                   <date>10/02/08</date> 

                <title>Media Centre PR</title>                

        </PressRelease>





-       </Externals>
 
      </Result>
   -   </Data>
</Properties>

Thanks

Martin Honnen · March 17th, 2009, 01:50 PM

It is not clear what kind of rows you are referring to as neither the XML nor the stylesheet has any 'row' elements (or XHTML 'tr' elements for instance).
If you have an

Code:

<xsl:for-each select="foo">
  <xsl:sort select="bar"/>

and you want to output only the first $numPr elements in sort order then you can use e.g.

Code:

<xsl:for-each select="foo">
   <xsl:sort select="bar"/>
   <xsl:if test="position() &lt;= $numPr">
      <!-- now output stuff here e.g. -->
      <xsl:copy-of select="."/>
   </xsl:if>
</xsl:for-each>

Does that help? If not then please provide a relevant but minimal well-formed XML sample and the corresponding XML or HTML transformation result you want to create with your stylesheet.

rabs · March 17th, 2009, 02:21 PM

Thanks Martin - that worked.