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
Postnext
Neal WaltersSubject: How to Build a Dynamic XPath Expression in XSLT
Author: Neal Walters
Date: 26 Aug 2008 10:33 AM
I'm sure this question has been asked before, but I couldn't find it.
Is there a way (using extensions or whatever) to build a dynamic xpath expression? Here's a sample:

<Root>
<Group1>
<Account>123</Account>
<AccountCode>ABC</AccountCode>
</Group1>
<Group2>
<AccountInfo>
<Account>123</Account>
<Firstname>Neal</Firstname>
</AccountInfo>
<AccountInfo>
<Account>456</Account>
<Firstname>Sam</Firstname>
</AccountInfo>
</Group2>
</Root>

I want to loop through Group1, and then look up data inside Group2 to output Group3. I have omitted the looping below.



<AccountCode>
<xsl:value-of select="*[local-name()='AccountCode']"/>
</AccountCode>
<Firstname>
<xsl:value-of select="//*[local-name()='Group2']/[local-name()='Firstname']/..[local-name()="Account"][text()="123"]"/>
</Firstname>


Here's the concept in pseudocode:

<Firstname>
$var1 = select="*[local-name()='Account']"
<xsl:value-of select="//*[local-name()='Group2']/[local-name()='Firstname']/..[local-name()="Account"][text()="$var1"]"/>
</Firstname>

Unfortunately, I haven't touched XSLT in about 18 months, so it gets rusty fast.

Thanks,
Neal Walters
http://BizTalk-Training.com - Learn BizTalk Faster

Postnext
Minollo I.Subject: How to Build a Dynamic XPath Expression in XSLT
Author: Minollo I.
Date: 26 Aug 2008 11:44 AM
Something like:

<xsl:for-each select="//Group1">
<xsl:variable name="accountCode" select="AccountCode"/>
<Group3>
<AccountCode>
<xsl:value-of select="$accountCode"/>
</AccountCode>
<Firstname>
<xsl:value-of select="//Group2/AccountInfo[Account = $accountCode]/FirstName"/>
</Firstname>
</Group3>
</xsl:for-each>

Posttop
Neal WaltersSubject: How to Build a Dynamic XPath Expression in XSLT
Author: Neal Walters
Date: 26 Aug 2008 12:36 PM
Thanks!!!

 
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!  
go

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.