Tricky conditional selection

crabsdf · April 28th, 2008, 07:13 PM

Sorry for the bad title, I don't really know what to classify the problem as.

A snippet of my XML showing structure:

Code:

<Transactions>
  <Transaction>
    <FundTransaction>
      <tsmf_fund><fund_id>1</fund_id></tsmf_fund>
      <!--data I need->
    </FundTransaction>
    <FundTransaction>
      <tsmf_fund><fund_id>2</fund_id></tsmf_fund>

    </FundTransaction>
  </Transaction>
  <Transaction>
    <FundTransaction>
      <tsmf_fund><fund_id>1</fund_id></tsmf_fund>

    </FundTransaction>
  </Transaction>
</Transactions>
<StaticData>
  <tsmf_fund>
    <fund_id>1</fund_id>
  </tsmf_fund>
  <tsmf_fund>
    <fund_id>2</fund_id>
  </tsmf_fund>
  <tsmf_fund>
    <fund_id>3</fund_id>
  </tsmf_fund>
</StaticData>

Basically I want up to three (in this case only) iterations of a loop, one for each node "tsmf_fund" in //StaticData. Up to three because I only want to do the loop iteration if the fund_id is actually used somewhere in //Transactions. In this example I don't want the iteration of the loop for fund_id = 3 because it is not used.

This is what i've tried so far, all not returning any results.

Code:

<xsl:for-each select="//StaticData/tsmf_fund[count(//Transaction/FundTransaction[tsmf_fund/fund_id = current()/fund_id]) &gt; 0]">
<xsl:for-each select="//StaticData/tsmf_fund[//Transaction/FundTransaction[tsmf_fund/fund_id = current()/fund_id]]">
<xsl:for-each select="//StaticData/tsmf_fund[//Transaction/FundTransaction/tsmf_fund/fund_id = current()/fund_id]">
<xsl:for-each select="//StaticData/tsmf_fund[//FundTransaction/tsmf_fund/fund_id = current()/fund_id]">
<xsl:for-each select="//StaticData/tsmf_fund[//FundTransaction/[tsmf_fund/fund_id = current()/fund_id]]">

More specifically, the condition is: there exists a node "Transaction" in //Transactions/ which contains a node "FundTransaction" which has /tsmf_fund/fund_id equal to the fund_id in the iteration of the //StaticData loop.

mhkay · April 28th, 2008, 07:40 PM

<xsl:for-each select="//StaticData/tsmf_fund[count(//Transaction/FundTransaction[tsmf_fund/fund_id = current()/fund_id]) > 0]">

The meaning of this depends crucially on what current() is, which you haven't told us. I can't see any possible value of current() in which this expression would make sense. The same applies to your other attempts. To select the find_id elements in StaticData that match one in Transactions, try

<xsl:variable name="tf" select="//Transactions//fund_id"/>

then

//StaticData/tsmf_fund[fund_id = $tf]

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

crabsdf · April 28th, 2008, 08:14 PM

Ok, my understanding of current() was incorrect. current() returns the root node and so the expression "current()/fund_id" equals "//fund_id" and so will always return false.
My intention, however, was for current() to return the //StaticData/tsmf_fund node that the function is testing in the for-each loop.