Thread: ExtensionData at Entity Level

Hi How can I display Product ExtensionData at Entity Level

i tried this

HTML Code:

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

which works fine for product level.

but doesn't works for Entity Level.

Can anyone help me with this.

thanks

You can add another query to your category xmlpackage like this :-

C#/VB.NET 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> 


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