You have to create a
XSLT stylesheet and save it in a code page.
They look like this:
<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
version="1.0">
<xsl:key name="LabelToField" match="/qdbif/table/fields/field/@id" use="../label"/>
<xsl:template match="/">
<xsl:apply-templates select="qdbif"/>
</xsl:template>
<xsl:template match="qdbif">
<xsl:apply-templates select="table"/>
</xsl:template>
<xsl:template match="table">
<xsl:apply-templates select="records"/>
</xsl:template>
<xsl:template match="records">
<table border="1">
<tr>
<th>Field1 Heading</th>
<th>Field2 Heading</th>
<th>Field3 Heading</th>
</tr>
<xsl:apply-templates select="record"/>
</table>
</xsl:template>
<xsl:template match="record">
<tr>
<td>
<xsl:value-of select="f[@id=key('LabelToField','Field1')]"/>
</td>
<td>
<xsl:value-of select="f[@id=key('LabelToField','Field2')]"/>
</td>
<td>
<xsl:value-of select="f[@id=key('LabelToField','Field3')]"/>
</td>
</tr>
</xsl:template>
</xsl:stylesheet>
Then you can associate the
XSLT stylesheet with
(1) a native query or
(2) use the
xsl parameter with
API_DoQuery.
However, I doubt there are many people that even know how to do this any more and the feature is rarely used or asked about.
