RE: how to write such xquery?

Your example creates a copy of the input in which all elements except <d
dno="d001"> have been copied. I can't see how this relates to the problem as
you have described it.

 

However, the general answer is that to do this kind of transformation you
need to use the same kind of technique as you would use in XSLT, that is a
recursive tree walk, but using functions rather than template rules. As you
process each level of the tree, you create a new element node with the same
name as the input node, and then apply the function recursively to those
children that you want to copy, excluding those you want to discard.

 

Michael Kay

 

  _____  

From: [email protected] [mailto:[email protected]] On Behalf Of Chen
Yabing
Sent: 05 March 2004 12:29
To: [email protected]
Subject: how to write such xquery?

 

Suppose I have a document as follows:

 

<a ano="a001">

   <b bno="b001">

       <c cno="c001"/>

       <d dno="d001"/>

       <d dno="d002"/>

   </b>

   <b bno="b002">

       <c cno="c002"/>

       <d dno="d002"/>

   </b>

</a>

 

I would like to write a query to retrieve those elements from top to down
that has sub element <d> whose dno = "d002". That is, I want the result like
this:

 

<a ano="a001">

   <b bno="b001">

       <c cno="c001"/>

       <d dno="d002"/>

   </b>

   <b bno="b002">

       <c cno="c002"/>

       <d dno="d002"/>

   </b>

</a>

 

How to write such a query in a simple XQuery? Can I use filter function?

Thanks in advance.