Hi:
I’m new to XQuery. I have a document like the following

John Doe
7031234567
8041234567
9051234567

Mary Ann
2021234567
9011234567
8051234567


I want to get the home phone, the query I used like the following :

for $a in input()/person
let $b :=$a/phone
where $b/@type=“home”
return $b

Obviously this doesn’t work as it gives back all phone no matter which type. Please help.

Hi,

The reason for the unexpected result is that by using a ?let? clause you bind all phones of a person to variable $b. In the ?where? clause you just check if there is a ?home? phone bound to $b. If this is the case you return all phones of a person by returning $b.
To get the only the ?home? phones you have to replace the ?let? by a ?for? clause in the following way:

for $a in input()/person
for $b in $a/phone
where $b/@type=“home”
return $b

A shorter variant of this query is the following:

for $b in input()/person/phone
where $b/@type=“home”
return $b

The shortest variant just consists of a single path expression:

input()/person/phone[@type=“home”]

Best regards,

Thorsten Fiebig