convert path query to xquery

NinaOracle

Hello

I need to convert this path regions/africa/item[[[NOT[/location="United States"]] AND /quantity="1" AND /payment="Creditcard"] OR shipping="Will ship only within country"]

to xquery, where the data stored in standard.xml

Thank you

tsuji

I need to convert this path regions/africa/item[[[NOT[/location="United States"]] AND /quantity="1" AND /payment="Creditcard"] OR shipping="Will ship only within country"]
to xquery, where the data stored in standard.xml

You need to convert, whatever it means, the xpath, all right. But, to begin with, does it really work? Those /location, /quantity and /payment are absolute (and not relative) xpath. Do you really mean that?

NinaOracle

I found the solution if someone is interested

<result>
{
for $i in doc("standard.xml")//item
where not(($i/location="United States" and $i/quantity="1" and $i/payment="Creditcard") or $i/shipping="Will ship only within country")
return count($i)
}
</result>

Thanks all