XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
kiran KumarSubject: Problem for finding XPath.
Author: kiran Kumar
Date: 17 Dec 2005 05:59 AM
Originally Posted: 17 Dec 2005 05:58 AM
I have nodes <br> <markets><br> <market id="20"><br> <runner outcome-id="330"/><br> <runner outcome-id="331"/><br> </market><br> <market id="21"><br> <runner outcome-id="334"/><br> <runner outcome-id="335"/><br> </market><br> <market id="22"><br> <runner outcome-id="334"/><br> <runner outcome-id="335"/><br> </market><br> <market id="23"><br> <runner outcome-id="330"/><br> <runner outcome-id="331"/><br> </market><br> <markets><br> <br> I want to have all markets-ids with same runner/@outcome-id<br> For the above example the result should be <markets><br> <market-ids>23,20<market-ids><br> <market-ids>21,22<market-ids><br> </markets> Can some one help me finding xquary for this.

Minollo I.Subject: Problem for finding XPath.
Author: Minollo I.
Date: 18 Dec 2005 10:33 PM
In XQuery you could do something like this:
for $market in /markets/market
let $allRunners := $market/runner/@outcome-id
for $market1 in $market/following-sibling::market
let $allRunners1 := $market1/runner/@outcome-id
where deep-equal($allRunners,$allRunners1)
{concat($market/@id, ',', $market1/@id)}

(you may have to change the use of fn:deep-equal() if your conditions require different semantics)

In XSLT you can do something like this:
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<xsl:for-each select="markets/market">
<xsl:variable name="marketID">
<xsl:value-of select="@id"/>
<xsl:variable name="runners">
<xsl:for-each select="runner/@outcome-id">
<xsl:value-of select="."/>-</xsl:for-each>
<xsl:for-each select="following-sibling::market">
<xsl:variable name="runners-1">
<xsl:for-each select="runner/@outcome-id">
<xsl:value-of select="."/>-</xsl:for-each>
<xsl:if test="$runners = $runners-1">
<xsl:value-of select="$marketID"/>,<xsl:value-of select="@id"/></market-ids>

(Again, you may have to play with the "$runners = $runners-1" condition)

Hope this helps,

Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.