XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » XSLT Newbie needs help... Should be easy fix!
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + Use of before and after string (3) Sticky Topic
-> - How do I substitute element ty... (1)
-> + How does one add working days ... (4)
-> - Help, I have existing XLT and... (1)
-> + Need help on XSLT issue - (2)
-> + EDI to XML Conversion (7)
-> - XML To JSON Conversion using X... (1)
-> + Formatting Paragraphs to same ... (2)
-> - Grouping of records (1)
-> + Problems with xsd 1.1 (4)
-> + XML to HL7 mapping (3)
-> + XSLT 3 and Iterate (2)
-> + XSL-FO to PDF preview (3)
-> + java.lang.RuntimeException: Er... (2)
-> + Create Acroforms with Stylus X... (2)
-> + How to change XSLT parameter s... (3)
-> + how to change format of the da... (2)
-> + Search "Next 8 Results " doesn... (2)
-> - Support for Git (1)
-> + newbee (8)
-- [1-20] [21-40] [41-60] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Vagyok c4Subject: XSLT Newbie needs help... Should be easy fix!
Author: Vagyok c4
Date: 17 Nov 2005 04:21 PM
I'm a newbie to XML/XSLT, and I'm sure this is very easy to do for someone who has experience in it... I'm trying to make an XSLT file that displays ONLY <CurrentValue> and <DbValue> of those items who's <IsChanged> value = "True". Can someone please fix this XSLT source for me???

----------- XSLT START -----------
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<table border="1">
<tr>
<th>Old Value</th>
<th>New Value</th>
</tr>
<xsl:apply-templates select="//Fields" />
</table>
</xsl:template>
<xsl:template match="Fields">
<tr>
<td>
<xsl:value-of select="<DbValue Goes Here>"/>
</td>
<td>
<xsl:value-of select="<CurrentValue Goes Here>"/>
</td>
</tr>
</xsl:template>
</xsl:stylesheet>
----------- XSLT STOP -----------

Here is my sample XML file...

----------- XML START -----------
<Fields>
<PhoneNumber>
<CurrentValue Type="System.String">888-555-1212</CurrentValue>
<DbValue Type="System.String">800-555-1212</DbValue>
<IsChanged Type="System.Boolean">True</IsChanged>
<IsNull Type="System.Boolean">False</IsNull>
</PhoneNumber>
<PhoneType>
<CurrentValue Type="AMENTOR4UDB.PhoneTypes">Home</CurrentValue>
<DbValue Type="AMENTOR4UDB.PhoneTypes">Home</DbValue>
<IsChanged Type="System.Boolean">False</IsChanged>
<IsNull Type="System.Boolean">False</IsNull>
</PhoneType>
<ContactId>
<CurrentValue Type="System.Int64">100</CurrentValue>
<DbValue Type="System.Int64">100</DbValue>
<IsChanged Type="System.Boolean">False</IsChanged>
<IsNull Type="System.Boolean">False</IsNull>
</ContactId>
<EmailAddress>
<CurrentValue Type="System.String">company@email.com</CurrentValue>
<DbValue Type="System.String">my@email.com</DbValue>
<IsChanged Type="System.Boolean">True</IsChanged>
<IsNull Type="System.Boolean">False</IsNull>
</EmailAddress>
<EmailType>
<CurrentValue Type="AMENTOR4UDB.EmailTypes">Primary</CurrentValue>
<DbValue Type="AMENTOR4UDB.EmailTypes">Primary</DbValue>
<IsChanged Type="System.Boolean">False</IsChanged>
<IsNull Type="System.Boolean">False</IsNull>
</EmailType>
<ContactId>
<CurrentValue Type="System.Int64">100</CurrentValue>
<DbValue Type="System.Int64">100</DbValue>
<IsChanged Type="System.Boolean">False</IsChanged>
<IsNull Type="System.Boolean">False</IsNull>
</ContactId>
<EmailVerified>
<CurrentValue Type="System.Boolean">True</CurrentValue>
<DbValue Type="System.Boolean">True</DbValue>
<IsChanged Type="System.Boolean">False</IsChanged>
<IsNull Type="System.Boolean">False</IsNull>
</EmailVerified>
<EmailValidationKey>
<CurrentValue Type="System.Guid">00000000-0000-0000-0000-000000000000</CurrentValue>
<DbValue Type="System.Guid">00000000-0000-0000-0000-000000000000</DbValue>
<IsChanged Type="System.Boolean">False</IsChanged>
<IsNull Type="System.Boolean">False</IsNull>
</EmailValidationKey>
</Fields>
----------- XML STOP -----------

Postnext
(Deleted User) Subject: XSLT Newbie needs help... Should be easy fix!
Author: (Deleted User)
Date: 17 Nov 2005 07:48 PM
Originally Posted: 17 Nov 2005 07:49 PM
Hi,

First, thank you very much for providing complete well-formed input and for doing most of the .xsl yourself. It helps us help you much more quickly.

One of many possible solutions is attached.

Your problem (perhaps) was doing
apply-templates select="//Field"
and then trying to get the data out of DbValue.
But there is an extra level of nesting between Field and DbValue,
the elements PhoneNumber, PhoneType, etc.

So, just using
apply-templates select="//Field/*"
and then later on
template match="Field/*"
does the trick

Good luck with xslt.
- clyde


Documenttest(12).xsl
Postnext
Vagyok c4Subject: XSLT Newbie needs help... Should be easy fix!
Author: Vagyok c4
Date: 17 Nov 2005 08:50 PM
Very good...

How would I add one column to the table for "DataType" that would display the <Field Name> being updated... Ie. PhoneNumber, PhoneTypes???
Postnext
(Deleted User) Subject: XSLT Newbie needs help... Should be easy fix!
Author: (Deleted User)
Date: 18 Nov 2005 06:59 AM
Hi,
Well, You will need another header <th>....</th>.

In the data part of the table, you are in
<xsl:template match="Fields/*"/> so the node being matched (the context node) is one of the data nodes just below Fields. So you just want the
name of the context node:
<td>
<xsl:value-of select="name()"/>
</td>

- clyde
Postnext
Vagyok c4Subject: XSLT Newbie needs help... Should be easy fix!
Author: Vagyok c4
Date: 19 Nov 2005 11:57 PM
Originally Posted: 19 Nov 2005 11:55 PM
That worked great! My next question is... It is possible that one of the Values within the XML is another layer of XML nested within the XML structure under the fieldname <AuditLogXml>, usually with the same structure. My question, how can I nest the display? So that when the field is <AuditLogXml>, it creates a new table within the currently defined table displaying the <Field>, <DbValue>, <CurrentValue>???
Posttop
(Deleted User) Subject: XSLT Newbie needs help... Should be easy fix!
Author: (Deleted User)
Date: 21 Nov 2005 07:45 AM
First, can you please provide a sample if the xml input. I'm not sure where the <AuditLogXml> tag is supposed to be.

Then, can you build a sample of the desired .html output? You want to have one table nested inside another table. If you show me the desired output, we can figure out how to write the .xslt.

- clyde
   
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.