Jump to content

Show latest test run only in XSLT?


w3randall

Recommended Posts

My report is currently displaying every test that is run. I would like to change the report format so that only the latest run (by start date) of each test case is shown. For example, a test case is run twice, and I only want the latest run on the report. It should also work when new test cases are run in the future. How can I do that in XSLT? What would my code be like or what type of function will I use? Let me know if you need more info on this. Thanks!!

 

My XML code:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>     <Report>    <Title>Test Run Summary - Last Run Only Report</Title>     <ProjectData>    <Project>    <ProjectId>71</ProjectId>     <ProjectGroupId>13</ProjectGroupId>     <Name>Master Project - Marketing</Name>     <Description xml:space="preserve"></Description>     <CreationDate>2012-06-20T21:40:58.187-05:00</CreationDate>     <ActiveYn>Y</ActiveYn>     <WorkingHours>8</WorkingHours>     <WorkingDays>5</WorkingDays>     <NonWorkingHours>0</NonWorkingHours>     <TimeTrackIncidentsYn>Y</TimeTrackIncidentsYn>     <TimeTrackTasksYn>Y</TimeTrackTasksYn>     <EffortIncidentsYn>Y</EffortIncidentsYn>     <EffortTasksYn>Y</EffortTasksYn>     <TasksAutoCreateYn>Y</TasksAutoCreateYn>     <ProjectGroupName>Siebel Projects Group</ProjectGroupName>     </Project>    </ProjectData>  <TestRunData>  <TestRun>  <TestRunId>8377</TestRunId>   <Name>TS09 Verify system should allow for bottom/detail level campaigns to be tied 1:1 to offers-All Campaigns View</Name>   <Description>Pre-requisites1. The Catalog Manager user should have been setup and is active in Siebel 2. Campaigns should be available3. Divisions should be available in Division pick applet4. Offer should be available</Description>   <TestCaseId>3736</TestCaseId>   <TestRunTypeId>1</TestRunTypeId>   <TesterId>156</TesterId>   <ExecutionStatusId>2</ExecutionStatusId>   <ReleaseId>223</ReleaseId>   <ActualDuration>0</ActualDuration>   <StartDate>2013-07-22T11:50:30.77-05:00</StartDate>   <EndDate>2013-07-22T11:50:56.687-05:00</EndDate>   <AttachmentsYn>N</AttachmentsYn>   <TestRunTypeName>Manual</TestRunTypeName>   <TesterName>Jagdish Thakur</TesterName>   <ExecutionStatusName>Passed</ExecutionStatusName>   <ReleaseName>Master Release - Siebel Marketing</ReleaseName>   <ReleaseVersionNumber>1.0.0.0</ReleaseVersionNumber>   <PROJECT_ID>71</PROJECT_ID>   <CustomProperties />   </TestRun>  <TestRun>  <TestRunId>8390</TestRunId>   <Name>TS11 Verify system should allow for bottom/detail level campaigns to be tied 1:1 to offers-All Campaigns Across Organizations View</Name>   <Description>Pre-requisites1. The Catalog Manager user should have been setup and is active in Siebel 2. Campaigns should be available3. Divisions should be available in Division pick applet4. Offer should be available</Description>   <TestCaseId>3738</TestCaseId>   <TestRunTypeId>1</TestRunTypeId>   <TesterId>156</TesterId>   <ExecutionStatusId>2</ExecutionStatusId>   <ReleaseId>223</ReleaseId>   <ActualDuration>0</ActualDuration>   <StartDate>2013-07-22T11:53:49.52-05:00</StartDate>   <EndDate>2013-07-22T11:54:22.043-05:00</EndDate>   <AttachmentsYn>N</AttachmentsYn>   <TestRunTypeName>Manual</TestRunTypeName>   <TesterName>Jagdish Thakur</TesterName>   <ExecutionStatusName>Passed</ExecutionStatusName>   <ReleaseName>Master Release - Siebel Marketing</ReleaseName>   <ReleaseVersionNumber>1.0.0.0</ReleaseVersionNumber>   <PROJECT_ID>71</PROJECT_ID>   <CustomProperties />   </TestRun>  <TestRun>  <TestRunId>8405</TestRunId>   <Name>TS08 Verify system should allow for bottom/detail level campaigns to be tied 1:1 to offers-My Campaigns view</Name>   <Description>Pre-requisites1. The Catalog Manager user should have been setup and is active in Siebel 2. Campaigns should be available3. Divisions should be available in Division pick applet4. Offer should be available</Description>   <TestCaseId>3735</TestCaseId>   <TestRunTypeId>1</TestRunTypeId>   <TesterId>156</TesterId>   <ExecutionStatusId>2</ExecutionStatusId>   <ReleaseId>223</ReleaseId>   <TestSetId>382</TestSetId>   <TestSetTestCaseId>3342</TestSetTestCaseId>   <ActualDuration>0</ActualDuration>   <StartDate>2013-07-22T12:44:31.53-05:00</StartDate>   <EndDate>2013-07-22T12:44:49.297-05:00</EndDate>   <AttachmentsYn>N</AttachmentsYn>   <TestRunTypeName>Manual</TestRunTypeName>   <TesterName>Jagdish Thakur</TesterName>   <ExecutionStatusName>Passed</ExecutionStatusName>   <ReleaseName>Master Release - Siebel Marketing</ReleaseName>   <ReleaseVersionNumber>1.0.0.0</ReleaseVersionNumber>   <TestSetName>Campaign Promotion</TestSetName>   <PROJECT_ID>71</PROJECT_ID>   <CustomProperties />   </TestRun>  </TestRunData>  </Report>

post-167421-0-53414700-1382721763_thumb.jpg

Edited by w3randall
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...