How is correctly path to use children like reference

Question

I have problem with my path to XML-elements. In XML document I have:

 <team id="6">
        <refer>
            <team IDREF="7"/>
            <team IDREF="8"/>
        </refer>
    </team>
    <team id="7">
        <refer>
            <team IDREF="6"/>
            <team IDREF="8"/>
        </refer>
    </team>
    <team id="8">
        <refer>
            <team IDREF="6"/>
            <team IDREF="7"/>
        </refer>
    </team>

And I want action -> click refer for team with id=6, and print refers children (two elements -> 7 and 8). I tried this path:

for $z in $path/team[@id = $path/team[@id=$id]/refer/team/@idref]

Where $id is variable id from chosed team (in eg. $id=6), but it doesn't work. I have empty return from this path. Thanks for every help!

EDIT: I have described it badly. I wanted return whole elements <team id="7">...</team> id and <team id="8">...</team> I tried this ($path is doc("input.xml")/root):

for $z in $path/team[@id = $path/team[@id=$id]/refer/team/@idref]

What is badly in this path?

EDIT2: XML document has only this:

<root>
 <team id="1">
   <ele1/>
   <ele2/>
   <refer>
     <team idref="2"/>
     <team idref="3"/>
   </refer>
  </team>
 <team id="2">
   <ele1/>
   <ele2/>
   <refer>
     <team idref="3"/>
   </refer>
  </team>
 <team id="3">
   <ele1/>
   <ele2/>
   <refer>
     <team idref="1"/>
   </refer>
  </team>
</root>

And it should return me whole

<team id="1">
       <ele1/>
       <ele2/>
       <refer>
         <team idref="2"/>
         <team idref="3"/>
       </refer>
      </team>

with childrens elements when $id=3.

Do you said about "for $z in $path/team[$id = $path/team[@id=$id]/refer/team/@idref]" or "for $z in $path/team[@id = $path/team[@id='$id']/refer/team/@idref]" or "for $z in $path/team['$id' = $path/team[@id='$id']/refer/team/@idref]" ? no one work — damlit, May 18 '19 at 21:07
How does a minimal but complete XML input document to demonstrate the problem look? Surely those `team` elements have some parent or even some ancestor element(s) so to allow anyone to correct your path we need to see the complete structure. — Martin Honnen, May 19 '19 at 09:12
Ok I edited my question. I just cant take elements with using the idref or bad path for them. — damlit, May 19 '19 at 09:30

zx485 · Answer 1 · 2019-05-19T16:27:08.703

0

Edited answer: You can achieve the desired outcome with the following XQuery

let $file := doc("input.xml")/root,
    $id   := "1" return
for $z in $file/team[@id = $id] return $z

which returns the team element with the $id=1.

edited May 19 '19 at 16:27

answered May 18 '19 at 22:25

zx485

28,498
28
50
59

I have described it badly. I wanted return all elements ... and ... – damlit May 19 '19 at 03:20

score 0 · Accepted Answer · answered May 19 '19 at 11:26

I can't reproduce your problem, for the second sample you posted with the query being

declare variable $id external := 3;

/root/team[@id = /root/team[@id=$id]/refer/team/@idref]

in https://xqueryfiddle.liberty-development.net/gWcDMeu, where I simply declared the variable id properly and replaced the use of $path in $path/team[@id = $path/team[@id=$id]/refer/team/@idref] with /root to allow the use with in that tool without loading an external resource the selected result is

<team id="1">
   <ele1/>
   <ele2/>
   <refer>
     <team idref="2"/>
     <team idref="3"/>
   </refer>
  </team>

So it seems at least one of your posted samples should work with one of the paths you have shown. If you still have problems then you might want to edit and show a single, minimal and complete XML sample together with a minimal and complete XPath or XQuery that allows us to reproduce the problem.

I had in my xml "IDREF", not "idref" how I said... Sorry and thanks — damlit, May 19 '19 at 14:23

How is correctly path to use children like reference

2 Answers2