Databases
StackOverflow2013
Postsdbo
POxsl grouping by xml element for repetitive nodes in xslt1 into html table output
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POxsl grouping by xml element for repetitive nodes in xslt1 into html table output
    primarykey
    data
    text
    <p>I have a complex xml structure that looks like : </p> <pre><code> &lt;Items&gt; &lt;Item&gt; &lt;ItemTexts&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type1&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description11&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;1&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type1&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description12&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;2&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type2&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description21&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;3&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type2&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description22&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;4&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;/ItemTexts&gt; &lt;/Item&gt; &lt;Item&gt; &lt;ItemTexts&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type1&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description11&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;1&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type1&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description12&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;2&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type2&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description21&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;3&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type2&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description22&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;4&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;/ItemTexts&gt; &lt;/Item&gt; &lt;Item&gt; &lt;ItemTexts&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type1&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description11&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;1&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type1&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description12&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;2&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type2&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description21&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;3&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type2&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description22&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;4&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;/ItemTexts&gt; &lt;/Item&gt; &lt;Item&gt; &lt;ItemTexts&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type3&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description31&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;1&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type3&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description32&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;2&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type2&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description21&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;3&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;ItemText&gt; &lt;ItemTextsType&gt;type2&lt;/ItemTextsType&gt; &lt;ItemTextsTypeDesc&gt;description22&lt;/ItemTextsTypeDesc&gt; &lt;ItemTextsLine&gt;4&lt;/ItemTextsLine&gt; &lt;/ItemText&gt; &lt;/ItemTexts&gt; &lt;/Item&gt; &lt;/Items&gt; </code></pre> <p>Each <code>&lt;Item&gt;</code> has MANY more xml elements , but I won't specify them now.</p> <p>I run with xsl on each Item like :</p> <pre><code>&lt;xsl:for-each select="Items/Item"&gt; </code></pre> <p>and I produce table with rows for each <code>&lt;Item&gt;</code> and many <code>&lt;td&gt;</code> in each row.</p> <p>I need an example of how to group <code>&lt;ItemText&gt;</code> by <code>&lt;ItemTextsType&gt;</code> individually for each <code>&lt;Item&gt;</code> .</p> <p>I will arrange the outcome in a table like :</p> <pre><code> &lt;table&gt; &lt;%--tr for each Item in Items--%&gt; &lt;tr&gt; &lt;td&gt; some value from xml element according &lt;b&gt; Item1 &lt;/b&gt; &lt;/td&gt; &lt;td&gt; some more value from xml element according &lt;b&gt; Item1 &lt;/b&gt; &lt;/td&gt; &lt;%-- . . . --%&gt; &lt;td&gt; &lt;table width="100%" dir="ltr"&gt; &lt;tbody&gt; &lt;tr style="background-color: #507CD1; text-align: center"&gt; &lt;td colspan="3" style="font: bold; color: white"&gt; Item1 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td style="height: 35px; font: bold; color: #507CD1;"&gt; type1 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; description11 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; description12 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td style="height: 35px; font: bold; color: #507CD1;"&gt; type2 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; description21 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; description22 &lt;/td&gt; &lt;/tr&gt; &lt;/tbody&gt; &lt;/table&gt; &lt;/td&gt; &lt;td&gt; even more value from xml element according &lt;b&gt; Item1 &lt;/b&gt; &lt;/td&gt; &lt;%-- . . . --%&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; some value from xml element according &lt;b&gt; Item2 &lt;/b&gt; &lt;/td&gt; &lt;td&gt; some more value from xml element according &lt;b&gt; Item2 &lt;/b&gt; &lt;/td&gt; &lt;%-- . . . --%&gt; &lt;td&gt; &lt;table width="100%" dir="ltr"&gt; &lt;tbody&gt; &lt;tr style="background-color: #507CD1; text-align: center"&gt; &lt;td colspan="3" style="font: bold; color: white"&gt; Item2 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td style="height: 35px; font: bold; color: #507CD1;"&gt; type1 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; description11 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; description12 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td style="height: 35px; font: bold; color: #507CD1;"&gt; type2 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; description21 &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; description22 &lt;/td&gt; &lt;/tr&gt; &lt;/tbody&gt; &lt;/table&gt; &lt;/td&gt; &lt;td&gt; even more value from according &lt;b&gt; Item2 &lt;/b&gt; &lt;/td&gt; &lt;%-- . . . --%&gt; &lt;/tr&gt; &lt;%-- and so on--%&gt; &lt;/table&gt; </code></pre> <p>The point is that there is separate grouping for each <code>&lt;Item&gt;</code> into it's own <code>&lt;tr&gt;&lt;td&gt;&lt;table&gt;</code> and inside that <code>&lt;table&gt;</code> there is groupping by <code>&lt;ItemTextsType&gt;</code></p> <p>I have tried something like </p> <pre><code>&lt;xsl:key name="item-texts-type" match="ItemText" use="ItemTextsType" /&gt; &lt;xsl:for-each select="ItemTexts/ItemText[count(. | key('item-texts-type', ItemTextsType)[1]) = 1]"&gt; &lt;xsl:sort select="ItemTextsType" /&gt; &lt;tr&gt; &lt;td style ="height:35px;font: bold; color:#507CD1;"&gt; &lt;xsl:value-of select="ItemTextsType" /&gt; &lt;/td&gt; &lt;/tr&gt; &lt;xsl:for-each select="key('item-texts-type', ItemTextsType)"&gt; &lt;tr&gt; &lt;td&gt; &lt;xsl:value-of select="ItemTextsTypeDesc" /&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/xsl:for-each&gt; &lt;/xsl:for-each&gt; </code></pre> <p>but it only work on <strong>non</strong> repetitive nodes (if there were only one <code>&lt;Item&gt;</code>it would work fine). <strong>I can't change xml because it comes from customer .</strong></p> <p>Please help me , I need it ASAP .</p> <p>Thank you !!!! </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USPolina F.
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POxsl grouping by xml element for repetitive nodes in xslt1 into html table output
      1. USPolina F.
      1. VTFavorite
    1. COWhat's the difference between this and your [previous seemingly identical question](http://stackoverflow.com/questions/13374401/xsl-grouping-of-repetitive-nodes-by-xml-element-in-xslt1)? I didn't notice that one until I'd answered this, and I seem to have independently come up with the same solution as the previous accepted answer.
      singulars
      1. POxsl grouping by xml element for repetitive nodes in xslt1 into html table output
      1. USIan Roberts
    2. COInitially I gave example of needed output and ABach kindly answered it .But then I realized that my needed output is different from what I wrote before , so I changed it.Then I decided to open another question , so maybe the previous question will help somebody . I was hoping to return the old question to state before I edited it,but I couldn't so far - I'm a newbie in Stackoverflow...
      singulars
      1. POxsl grouping by xml element for repetitive nodes in xslt1 into html table output
      1. USPolina F.
    3. COIf you go to the edit history for the original question you should see a "rollback" option against each revision number that you can use to roll the question back to that revision.
      singulars
      1. POxsl grouping by xml element for repetitive nodes in xslt1 into html table output
      1. USIan Roberts
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload