Databases
StackOverflow2013
Postsdbo
POInline xslt namespace from parent nodes
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInline xslt namespace from parent nodes
    primarykey
    data
    text
    <p>This is actually my inline xslt:</p> <pre><code>&lt;xsl:element name="ns0:LineItems" &gt; &lt;xsl:element name="ns0:Response" &gt; &lt;xsl:for-each select="//*[local-name()='Response']//*[local-name()='ITEMS']" &gt; &lt;xsl:element name="ns0:ITEMS" &gt; &lt;xsl:attribute name ="LINEITEMID" &gt; &lt;xsl:value-of select="*[local-name()='LINEITEMID']" /&gt; &lt;/xsl:attribute&gt; &lt;xsl:attribute name ="ITM_NUMBER" &gt; &lt;xsl:value-of select="*[local-name()='ITM_NUMBER']" /&gt; &lt;/xsl:attribute&gt; &lt;/xsl:element&gt; &lt;/xsl:for-each&gt; &lt;/xsl:element&gt; &lt;/xsl:element&gt; </code></pre> <p>My question is, how can i create the new nodes with the same namespace from the result xml <code>ns0:elmentname</code>. When this namespace change to <code>ns1:elmentname</code>, I have a problem.</p> <p>The result should look like this:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;ns0:LineItems xmlns:ns0="http://schemas.microsoft.com/BizTalk/2003"&gt; &lt;ns0:Response&gt; &lt;ns0:ITEMS LINEITEMID="777" ITM_NUMBER="001000" /&gt; &lt;ns0:ITEMS LINEITEMID="2" ITM_NUMBER="001055" /&gt; &lt;ns0:ITEMS LINEITEMID="3" ITM_NUMBER="001020" /&gt; &lt;/ns0:Response&gt; &lt;/ns0:LineItems&gt; </code></pre> <p>My Input:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;Response&gt; &lt;HEADER&gt; &lt;ORDER_ID&gt;1234&lt;/ORDER_ID&gt; &lt;/HEADER&gt; &lt;E_SALESDOCUMENT&gt;test123&lt;/E_SALESDOCUMENT&gt; &lt;E_STATUS&gt;AllesToll&lt;/E_STATUS&gt; &lt;ITEMS&gt; &lt;LINEITEMID&gt;777&lt;/LINEITEMID&gt; &lt;ITM_NUMBER&gt;001000&lt;/ITM_NUMBER&gt; &lt;MATERIAL&gt;000000000000219701&lt;/MATERIAL&gt; &lt;/ET_ORDER_ITEMS&gt; &lt;ET_ORDER_ITEMS&gt; &lt;LINEITEMID&gt;2&lt;/LINEITEMID&gt; &lt;ITM_NUMBER&gt;001055&lt;/ITM_NUMBER&gt; &lt;MATERIAL&gt;000000000000219702&lt;/MATERIAL&gt; &lt;/ET_ORDER_ITEMS&gt; &lt;ET_ORDER_ITEMS&gt; &lt;LINEITEMID&gt;3&lt;/LINEITEMID&gt; &lt;ITM_NUMBER&gt;001020&lt;/ITM_NUMBER&gt; &lt;MATERIAL&gt;000000000000219703&lt;/MATERIAL&gt; &lt;/ITEMS&gt; &lt;/Response&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSebastian
    1. USSebastian
    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
    1. VO
      singulars
      1. POInline xslt namespace from parent nodes
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou question is not clear to me. "how can i create the new nodes with the same namespace from the result xml" which _same_ namespace?
      singulars
      1. POInline xslt namespace from parent nodes
      1. USEmiliano Poggi
    2. COAnd how the input looks like?
      singulars
      1. POInline xslt namespace from parent nodes
      1. USEmiliano Poggi
    3. CO@empo: I am using the xslt, in an inline scripting Functoid. The xml is of the hard-wired mapping and inline-xslt filled. The hard-wired mappings generate an xml like this: `<ns0:Request xmlns:ns0="http://schemas.microsoft.com/BizTalk/2003"> <HEADER> <ID>7004</ID> <bla>data</bla> </HEADER>`. The `ns0:` could change to `ns1:`. Because of that i need a dynamic inline xslt namespace prefix.
      singulars
      1. POInline xslt namespace from parent nodes
      1. USSebastian
 

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