IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

x-query with join from different collections

  • 1.  x-query with join from different collections

    Posted Thu August 02, 2007 04:58 PM

    Hi
    I wanted to make a tamino x-query with a join with data from different collections.
    how and where i can set the collection?
    or isnt it possible to do so?

    example:
    for $x in input()/Order[OrderNo=“0000000994”],
    $y in input()/Branch
    where $x/BuyerBranchGID = $y/@GID
    return

    { $b/@GID }
    { $b/BranchILN }

    Order is in collection: MLSSyncSupplier
    Branch is in collection: MLSSyncGlobal


    #webMethods
    #API-Management
    #Tamino


  • 2.  RE: x-query with join from different collections

    Posted Thu August 02, 2007 05:11 PM

    you can use the collection() function:

    
for $x in collection("MLSSyncSupplier")/Order[OrderNo="0000000994"],
$y in collection("MLSSyncGlobal")/Branch
where $x/BuyerBranchGID = $y/@GID
return
<Result>
{ $b/@GID }
{ $b/BranchILN }
</Result>

    Best regards

    Harald


    #API-Management
    #Tamino
    #webMethods


Related Content