Databases
StackOverflow2013
Postsdbo
POXSLT 2.0: Transforming an element including all ancestors without using a foreach
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POXSLT 2.0: Transforming an element including all ancestors without using a foreach
    primarykey
    data
    text
    <p>I'm currently trying to transform an XML file to several output XML files by taking certain element of it and traversing up the ancestors of the chosen elements.</p> <p>For example:</p> <p>Source XML:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;root&gt; &lt;level_a&gt; &lt;level_b&gt; &lt;level_c&gt; &lt;level_d&gt; &lt;level_e/&gt; &lt;/level_d&gt; &lt;/level_c&gt; &lt;/level_b&gt; &lt;level_b&gt; &lt;level_c&gt; &lt;level_d&gt; &lt;level_e/&gt; &lt;/level_d&gt; &lt;/level_c&gt; &lt;/level_b&gt; &lt;level_b&gt; &lt;level_c&gt; &lt;level_d&gt; &lt;level_e/&gt; &lt;level_e/&gt; &lt;level_e/&gt; &lt;/level_d&gt; &lt;/level_c&gt; &lt;/level_b&gt; &lt;level_b&gt; &lt;level_c&gt; &lt;level_d&gt; &lt;level_d&gt; &lt;level_e/&gt; &lt;/level_d&gt; &lt;/level_d&gt; &lt;/level_c&gt; &lt;/level_b&gt; &lt;/level_a&gt; &lt;/root&gt; </code></pre> <p>Output XML files:</p> <p>1:</p> <pre><code> &lt;output&gt; &lt;output level="b"&gt; &lt;output level="c"&gt; &lt;output level="d"&gt; &lt;output level="e"/&gt; &lt;/output&gt; &lt;/output&gt; &lt;/output&gt; &lt;/output&gt; </code></pre> <p>2:</p> <pre><code> &lt;output&gt; &lt;output level="b"&gt; &lt;output level="c"&gt; &lt;output level="d"&gt; &lt;output level="e"/&gt; &lt;/output&gt; &lt;/output&gt; &lt;/output&gt; &lt;/output&gt; </code></pre> <p>3:</p> <pre><code> &lt;output&gt; &lt;output level="b"&gt; &lt;output level="c"&gt; &lt;output level="d"&gt; &lt;output level="e"/&gt; &lt;output level="e"/&gt; &lt;output level="e"/&gt; &lt;/output&gt; &lt;/output&gt; &lt;/output&gt; &lt;/output&gt; </code></pre> <p>4:</p> <pre><code> &lt;output&gt; &lt;output level="b"&gt; &lt;output level="c"&gt; &lt;output level="d"&gt; &lt;output level="d"&gt; &lt;output level="e"/&gt; &lt;/output&gt; &lt;/output&gt; &lt;/output&gt; &lt;/output&gt; &lt;/output&gt; </code></pre> <p>I know I can do something in the line of generating a sequence with following XPath:</p> <p>(//level_d[not(level_d)])[last()]/ancestor::*[self::level_c|self::level_b]</p> <p>and then iterate it with a foreach and I will get my results in the document order.</p> <p>But what I'm really interested in, is how to achieve the same without resorting to the use of a foreach, any solutions I can think of would return all elements reversed...</p> <p>Any hint are greatly appreciated<br/></p> <p>Best Regards<br/> Vlax<br/></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USVlax
    1. USVlax
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POXSLT 2.0: Transforming an element including all ancestors without using a foreach
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCouldn't you just match `/*/*` and create your result document from there?
      singulars
      1. POXSLT 2.0: Transforming an element including all ancestors without using a foreach
      1. USDaniel Haley
    2. COYou may need to elaborate the question (or ask another); it's not at all clear from this question why Daniel Haley's approach doesn't solve your problem. You get points for simplifying away from extraneous details in posing the question, but remember Einstein's advice: as simple as possible, but no simpler!
      singulars
      1. POXSLT 2.0: Transforming an element including all ancestors without using a foreach
      1. USC. M. Sperberg-McQueen
    3. CONow I've changed the example that was really over simplified, the actual version should reflect my real life xml source. Actually the xml doesn't have to have 2 elements at after the root element it can have any number or just one. The only certainty I have is that there are level_d elements and those must be extracted to output xml files with all the ancestors tree up to a certain element (e.g. element_a in my example xml).
      singulars
      1. POXSLT 2.0: Transforming an element including all ancestors without using a foreach
      1. USVlax
 

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