Integrate Software AG Products Using Digital Event Services : MashZone NextGen Help : Appendix : Legacy Presto components : Mashables and Mashups : Mashups in EMML : Advanced Mashup Techniques : Using XQuery for Outer Joins : Sample Mashable Results
Sample Mashable Results
This sample of an outer join uses three"results" from mashables that are shown for clarity as variables:
Suppliers Results
<variable name="suppliers" type="document">
<suppliers>
<supplier>
<supplierId>s1</supplierId>
<supplierName>Genoa and Sons</supplierName>
</supplier>
<supplier>
<supplierId>s2</supplierId>
<supplierName>Angora, Ltd.</supplierName>
</supplier>
<supplier>
<supplierId>s3</supplierId>
<supplierName>Desideratti</supplierName>
</supplier>
</suppliers>
</variable>
Items Results
<variable name="items" type="document">
<items>
<item>
<partId>p1</partId>
<supplierId>s1</supplierId>
<price>10</price>
</item>
<item>
<partId>p2</partId>
<supplierId>s1</supplierId>
<price>10</price>
</item>
<item>
<partId>p3</partId>
<supplierId>s1</supplierId>
<price>10</price>
</item>
<item>
<partId>p2</partId>
<supplierId>s2</supplierId>
<price>11</price>
</item>
</items>
</variable>
Parts Results
<variable name="parts" type="document">
<parts>
<part>
<partId>p1</partId>
<description>Dupioni Silk, grey/blue</description>
</part>
<part>
<partId>p2</partId>
<description>Angora wool, cream</description>
</part>
<part>
<partId>p3</partId>
<description>Cashmere, pink</description>
</part>
<part>
<partId>p4</partId>
<description>Paisley, gold and blue</description>
</part>
<part>
<partId>p5</partId>
<description>Georgette, white</description>
</part>
</parts>
</variable>
Copyright © 2017 Software AG, Darmstadt, Germany.
Product LogoContact Support   |   Community   |   Feedback