I added this right above the <PackageTransform>
HTML Code:
<query name="AdditionalP" rowElementName="Product" retType="xml">
<sql>
<![CDATA[
SELECT ProductID, CONVERT(xml, ExtensionData) as ExtensionData FROM Product WHERE ProductID in(SELECT ProductID from ProductCategory where CategoryID = @CategoryID) FOR XML AUTO ;
]]>
</sql>
<queryparam paramname="@CategoryID" paramtype="request" requestparamname="CategoryID" sqlDataType="int" defvalue="0" validationpattern="^\d{1,10}$" />
</query>
and
placed this
HTML Code:
<xsl:value-of select="ExtensionData" disable-output-escaping="yes"/>
at required position.
But it is not showing the extension data
can you please confirm if am missing anything.
thanks