XPATH Multiple Element Filters

Question

I have the following sample XML structure:

<SavingAccounts>
    <SavingAccount>
       <ServiceOnline>yes</ServiceOnline>
       <ServiceViaPhone>no</ServiceViaPhone>
    </SavingAccount>
    <SavingAccount>
       <ServiceOnline>no</ServiceOnline>
       <ServiceViaPhone>yes</ServiceViaPhone>
    </SavingAccount>
</SavingAccounts>

What I need to do is filter the 'SavingAccount' nodes using XPATH where the value of 'ServiceOnline' is 'yes' or the value of 'ServiceViaPhone' is yes.

The XPATH should return me two rows!! I can filter 'SavingAccount' nodes where both of the element values are yes like the following XPATH sample, but what I want to do is an or element value comparison???

/SavingAccounts/SavingAccount/ServiceOnline[text()='yes']/../ServiceViaPhone[text()='yes']/..

Dimitre Novatchev · Accepted Answer · 2014-05-08T14:06:54.030

This is a very fundamental XPath feature: composing a number of conditions with the logical operators and, or, and the function not().

and has a higher priority than or and both operators have lower priority than the relational and equality operators (=, !=, >, >=, < and <=).

So, it is safe to write: A = B and C = D

Some most frequent mistakes made:

People write AND and/or OR. Remember, XPath is case-sensitive.
People use the | (union) operator instead of or

Lastly, here is my solution:

/SavingAccounts/SavingAccount
           [ServiceOnLine='yes' or ServiceViaPhone='yes']

score 10 · Answer 2 · answered Jan 23 '09 at 14:07

10

/SavingAccounts/SavingAccount[(ServiceOnLine='yes') or (ServiceViaPhone='yes')]

answered Jan 23 '09 at 14:07

AnthonyWJones

187,081
35
232
306

1

Good, but the brackets are not needed :) – Dimitre Novatchev Jan 23 '09 at 14:30
1

@DimitreNovatchev, you mean, the parens? – Jon L. Mar 07 '14 at 20:41
@JonL. Yes, aren't "brackets" and "parentheses" synonyms? – Dimitre Novatchev Mar 07 '14 at 21:27
3

@DimitreNovatchev, when you're having to differentiate between ( and [, then using the term bracket to refer to both would be misleading/confusing. – Jon L. Mar 07 '14 at 22:17
@JonL., I am using explicitly the term "square brackets", so there cannot be any confusion. – Dimitre Novatchev Mar 07 '14 at 22:26
@DimitreNovatchev, specifying square brackets would solve it indeed, although then I wonder why square brackets wouldn't be needed in the above example? (Assuming I understand correctly) – Jon L. Mar 07 '14 at 22:29
1

@JonL., I am actually saying that *normal*, non-square brackets aren't needed. – Dimitre Novatchev Mar 07 '14 at 22:34
3

@DimitreNovatchev, most native English speakers do not consider "brackets" and "parentheses" to be synonyms. I would certainly never call parentheses brackets. Like others, I was confused by your initial comment, especially since "brackets" without a qualifier is usually understood to mean square braces. – Darryl Apr 08 '15 at 14:39
@Darryl, Thanks for the English lesson :) – Dimitre Novatchev Apr 08 '15 at 15:30

falstro · Answer 3 · 2009-01-23T14:13:26.227

4

Will

/SavingAccounts/SavingAccount[ServiceOnline/text()='yes' or ServiceViaPhone/text()='yes']

do the trick?

I have no XPath evaluator handy at the moment.

EDIT:
If I remember correctly, you don't need the text(), so

[ServiceOnline='yes' or ServiceViaPhone='yes']

should be sufficient, and more readable.

EDIT:
Yes, of course, 'or' for predicate expressions, my bad.

edited Jan 23 '09 at 14:13

answered Jan 23 '09 at 14:07

falstro

34,597
9
72
86

1

/SavingAccounts/SavingAccount[ServiceOnline/text()='yes' or ServiceByPhone/text()='yes'] – Jan 23 '09 at 14:11
So the XPATH was correct, except you need "or" instead of "|". But that might be a peculiarity of the .NET XML/XPATH parser. – gilles27 Jan 23 '09 at 14:13

XPATH Multiple Element Filters

3 Answers3

Linked