Two conditions using OR in XPATH

Question

I have a textbox, 'txtSearch'. I am using it to search people by Last Name. this is my code.

var xmlTempResultSearch = xmlResidentListDisplay.selectNodes(
    "//PeopleList/Row[contains(translate(@LastName, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz'), '" +
    txtSearch.value + "')]");

This code selects all last names in the XML like the text input in the txtSearch textbox.

This translates all uppercase letters to lowercase letters.

So if I am searching for 'Dorosan', if I type 'doro', it retrieves the correct person because it translated the 'D' to 'd'. But when I type 'Doro', it doesn't retrieve the correct person.

I'm wondering if I can have two conditions in an XPATH, and how? I want to be able to translate all uppercase to lowercase, OR translate all lowercase to uppercase.

score 59 · Answer 1 · answered Sep 24 '12 at 10:08

59

and and or are allowed inside the condition: [here]. Or you may also use multiple paths in one XPath expression using the pipe sign.

//PeopleList/Row[c1] | //PeopleList/Row[c2]

answered Sep 24 '12 at 10:08

Jiri Kremser

12,471
7
45
72

1

for Ms SQL Server using .exist("xpath") - it shows error XQuery [dvEd.EnrichmentData.exist()]: The XQuery syntax 'union' is not supported. – Philipp Munin Jul 13 '16 at 20:02

score 47 · Answer 2 · edited Feb 18 '23 at 22:48

47

you can use or / and inside [....]

Example:

//*[contains('abc') or contains('def') or text()='abcdef']

More info about operators: http://www.w3schools.com/xml/xpath_operators.asp

edited Feb 18 '23 at 22:48

rafailka

73
1
8

answered Sep 24 '12 at 10:04

CosminO

5,018
6
28
50

score 4 · Answer 3 · answered Sep 24 '12 at 11:51

4

I don't think you need an "or" here. You just need to translate both operands to lower-case, rather than only translating one of them.

answered Sep 24 '12 at 11:51

Michael Kay

156,231
11
92
164

score 3 · Answer 4 · answered Sep 24 '12 at 13:14

As noted by Michael Kay, no or is necessary.

Simply use:

PeopleList/Row
  [contains(translate(@LastName, 
                     'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 
                     'abcdefghijklmnopqrstuvwxyz'), '" 
+
           translate(txtSearch.value,
                     'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 
                     'abcdefghijklmnopqrstuvwxyz')'" 

+ "')]");

Two conditions using OR in XPATH

4 Answers4

Linked