XPath Query using NOT, not working

Question

I'm trying to figure out how to selected all of the Suppliers who do not have TV as a product. I'd also like an explanation on the differences of your answer and what I have. I have the following query written:

SELECT XMLColumn.query('/SuppliersList/Supplier/Product[not(@name="TV")]/..')
FROM Tb_XPathQueryTable

This is my table, plus a bunch of other Suppliers.

<SuppliersList>
  <Supplier name="Joe">
    <City>Paris</City>
    <Product name="Airplane"/>
    <Product name="Milk"/>
    <Product name="TV"/>
    <Product name="Orange"/>
 </Supplier>

kjhughes · Accepted Answer · 2017-12-07 16:57:04Z

2

On your xpath you are selecting first the Product and then going to its parent, so it will match the specified example (because the TV Product has siblings that match the same parent).

This xpath should work:

/SuppliersList/Supplier[not(Product[@name="TV"])]

As you can see, we are selecting Supplier which doesn't contain a Product child with name="TV"

edited Dec 7, 2017 at 16:57

kjhughes

113k31 gold badges198 silver badges276 bronze badges

answered Dec 7, 2017 at 16:51

eLRuLL

18.8k9 gold badges79 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Wisco Gold Over a year ago

It does work, thanks! Also thank you for explaining it.

Collectives™ on Stack Overflow

XPath Query using NOT, not working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related