life of me I don't know how to do it.
What I want to do is select the Applicant with any income in a single
XPath query.
Here is a snippet of xml:
<Application>
<Applicant Id="xxxx">...</Applicant>
<Financial>
<Income Id="yyyy">
<Amount>24000</Amount>
<Reference Applicant="xxxx"/>
</Income>
...
</Financial>
</Application>
The XPath is:
Application/Applicant[sum(/Application/Financial/Income[Reference/@Applicant=@Id]/Amount)
0]The problem is, the @Id above is in the context of the *Income* but I
want it to be in the context of the *Applicant*
Any pointers ?
TIA
Dominic