Hi,

i am doing some assertions for a resultset that is a list that looks like this:

<a:ResultSet xmlns:a="http://schemas.datacontract.org/2004/07/SecondTravel.Global.DataContract.Licence.v1_0" xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://SecondTravel.Global.ServiceContract.Licence.v1_0.ILicence" xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
  <a:LicenceDCResultItem>
    <a:FunctionalityCode>Users</a:FunctionalityCode>
  </a:LicenceDCResultItem>
  <a:LicenceDCResultItem>
    <a:FunctionalityCode>Global_Codes</a:FunctionalityCode>
  </a:LicenceDCResultItem>
  <a:LicenceDCResultItem>
    <a:FunctionalityCode>Global_Subscribe</a:FunctionalityCode>
  </a:LicenceDCResultItem>
</a:ResultSet>

now depending on the GUID in the database the order of the <a:FunctionalityCode> items change.

is there a assertion except "Contains" that validates for the items and doesnt care about the order?

i tried match content and Xpath match bot both are failing when the order changes.

thanks
Christoph

Thanks Ole,

this is working great now. here is the exact result and the according XQuery:

<GetListResponse xmlns="http://SecondTravel.Global.ServiceContract.Licence.v1_0Package.ILicencePackage">
         <GetListResult xmlns:a="http://schemas.datacontract.org/2004/07/SecondTravel.Global.DataContract.Licence.v1_0" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
            <ResultCode xmlns="http://schemas.datacontract.org/2004/07/SecondTravel.Library.Instrumentation.Errors">Successful</ResultCode>
            <Errors xmlns="http://schemas.datacontract.org/2004/07/SecondTravel.Library.Instrumentation.Errors"/>
            <Infos xmlns="http://schemas.datacontract.org/2004/07/SecondTravel.Library.Instrumentation.Errors"/>
            <Warnings xmlns="http://schemas.datacontract.org/2004/07/SecondTravel.Library.Instrumentation.Errors"/>
            <TransactionHandleName xmlns="http://schemas.datacontract.org/2004/07/SecondTravel.Library.Instrumentation.Errors"/>
            <a:ResultSet xmlns:a="http://schemas.datacontract.org/2004/07/SecondTravel.Global.DataContract.Licence.v1_0" xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://SecondTravel.Global.ServiceContract.Licence.v1_0.ILicence" xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
                    <a:LicenceDCResultItem>
                      <a:FunctionalityCode>Users</a:FunctionalityCode>
                    </a:LicenceDCResultItem>
                    <a:LicenceDCResultItem>
                      <a:FunctionalityCode>Global_Codes</a:FunctionalityCode>
                    </a:LicenceDCResultItem>
                    <a:LicenceDCResultItem>
                      <a:FunctionalityCode>Global_Subscribe</a:FunctionalityCode>
                    </a:LicenceDCResultItem>
                  </a:ResultSet>

XQuery:

declare namespace a='http://schemas.datacontract.org/2004/07/SecondTravel.Global.DataContract.Licence.v1_0';
declare namespace ns1='http://SecondTravel.Global.ServiceContract.Licence.v1_0Package.ILicencePackage';
<Licences>
{
for $z in //ns1:GetListResult/a:ResultSet/a:LicenceDCResultItem/a:FunctionalityCode/text()
order by $z return <FunctionalityCodes>{data($z)}</FunctionalityCodes>
}
</Licences>

this returns all functionalitycodes in a ordered list that then is compared with the expected result (in the same ordered list)

hope this helps others finding into XQuery faster

regards Christoph