Grouping with XSLT 1.0

rodmcleay · January 14th, 2008, 11:36 PM

Hi All,
I am trying to arrange grouping using the Muenchian Method described at http://www.jenitennison.com/xslt/gro...muenchian.html

I am new to XSLT and can not seem to find out why my template seems to report all the fields in the XML, plus the grouped fields in the correct format.

How can I get the template to ignor all the records except those in the IncludedProducts node.
Any attempt I have made seems to stop everything working

I wish to do further grouping but would be really happy to get any grouping happening at this stage.

My XSLT is
[code]
<xsl:key name="products-by-account" match="IncludedProduct" use="AccountNumber" />

<xsl:template match="IncludedProducts">
    <xsl:for-each select="IncludedProduct[count(. | key('products-by-account', AccountNumber)[1]) = 1]">
        <xsl:sort select="AccountNumber" />
        <xsl:value-of select="AccountNumber" />,<br />
        <xsl:for-each select="key('products-by-account', AccountNumber)">
            <xsl:sort select="AccountNumber" />
            <xsl:value-of select="ProductName" /> (<xsl:value-of select="VariantName" />)<br />
        </xsl:for-each>
    </xsl:for-each>
</xsl:template>[code]

Teh XML is

Code:

<root>
  <System>
    <IsAdminSite>False</IsAdminSite>
    <IsAdminSiteInt>0</IsAdminSiteInt>
    <CustomerID>58639</CustomerID>
    <DefaultVATSetting>MoreFields than this</DefaultVATSetting>   
  </System>
  <QueryString />
  <Form />
  <Session />
  <Cookies>
    <ac7.aspxanonymous>ygmYIQhzyAEkAAAAM2YwOGQ1MWQtNjY1Mi00M2ZkLTlmNzQtN2Q5ODZiNTYyY2Jj5jiijKDA_jbSKEGPBGXZvND8DwM1</ac7.aspxanonymous>
    <username>[email protected]</username>
    <skinid>1</skinid>
  </Cookies>
  <ServerVariables>
    <HTTP_HOST>Morefields than this.</HTTP_HOST>
   </ServerVariables>
  <Runtime>
    <IPAddress>127.0.0.1</IPAddress>
    <IsAdminSite>False</IsAdminSite>
    <StoreUrl>http://localhost/aspdotnetstorefront70/</StoreUrl>
    <CurrencySetting>MoreFields than this</CurrencySetting>
  </Runtime>  
  <IncludedProducts>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ1</EquipmentNumber>
      <ProductName>Product 5 With Variants</ProductName>
      <VariantName>DVD Version</VariantName>
    </IncludedProduct>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ1</EquipmentNumber>
      <ProductName>Product 5 With Variants</ProductName>
      <VariantName>VHS Version</VariantName>
    </IncludedProduct>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ1</EquipmentNumber>
      <ProductName>Product 8 With Sizes That Change Price</ProductName>
      <VariantName>
      </VariantName>
    </IncludedProduct>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ4</EquipmentNumber>
      <ProductName>Product 5 With Variants</ProductName>
      <VariantName>DVD Version</VariantName>
    </IncludedProduct>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ4</EquipmentNumber>
      <ProductName>Product 5 With Variants</ProductName>
      <VariantName>VHS Version</VariantName>
    </IncludedProduct>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ4</EquipmentNumber>
      <ProductName>Product 8 With Sizes That Change Price</ProductName>
      <VariantName>
      </VariantName>
    </IncludedProduct>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ2</EquipmentNumber>
      <ProductName>Product 5 With Variants</ProductName>
      <VariantName>DVD Version</VariantName>
    </IncludedProduct>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ2</EquipmentNumber>
      <ProductName>Product 5 With Variants</ProductName>
      <VariantName>VHS Version</VariantName>
    </IncludedProduct>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ2</EquipmentNumber>
      <ProductName>Product 8 With Sizes That Change Price</ProductName>
      <VariantName>
      </VariantName>
    </IncludedProduct>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ3</EquipmentNumber>
      <ProductName>Product 5 With Variants</ProductName>
      <VariantName>DVD Version</VariantName>
    </IncludedProduct>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ3</EquipmentNumber>
      <ProductName>Product 5 With Variants</ProductName>
      <VariantName>VHS Version</VariantName>
    </IncludedProduct>
    <IncludedProduct>
      <AccountNumber>Testing2</AccountNumber>
      <EquipmentNumber>EQ3</EquipmentNumber>
      <ProductName>Product 8 With Sizes That Change Price</ProductName>
      <VariantName>
      </VariantName>
    </IncludedProduct>
  </IncludedProducts>
</root>

======================================
"They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad."
--Shakespeare
======================================

rodmcleay · January 14th, 2008, 11:42 PM

Typically, just as I post the message, it all becomes clear.

Code:

<xsl:template match="/">
<xsl:apply-templates select="/root/IncludedProducts"/>
</xsl:template>

:D

======================================
"They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad."
--Shakespeare
======================================