xsl-list
[Top] [All Lists]

[xsl] Finding and comparing a parent attribute for the next result in a for-each loop

2008-08-07 09:28:35
Hi all,

I'm fairly new to XSLT and am having no end of difficulty sorting the data from the following XML:

<resource day="04" live="200707040000" month="07" monthname="July" year="2007">
                <title>Title 1</title>
                <section name="Articles">
                        <subsection>section 1</subsection>
                </section>
        </resource>
<resource day="10" live="200701100000" month="01" monthname="January" year="2007"> <title>Competition: Commission energy sector inquiry confirms serious competition problems </title>
                <section name="News releases">
                        <subsection>section 1</subsection>
                </section>
                <section name="Articles">
                        <subsection>section 1</subsection>
                </section>
        </resource>

and so on, for as many resources as there are.

I have managed to sort the data by section and correspondingly by subsection, but now I am having problems drilling down through the navigation, to display all the years for each section (and subsection).

The XSL I have done so far is rubbish, but here goes:

<xsl:choose>
        <xsl:when test="$subsection = ''">
                <xsl:for-each select="//section[(_at_)name=$section]">
                <xsl:sort select="../@live" order="descending"/>
<xsl:if test="not(parent::resource/following-sibling::resource/@year=parent::node()/@year)">
                                <li><!-- list item lives here --><xsl:value-of 
select="../@year"/></li>
                        </xsl:if>
                </xsl:for-each>
        </xsl:when>
        <xsl:otherwise>
                <xsl:for-each 
select="//section[(_at_)name=$section][node()=$subsection]">
                <xsl:sort select="../@live" order="descending"/>
<xsl:if test="not(parent::resource/following-sibling::resource/@year=parent::node()/@year)">
                                <li><!-- list item lives here --><xsl:value-of 
select="../@year"/></li>
                        </xsl:if>
                </xsl:for-each>
        </xsl:otherwise>
</xsl:choose>

Ideally it should produce a list of all years, so the user can browse the resources by year. All | 2008 | 2007 | 2006 etc

Yup - it's gorgeous old XSLT 1.0 - I don't doubt there is a brilliant tag in XSLT 2.0 but hey ho.

The problem seems to be that the following-sibling of the parent node doesn't return the next node in the for-each, but the next node in the main xml. So sometimes it returns no results at all because there's a following sibling in a node which it shouldn't be looking at.

I'm sure I'm making a simple mistake, but for the life of me I can't figure out what it is.

All help gratefully appreciated!

Kate




--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>