Avoiding xml permutations with Xquery when using multiple nodes to retrieve data

Question

I was wondering if someone could help me. My problem is that i'm currently using BaseX which has an XQuery editor. The problem that has come to my hand is that I have a large set of XMLs and I want to reduce them. Nevertheless, some of the information is on different nodes, and when I try to retrieve them they get permutated.

The code that I used to retrieve the data was:

    declare namespace tfd="http://www.sat.gob.mx/TimbreFiscalDigital";
    declare namespace cfdi= "http://www.sat.gob.mx/cfd/3";
    declare context item := document {  
    
     
     
     
     
  
    
    
    
     
     
     
     
     
      
     
    
    
    
  
  
  
}
    declare context item := document {

     



    

        

        

        

    

    

        

    

    

        

    

    

        

            

        

      

    

  



 



}
    for $z in //tfd:TimbreFiscalDigital,
    $x in //cfdi:Conceptos/cfdi:Concepto[(@cantidad>0 and      @importe > 0)],
    $y in c//cfdi:ExpedidoEn
    return 
      
        {$x/@descripcion}
        {$x/@cantidad}
        {$x/@valorUnitario}
        {$y/@codigoPostal}
        {$z/@UUID}
        {$z/@FechaTimbrado}

Now what I expected was for it to return two sets per XML in the pack I have, so I would have 2k of here. Nevertheless I received like 200k sets cause it mixes every $z with every $x and every $y in each possible way. I want it to respect each XML, if it takes data from an XML, all the other data must be from the same XML.

I hope I made myself clear enough, thank you for your help.

Antonio L&#243;pez Ruiz · Accepted Answer

I found my own answer, for anybody interested in how to do it, I will post the code:

for $x in //cfdi:Comprobante,
    $y in $x//cfdi:Conceptos/cfdi:Concepto,
    $z in $x//cfdi:Complemento/tfd:TimbreFiscalDigital,
    $w in $x//cfdi:ExpedidoEn
return 
  
    {$y/@descripcion}
    {$y/@cantidad}
    {$y/@valorUnitario}
    {$z/@FechaTimbrado}
    {$w/@codigoPostal}
    {$z/@UUID}

Thus, instead of having $w, $y and $z all searching from the root of the document (ie. //cfdi:ExpedidoEn), they're searching from their parent ($x//cfdi:ExpedidoEn).

Avoiding xml permutations with Xquery when using multiple nodes to retrieve data

Answers (1)

Related Questions