Recipe showing how to output TWiki syntax from XSLT

• This is the same Recipe as XmlQueryPluginRecipe3 except that the output table is in TWiki syntax. This allows the TablePlugin to process the output enabling sortable columns etc
• A cavate with this techinique is that if the TWiki tag being output by the XSLT is available via a Plugin then XmlQueryPlugin must be called before that plugin. In practise this means setting XmlQueryPlugin near the start of the plugin list described by the INSTALLEDPLUGINS setting in WebPreferences .

Sample Tables

Annotated Query

%XSLTSTART{id="%WEB%" benchmark="off" debug="off" }% 
 <xsl:stylesheet version="1.0" 
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">

<!-- TWiki style Table header -->
<xsl:text>%TABLE{name="test"}%
| *Title* | *Author* |
</xsl:text>

<!-- Loop Over each Row > 1 in tables which match field at row 1 col 1 type is title-->
 <xsl:apply-templates select="/twiki/web/topic/data/tables/table/row[position()=1]/field[@type='title' and position()=1 and text()='Author']/../../row">
     <!-- Sort by the contents of the second field -->
     <xsl:sort select="field[2]"/>
 </xsl:apply-templates>

<!-- Add a newline at the end -->
<xsl:text>
</xsl:text>
</xsl:template>


<xsl:template match="row">
    <!-- Process each line where at least the first field is of type data -->
    <xsl:if test="./field[1][@type='data']">
       <xsl:text>| </xsl:text>         
       <xsl:value-of select="./field[2]"/>
       <xsl:text> | </xsl:text>
       <xsl:value-of select="./field[1]"/>
       <!-- add a new line at the end -->
       <xsl:text> |
</xsl:text>
    </xsl:if>

  </xsl:template>
  </xsl:stylesheet>
%XSLTEND%

XSLT Demo Transformed Table

The above tables has been transformed in 3 ways

1. They have been combined
2. The Author and Title columns have been swapped
3. The entries have been sorted by Title

%XSLTSTART{id="Plugins" benchmark="off" debug="off" }% <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:apply-templates select="/twiki/web/topic/data/tables/table/row[position()=1]/field[@type='title' and position()=1 and text()='Author']/../../row"> </xsl:apply-templates>

| <xsl:value-of select="./field[2]"/> | <xsl:value-of select="./field[1]"/> |

%XSLTEND%