Eviware Forum

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

Hi Christoph,

you can use the XQuery assertion for this; create an XQuery that selects an ordered list of the items you want to test, and specify the expected results..

Get to grips with XQuery with something like http://www.w3schools.com/xquery/default.asp

regards,

/Ole
eviware.com

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

cool! Thanks for sharing!

/Ole
eviware.com