|
|
Re: How to generate XSL file from table data [message #400941 is a reply to message #400894] |
Thu, 30 April 2009 08:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Orna
Messages: 62 Registered: November 2008
|
Member |
|
|
Thank you for looking into this, Frank.
XSL should look like:
<?xml version="1.0" encoding="UTF-8" ?>
- <xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:fn="http://www.w3.org/2005/xpath-functions">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"
/>
- <xsl:template name="DomainLookup">
<xsl:param name="domainId" />
<xsl:param name="domainCode" />
- <xsl:if test="$domainId = 'GNLSTSTS'">
- <xsl:if test="$domainCode = 'N'">
<xsl:text disable-output-escaping="yes">Active</xsl:text>
</xsl:if>
- <xsl:if test="$domainCode = 'P'">
<xsl:text disable-output-escaping="yes">Pending</xsl:text>
</xsl:if>
</xsl:if>
</xsl:template>
</xsl:stylesheet>
The table contains domain data:
DOMAIN_CODE
CODE_VALUE
There is no PK, for the same domain code there will be many CODE_VALUE values.
|
|
|
|