robots for exide using FLWOR

Question

-R (CARGAS PEQUEÑAS-MEDIANAS)

--RS080N

--RS003N

--RS010L

-CX (GRANDES CARGAS)

--CX110L

--CX210L

I need this result (an ul inside an ul) using this xml

<robots>
    <serie>
        <codigo>R</codigo>
        <descripcion>CARGAS PEQUEÑAS-MEDIANAS</descripcion>
    </serie>
    <serie>
        <codigo>CX</codigo>
        <descripcion>GRANDES CARGAS</descripcion>
    </serie>
    <robot>
        <codigo serie="R">RS003N</codigo>
    </robot>
    <robot>
        <codigo serie="R">RS010L</codigo>
    </robot>
    <robot>
        <codigo serie="R">RS080N</codigo>
    </robot>
    <robot>
        <codigo serie="CX">CX110L</codigo>
    </robot>
    <robot>
        <codigo serie="CX">CX210L</codigo>
    </robot>
</robots>

I tried this

       <section>
            {for $i in doc("/db/exam/robots.xml")/robots/serie
                return 
            <ul>
                <li> <h3>Serie: {$i/codigo/text()} ({$i/descripcion/text()})</h3> </li>
                <li>
                    <ul>
                        {for $h in $i/../robot
                        return <li> <h3>{$h/codigo/text()}</h3> </li>}
                    </ul>
                </li>
            </ul>
            }
       </section>

But it doesn't work. Any ideas?

Lordpascal · Accepted Answer · 2020-05-16T16:13:14.850

0

<li>
  <ul>
    {for $h in $i/../robot
    where $h/codigo/@serie=$i/codigo
    return <li> <h3>{$h/codigo/text()}</h3> </li>}
 </ul>
</li>

edited May 16 '20 at 16:13

answered May 15 '20 at 10:21

Lordpascal

51
1
6

score 0 · Answer 2 · answered May 15 '20 at 15:09

Try it this way and see if it works:

let $doc :=  """your xml above"""

for $i in $doc
let $codigo := $i//serie/codigo/text()
for $co in $codigo
return 
            <ul>
                <li> <h3>Serie: {$co} ({$co/../following-sibling::descripcion/text()})</h3> </li>
                <li>
                    <ul>
                        {for $h in $i/robot/codigo[@serie=$co]
                        return <li> <h3>{$h}</h3> </li>}
                    </ul>
                </li>
            </ul>

score 0 · Answer 3 · answered May 15 '20 at 15:19

It can be helpful to take a step back and think about this task conceptually.

From an abstract perspective, what you need to do is

split robots from series
group robots by serie
for each group, lookup the corresponding serie (=join)

Once you have done this, obtaining the final output comes down to two simple nested FLWOR expressions.

I hope this helps!

robots for exide using FLWOR

3 Answers3