Xpath Query

[cobus.lombard]

Hi All

Couldn't find an xpath specifig UG, so I'm posting this here.

I have XML in the following structure:

<Assignments>
<Assignment>
<ID>123</ID>
<Description>Te st Assignment 1</Description>
<DueDate>2006/10/10</DueDate>
<Tasks>
<Task>
<ID>1</ID>
<Description>Ta sk 1</Description>
</Task>
<Task>
<ID>2</ID>
<Description>Ta sk 2</Description>
</Task>
<Task>
<ID>3</ID>
<Description>Ta sk 3</Description>
</Task>
</Tasks>
</Assignment>
<Assignment>
<ID>456</ID>
<Description>Te st Assignment 2</Description>
<DueDate>2006/10/12</DueDate>
<Tasks>
<Task>
<ID>4</ID>
<Description>Ta sk 4</Description>
</Task>
<Task>
<ID>5</ID>
<Description>Ta sk 5</Description>
</Task>
<Task>
<ID>6</ID>
<Description>Ta sk 6</Description>
</Task>
</Tasks>
</Assignment>
<Assignment>
<ID>789</ID>
<Description>Te st Assignment 3</Description>
<DueDate>2006/10/15</DueDate>
</Assignment>
</Assignments>

As you can see, not all Assignment Nodes have a Tasks node. I require
an XPATH query that will return all Assignments that have Tasks, but
the result should only contain the Assignment's ID and the Tasks node.
For example, the above XML should be returned as:

<Assignment>
<ID>123</ID>
<Tasks>
<Task>
<ID>1</ID>
<Description>Ta sk 1</Description>
</Task>
<Task>
<ID>2</ID>
<Description>Ta sk 2</Description>
</Task>
<Task>
<ID>3</ID>
<Description>Ta sk 3</Description>
</Task>
</Tasks>
</Assignment>
<Assignment>
<ID>456</ID>
<Tasks>
<Task>
<ID>4</ID>
<Description>Ta sk 4</Description>
</Task>
<Task>
<ID>5</ID>
<Description>Ta sk 5</Description>
</Task>
<Task>
<ID>6</ID>
<Description>Ta sk 6</Description>
</Task>
</Tasks>
</Assignment>

Thanks.

[John Saunders]

<co***********@ gmail.comwrote in message
news:11******** **************@ i42g2000cwa.goo glegroups.com.. .

Hi All

Couldn't find an xpath specifig UG, so I'm posting this here.

I have XML in the following structure:

....

As you can see, not all Assignment Nodes have a Tasks node. I require
an XPATH query that will return all Assignments that have Tasks, but
the result should only contain the Assignment's ID and the Tasks node.
For example, the above XML should be returned as:

<Assignment>
<ID>123</ID>
<Tasks>
<Task>
<ID>1</ID>
<Description>Ta sk 1</Description>
</Task>
<Task>
<ID>2</ID>
<Description>Ta sk 2</Description>
</Task>
<Task>
<ID>3</ID>
<Description>Ta sk 3</Description>
</Task>
</Tasks>
</Assignment>

I think that it isn't an XPath query you need, but rather an XSL
transformation. This transformation would be driven by an XPath expression
like //Assignment[Tasks].

John

[cobus.lombard]

John Saunders wrote:

>
I think that it isn't an XPath query you need, but rather an XSL
transformation. This transformation would be driven by an XPath expression
like //Assignment[Tasks].

John

Hi John, thanks for the reply.

I really was hoping to do this with one XPath expression.
//Assignment[Tasks] is halfway there as it only returns Assignments
that contain Tasks, but it also brings back the entire Assignment Node,
and I only want the ID and the Tasks Node.

Any ideas?

[Martin Honnen]

co***********@g mail.com wrote:

I really was hoping to do this with one XPath expression.
//Assignment[Tasks] is halfway there as it only returns Assignments
that contain Tasks, but it also brings back the entire Assignment Node,
and I only want the ID and the Tasks Node.

XPath does not change the structure of the of the original document, you
need a stylesheet to do that.
What you can do with XPath is select the Assignment elements you are
looking for with one expression, then use relative XPath expressions to
select the child nodes you are looking for.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/