The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:




Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Testing Tools >> HP / Mercury TestDirector

Pages: 1
athresh
Newbie


Reged: 06/30/12
Posts: 14
Last run report
      #711183 - 06/30/12 10:15 PM

Hi i am using following query to get test execution report . but i am getting records from all the runs but i need data from only latest run ..here is my query please help me out to get the report only based on the last run


SELECT CYCLE.CY_CYCLE as Test_Set ,
CYCLE.CY_CYCLE_ID as Test_Set_ID,
TESTCYCL.TC_TEST_INSTANCE as Test_Instance_Name,
TESTCYCL.TC_CYCLE_ID as Test_Instance_Test_Set_ID,
TEST.TS_NAME as Test_Case,
TEST.TS_TEST_ID as Test_Case_ID,
st_description as Step_Description ,
st_expected as Step_expectedresult ,
TESTCYCL.TC_TESTER_NAME as Tester,
STEP.ST_STEP_NAME as Step_Name,
STEP.ST_STATUS as Step_Status ,
-- tc_exec_date as "Execution Date",
--tc_exec_time as "Execution Time" ,
st_user_04 as Scripting_Team,
rn_run_id as run_id ,
RN_EXECUTION_DATE as rn_exe_date,
rn_execution_time as execution_time
FROM CYCLE, TESTCYCL, TEST, STEP, RUN
--where test.ts_name like '%ca%'
where(CYCLE.CY_CYCLE_ID = TESTCYCL.TC_CYCLE_ID)
and cycle.cy_cycle like'%int%'
AND (TEST.TS_TEST_ID = TESTCYCL.TC_TEST_ID)
AND (RUN.RN_TESTCYCL_ID = TESTCYCL.TC_TESTCYCL_ID)
AND (STEP.ST_RUN_ID = RUN.RN_RUN_ID)


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1



Extra information
0 registered and 2 anonymous users are browsing this forum.

Moderator:  AJ, jgottlieb, corklad, bpolitzer 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 1257

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5