xpath - 抛出错误 : XDMP-UNEXPECTED: (err:XPST0003) Unexpected token syntax error, unexpected For, expecting Order or Return or Stable

Question

一旦在 qconsole Marklogic 中运行以下代码，我就会遇到以下错误

XDMP-UNEXPECTED: (err:XPST0003) Unexpected token syntax error, unexpected For_, expecting Order_ or Return_ or Stable_

let $prices := fn:doc('/training/prices.xml')/prices
let $order := fn:doc('/training/order.xml')/order
where $prices/priceList/prod[@num=$order/item/@num]
for $kk in $prices/priceList/prod[@num=$order/item/@num]
return 
<item>
{$kk}
</item>

谢谢..

Answer 1

为此不需要 XQuery 3。只需在 where 和下一个 for 之间添加一个额外的 return:

let $prices := fn:doc('/training/prices.xml')/prices
let $order := fn:doc('/training/order.xml')/order
where $prices/priceList/prod[@num=$order/item/@num]
return
for $kk in $prices/priceList/prod[@num=$order/item/@num]
return 
<item>
{$kk}
</item>

为了遵循 Michael 的出色建议，并优化以返回完整的项目，我将翻转 XPath，并直接返回订单项目。像这样的东西:

let $prices := fn:doc('/training/prices.xml')/prices
let $order := fn:doc('/training/order.xml')/order
for $item in $order/item
where $prices/priceList/prod[@num = $item/@num]
return
    $item

或者更短:

let $prices := fn:doc('/training/prices.xml')/prices
let $order := fn:doc('/training/order.xml')/order
return
    $order/item[@num = $prices/priceList/prod/@num]

喂!