开发者

Return multiple data elements

Using Xquery, how can I search the file below (consisting of many items), for all items with 'XC' in the part-number (there are many), then for matches return all 3 of the interesting data elements (part-number, part-name, and name)? The return is the main problem--my attempts result in every permutation of the interesting data elements. Thank you!

   开发者_如何学编程 
<catalog>
   <item>
     <description>
    <partref>
       <part-id>
        <part-number>XC51222</part-number>
       </part-id>
    </partref>
    <part-name>DSP, Network Vectoring<part-name>
    <vendors>
       <vendor1>
        <pay-to>
           <name>JCOF Industries</name>
        </pay-to>
       </vendor1>
    </vendors>
      </description>
   </item>
   <item>
   </item>
[many items…]
</catalog>


xquery version "1.0";

let $sep := ','
for $x in catalog/item
where fn:matches($x/description/partref/part-id/part-number, 'XC')
return fn:string-join( ($x/description/partref/part-id/part-number/text(), $x/description/part-name/text(), $x/description/vendors/vendor1/pay-to/name/text()), $sep)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜