Using a linkdoc to exclude rows

geordaa · August 24th, 2006, 10:01 AM

I am using a linkdoc to exclude certain fields from output within a template. Now I have a requirement to exclude certain rows if a value exists in the external xml. I would really like to exclude at the "for-each", and this is one of the attempts I have made (to no avail):

<xsl:for-each select="body/row[not($linkDoc/*/GROUP[@NAME='COSTCENTRE']/VALUE[@KEY=field2])]">

And a section from the linkdoc:

<Project_LOOKUP>
    <GROUP NAME="COSTCENTRE">
        <VALUE KEY="TEST">1</VALUE>
    </GROUP>

Xml:

<root>
    <body>
    <row>
            <field1>1</field1>
            <field2>DATE</field2>
        </row>
        <row>
            <field1>2</field1>
            <field2>DAVE</field2>
        </row>
        <row>
            <field1>2</field1>
            <field2>TEST</field2>
        </row>
    </body>
</root>

I want to ignore:

<row>
    <field1>2</field1>
    <field2>TEST</field2>
</row>

because TEST exists in the Linkdoc.

Tried different combinations, but I cannot get the syntax right.

Any help appreciated.

mhkay · August 24th, 2006, 11:19 AM

Change field2 to current()/field2.

You need to tell it that field2 is in your original document, not deep within the linkdoc.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference