MashZone NextGen 10.2 | 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 © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release