XSLT excluding elements based on an external document

ashcarrot · January 12th, 2009, 11:58 AM

I want to count and loop through elements in the master document excluding id's referenced in an external xml file, I can read the external document fine its just excluding that list thats the issue.

<xsl:value-of select="count(/compositeReport/bookReport/bookList/book)"/> -

<xsl:variable name="FILE" select="document('bookExclusionList.xml')"/>

<xsl:value-of select="count($FILE//bookId)"/>

<xsl:value-of select="count(/compositeReport/bookReport/bookList/book[not(count(bookId = $FILE//bookId) > 0)])"/>

The above doesn't work but it would be how i'd imagine it would. Im using XALAN and so are restricted to XSLT1.0 which is the problem. Is there a way of doing this?

Martin Honnen · January 12th, 2009, 12:05 PM

Please show us relevant samples of the two XML documents.

ashcarrot · January 12th, 2009, 12:15 PM

Here's the various xmls, thanks

Exclusion List:
<?xml version="1.0" encoding="utf-8"?>
<bookExclusionList>
<bookId>102687</bookId>
<bookId>102696</bookId>
</bookExclusionList>

MainDoc (shrunk for readability):

<compositeReport>
<bookReport>
<bookList>
<book>
<bookId>102733</bookId>
<categoryList>
<category>Software</category>
</categoryList>
<synopsis>blah Blah</synopsis>
</book>
<book>
<bookId>103121</bookId>
<categoryList>
<category>fiction</category>
</categoryList>
<synopsis>Some Book thing</synopsis>
</book>
</bookList>
</bookReport>
</compositeReport>

Martin Honnen · January 12th, 2009, 12:25 PM

If you want to count the book elements in the main document which have bookIds not listed in the exclusion list then I think you need

Code:

<xsl:value-of 
   select="count(/compositeReport/bookReport/bookList/book[not(bookId = document('bookExclusionList.xml')/bookExclusionList/bookId)])"/>

ashcarrot · January 12th, 2009, 12:40 PM

Problem is i get the following if i try this

Exception in thread "main" java.lang.VerifyError: (class: bookReport$0, method: test signature: (IIIILorg/apache/xalan/xsltc/runtime/AbstractTranslet;Lorg/apache/xml/dtm/DTMAxisIterator;)Z) Incompatible type for getting or setting field

Incidently its also the same when i try and do it other ways similar to this.

Martin Honnen · January 12th, 2009, 01:05 PM

I have tried the following stylesheet

Code:

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  version="1.0">
  
  <xsl:output method="text"/>
  
  <xsl:template match="/">
  <xsl:value-of 
   select="count(/compositeReport/bookReport/bookList/book[not(bookId = document('test2009011203.xml')/bookExclusionList/bookId)])"/>
  </xsl:template>

</xsl:stylesheet>

against the following two files:

Code:

<compositeReport>
<bookReport>
<bookList>
<book>
<bookId>102733</bookId>
<categoryList>
<category>Software</category>
</categoryList>
<synopsis>blah Blah</synopsis>
</book>
<book>
<bookId>103121</bookId>
<categoryList>
<category>fiction</category>
</categoryList>
<synopsis>Some Book thing</synopsis>
</book>
<book>
<bookId>102687</bookId>
<categoryList>
<category>Software</category>
</categoryList>
<synopsis>blah Blah</synopsis>
</book>
</bookList>
</bookReport>
</compositeReport>


<bookExclusionList>
<bookId>102687</bookId>
<bookId>102696</bookId>
</bookExclusionList>

with Saxon 6.5 and with Xalan java 2.7.1 from the command line and both output "2" as the correct result.
However when I try to use Xalan from the command line with the -xsltc flag then I get the error you describe. That looks like a bug in Xalan XSLTC as far as I can tell.
I think there is a Xalan user list where you might find more help with Xalan problems.