XQuery Match Configuration or Groovy Script

Hi,

You could certainly do this with a Script Assertion, but in terms of XQuery is what you're looking for something like this:

1) You have something like:

<diffgr:diffgram xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <NewDataSet xmlns="">
    <Status diffgr:id="Status12" msdata&colon;rowOrder="11">
    <id>28</id>
    <name>Review1</name>
    <categoryId>3</categoryId>
    <assignrule>P</assignrule>
    <ismoveAssign>0</ismoveAssign>
    <isActive>1</isActive>
    </Status>
<Status diffgr:id="Status12" msdata&colon;rowOrder="11">
    <id>28</id>
    <name>Review2</name>
    <categoryId>3</categoryId>
    <assignrule>P</assignrule>
    <ismoveAssign>0</ismoveAssign>
    <isActive>1</isActive>
    </Status>
<Status diffgr:id="Status12" msdata&colon;rowOrder="11">
    <id>28</id>
    <name>Review3</name>
    <categoryId>3</categoryId>
    <assignrule>P</assignrule>
    <ismoveAssign>0</ismoveAssign>
    <isActive>1</isActive>
    </Status>
    </NewDataSet>
</diffgr:diffgram>

2) You apply XQuery:

<Result>
{
    for $x in //Status

    return <name> string {data($x/name/text())} </name>
}
</Result>

3) And get:

<?xml version="1.0" encoding="UTF-8"?>
<Result>
   <name> string Review1</name>
   <name> string Review2</name>
   <name> string Review3</name>
</Result>

?

Let me know,

Cheers,

Rupert