declare namespace nTestResults='urn:IEEE-1636.1:2013:TestResults';

declare namespace nCommon='urn:IEEE-1671:2010:Common';

declare namespace nNi='www.ni.com/TestStand/ATMLTestResults/3.0';

let $DocumentNames := ('Report/89500019-0000-4020-a039-9f53a80d7058', 'Report/89400019-0052-4020-a0f0-e1851b8bbec2', 'Report/00000000-0000-4020-a093-6c29d4c65c32', 'Report/00000000-0000-4020-a09c-ac632bfa5a7d', 'Report/00000000-0000-4020-a09c-ac635023a45c', 'Report/00000000-0000-4020-a09c-ac63e9c5b490', 'Report/89500019-0051-4020-a170-409bbe8e4f89', 'Report/89500019-0051-4020-a170-409b334e86c8')

for $DocumentName in $DocumentNames

let $Document := db:open('ATML',$DocumentName)

let $TestSystemItem0 := $Document/nTestResultsCollection:TestResultsCollection/nTestResultsCollection:TestResults/nTestResults:TestStation/nCommon:Definition/nCommon:Identification/nCommon:ModelName/text()

let $TestSystemItem1 := $Document/nTestResultsCollection:TestResultsCollection/nTestResultsCollection:TestResults/nTestResults:TestStation/nCommon:Definition/nCommon:Extension/nNi:Items/nNi:Item/Content/text()

let $StartDate := $Document/nTestResultsCollection:TestResultsCollection/nTestResultsCollection:TestResults/nTestResults:ResultSet/substring-before(data(@startDateTime), 'T')

let $StartTime := $Document/nTestResultsCollection:TestResultsCollection/nTestResultsCollection:TestResults/nTestResults:ResultSet/substring-after(data(@startDateTime), 'T')

let $UUID := $Document/nTestResultsCollection:TestResultsCollection/nTestResultsCollection:TestResults/data(@uuid)

let $Serial_Number := $Document/nTestResultsCollection:TestResultsCollection/nTestResultsCollection:TestResults/nTestResults:UUT/nCommon:SerialNumber/text()

let $Part_Number := $Document/nTestResultsCollection:TestResultsCollection/nTestResultsCollection:TestResults/nTestResults:UUT/nCommon:Definition/data(@name)

let $Slot_ID := $Document/nTestResultsCollection:TestResultsCollection/nTestResultsCollection:TestResults/nTestResults:TestStation/nCommon:Definition/nCommon:Extension/nNi:Items/nNi:Item/Content/text()

order by $StartDate, $StartTime

return

<Result>

  <DocumentName>{ $DocumentName }</DocumentName>

  <TestSystemItem0>{ $TestSystemItem0 }</TestSystemItem0>

  <TestSystemItem1>{ $TestSystemItem1 }</TestSystemItem1>

  <StartDate>{ $StartDate }</StartDate>

  <StartTime>{ $StartTime }</StartTime>

  <Serial_Number>{ $Serial_Number }</Serial_Number>

  <Part_Number>{ $Part_Number }</Part_Number>

  <Slot_ID>{ $Slot_ID }</Slot_ID>

  <Additional_Info></Additional_Info>

  <ChildResults>    

  {        

    let $Childs := $Document/nTestResultsCollection:TestResultsCollection/nTestResultsCollection:TestResults/nTestResults:ResultSet//nTestResults:TestGroup/nTestResults:Test

    for $Test in $Childs 

    let $TestData := $Test/nTestResults:TestResult/nTestResults:TestData

    let $Limits := $Test/nTestResults:TestResult/nTestResults:TestLimits/nTestResults:Limits

    let $TestId := $Test/data(@ID)

    let $TestName := $Test/data(@name)

    let $TestGroup := $Test/../substring-after(data(@name), '#')

    let $TestOutcome := $Test/nTestResults:Outcome/data(@value)

    let $Root := $Test/root()

    let $RootUuid := $Root/nTestResultsCollection:TestResultsCollection/nTestResultsCollection:TestResults/data(@uuid)

    

    where (($TestName = 'Course Datum MON (7V)' and $TestGroup = 'Course Datum Input Test' and $RootUuid = $UUID))

    return

    <Test>

      <TestData>{ $TestData }</TestData>

      <Limits>{ $Limits }</Limits>

      <TestId>{ $TestId }</TestId>

      <TestName>{ $TestName }</TestName>

      <TestGroup>{ $TestGroup }</TestGroup>

      <TestOutcome>{ $TestOutcome }</TestOutcome>

      <Temperature></Temperature>

    </Test>

  }

  </ChildResults>

</Result>