Generate ouput depending on subnode value

cristina.macias.614 · August 8th, 2011, 04:44 PM

Hi,

I have to generate an HTML table based on an XML that looks like this:

Code:

<table>
  <tablerow>
    <field name="CONTENT"><value>Some text</value></field>
    <field name="TYPE"><value>NORMAL</value></field>
  </tablerow>
 
  <tablerow>
    <field name="CONTENT"><value>Other text</value></field>
    <field name="TYPE"><value>ERROR</value></field>
  </tablerow>
</table>

I have no idea of how to use XSL to transform it to this output:

Code:

<table>
  <tr>
	<td><font color="BLUE">Some text</font></td>
  </tr>

  <tr>
	<td><font color="RED">Other text</font></td>
  </tr>
</table>

The problem is that all the nodes in the input are called the same way ('field'), and the meaning of the node is based on the attribute 'name'.

Any help will be appreciated

Thanks in advance,
Cristina.

samjudson · August 9th, 2011, 04:01 AM

Well to write a template depending on a particular attribute you'd do something like this:

Code:

<xsl:template match="field[@name='CONTENT']">
  ... do something with fields of type 'content'
</xsl:template>

mrame · August 9th, 2011, 07:18 AM

Try the below:

Code:

 
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
    <xsl:output method="html" indent="yes"/>
    <xsl:template match="table">
 <table>
     <xsl:for-each select="tablerow">
         <tr>
   <xsl:apply-templates select="field[@name='CONTENT']"/>
   </tr>
        </xsl:for-each>
 </table>
    </xsl:template>
 
 <xsl:template match="field[@name='CONTENT']">
  <td><font color="BLUE"><xsl:value-of select="value"/></font></td>
 </xsl:template>
 
 
</xsl:stylesheet>

cristina.macias.614 · August 9th, 2011, 07:34 AM

The problem is that I have to process de nodes 'field' in a diferent way depending of the value of an attribute ('name=TYPE') and also depending of the value of this node (if value is 'NORMAL' or 'ERROR').

cristina.macias.614 · August 9th, 2011, 07:43 AM

I have tried the code you has post, but donÂ´t use the node:

Quote:

<field name="TYPE"><value>NORMAL</value></field>

to select de color of the font (Blue if '<field name='TYPE'><value>NORMAL...' and red if '<field name='TYPE'><value>ERROR...').

mrame · August 9th, 2011, 07:50 AM

Try the below:

Code:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
    <xsl:output method="html" indent="yes"/>
    <xsl:template match="table">
 <table>
     <xsl:for-each select="tablerow[field[@name='TYPE']/value[. = 'NORMAL']]">
         <tr>
   <td><font color="BLUE"><xsl:value-of select="field[@name='CONTENT']/value"/></font></td>
   </tr>
        </xsl:for-each>
 
  <xsl:for-each select="tablerow[field[@name='TYPE']/value[. = 'ERROR']]">
         <tr>
   <td><font color="RED"><xsl:value-of select="field[@name='CONTENT']/value"/></font></td>
   </tr>
        </xsl:for-each>
 
 
 </table>
    </xsl:template>
 
 
 
</xsl:stylesheet>

cristina.macias.614 · August 9th, 2011, 08:03 AM

YeaahhhhÂ¡Â¡Â¡Â¡ It worksÂ¡Â¡Â¡Â¡Â¡

I have another solution I was posting at the same time of yours (also works):

Code:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="html" standalone="no"/>



    <xsl:template match="table">

<html><body>

    <table border="1">
      	<xsl:for-each select="tablerow">
       		<tr><td>

			

			<xsl:if test="field[@name='TYPE'] and field='NORMAL'">
				<font color='blue'>
					<xsl:value-of select="field[@name='CONTENT']"/>
				</font>
			</xsl:if>

			<xsl:if test="field[@name='TYPE'] and field='ERROR'">
				<font color='red'>
					<xsl:value-of select="field[@name='CONTENT']"/>
				</font>
			</xsl:if>
			
				


		</td></tr>
 	</xsl:for-each>
    </table>

</body></html>

    </xsl:template>

Thanks a lotÂ¡Â¡