declare variable $my:entityName as xs:string external; declare variable $databaseURI := concat('jdbc://getCreditDefaultSwapsByEntityName?cd%&', $my:entityName); declare variable $creditDefaultSwaps := collection($databaseURI); declare function local:equityRows($root) { for $equity in $root//equity let $referenceEntity := $creditDefaultSwaps//fpml:referenceEntity where $equity/name = $referenceEntity/fpml:entityName return { $equity/*:symbol/text() } { $equity/*:name/text() } { $equity/*:high/text() } { $equity/*:currency/text() } }; { local:equityRows(/) }
Ticker Symbol Company Name High Currency