Thread: Category Summary to XML Package

Does anyone know how to add the category summary to the category xml package

In your selected entity xmlpackage, add a new query like this:

C#/VB.NET Code:

<query name="CategorySummary" rowElementName="Category">
        <sql>
            <![CDATA[select Summary from Category where categoryID = @CatID]]>
        </sql>
        <queryparam paramname="@CatID" paramtype="runtime" requestparamname="CatID" sqlDataType="int" defvalue="0"  validationpattern="" />
    </query> 


Then down with all the other xml:param definitions add this:

C#/VB.NET Code:

<xsl:param name="catSummary" select="/root/CategorySummary/Category/Summary" /> 


Then where ever you want to display it use this:

C#/VB.NET Code:

<xsl:value-of select="$catSummary" disable-output-escaping="yes" />