Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It is a response that assumes that you don't have any mixed content in your data. It only takes into account the two first steps (@name and @col), you can adapt for further steps. Maybe it can be rewritten with a recursive named template that takes the list of your sorting param as input. Could you provide an XML sample if my XSLT don't work for you.</p> <p>XSLT 2.0 sample :</p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0"&gt; &lt;xsl:template match="*"&gt; &lt;xsl:copy&gt; &lt;xsl:copy-of select="@*"/&gt; &lt;xsl:for-each-group select="*" group-by="if (exists(@name)) then @name else ''"&gt; &lt;xsl:sort select="current-grouping-key()" data-type="text"/&gt; &lt;xsl:for-each-group select="current-group()" group-by="if (exists(@row)) then @row else -1"&gt; &lt;xsl:sort select="current-grouping-key()" data-type="number"/&gt; &lt;xsl:apply-templates select="current-group()"/&gt; &lt;/xsl:for-each-group&gt; &lt;/xsl:for-each-group&gt; &lt;/xsl:copy&gt; &lt;/xsl:template&gt; &lt;/xsl:stylesheet&gt; </code></pre> <p>Note that the code iterates on a group with same values, so that if an attribute is not present on elements, the elements are grouped together.</p> <p>I take as Input the following XML :</p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;items&gt; &lt;item row="5" col="9"&gt;&lt;/item&gt; &lt;item name="d" row="20" col="12" tabindex="" sequence=""&gt;&lt;/item&gt; &lt;item row="1" col="5" &gt;&lt;/item&gt; &lt;item name="d" row="5" col="6" &gt;&lt;/item&gt; &lt;item name="a" row="7" col="8" &gt;&lt;/item&gt; &lt;item name="s" row="1" col="5" &gt;&lt;/item&gt; &lt;item name="c" row="5" col="9"&gt;&lt;/item&gt; &lt;item row="2" col="5" &gt;&lt;/item&gt; &lt;item row="20" col="9"&gt;&lt;/item&gt; &lt;item row="0" col="9"&gt;&lt;/item&gt; &lt;item name="s" row="2" col="10" tabindex="" sequence=""&gt;&lt;/item&gt; &lt;item name="z" row="8" col="15" tabindex="" sequence=""&gt;&lt;/item&gt; &lt;/items&gt; </code></pre> <p>I have the following result :</p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;items&gt; &lt;item row="0" col="9"/&gt; &lt;item row="1" col="5"/&gt; &lt;item row="2" col="5"/&gt; &lt;item row="5" col="9"/&gt; &lt;item row="20" col="9"/&gt; &lt;item name="a" row="7" col="8"/&gt; &lt;item name="c" row="5" col="9"/&gt; &lt;item name="d" row="5" col="6"/&gt; &lt;item name="d" row="20" col="12" tabindex="" sequence=""/&gt; &lt;item name="s" row="1" col="5"/&gt; &lt;item name="s" row="2" col="10" tabindex="" sequence=""/&gt; &lt;item name="z" row="8" col="15" tabindex="" sequence=""/&gt; &lt;/items&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POXSLT to sort on value of multiple attributes
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USVincent Biragnet
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POXSLT to sort on value of multiple attributes
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThe output you mention looks exactly the way I want it! Unfortunately, I don't get your sample output when I run your sample input through your sample XSLT. [I get this.](http://pastebin.com/Mxq3wKeC) Looks like I need to troubleshoot on my side first!
      singulars
      1. PO
      1. USTorben Gundtofte-Bruun
    2. COFor much clarity in the output, maybe add the following instruction as first child of the stylesheet : <xsl:output indent="yes"/>. You will have the same indented result as above. And try running from command line : java -jar saxon.jar test.xml test.xsl . Let me know about what you got as output.
      singulars
      1. PO
      1. USVincent Biragnet
    3. COAs I see your XML, I was wondering if each different element (parameter, section, cell...) has the same attributes always present ? May be there is only a different kind of sorting for each element name, that is something quite easier than the general task.
      singulars
      1. PO
      1. USVincent Biragnet
 

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