I am executing the below query to fetch the test case details form test lab. But it is fetching duplicate values.
Attached the ouptut.
In the output "No Run" status is not availabe in QC.
Please let me know if i can get the latest status.
Placed the query below
SELECT ALL_LISTS.AL_DESCRIPTION As 'Process',TEST.TS_NAME As 'Test Name',
TESTCYCL.TC_STATUS As 'Test Status',
TESTCYCL.TC_USER_04 As 'Test Lead Approved or Rejected',
count (ds_step_order) As '# of Steps',
TESTCYCL.TC_USER_01 As 'Q&C Reviewer',
TESTCYCL.TC_USER_03 As 'Q&C Post Review Status'
FROM TEST, TESTCYCL, DESSTEPS, ALL_LISTS
WHERE TEST.TS_TEST_ID = TESTCYCL.TC_TEST_ID
And TEST.TS_TEST_ID = DESSTEPS.DS_TEST_ID
And TEST.TS_SUBJECT = ALL_LISTS.AL_ITEM_ID
And ALL_LISTS.AL_DESCRIPTION in ( 'Service Request Management' ) and ALL_LISTS.AL_ITEM_ID in ( 1597 )
group by ds_test_id, TEST.TS_Name,ALL_LISTS.AL_DESCRIPTION, TESTCYCL.TC_STATUS, TESTCYCL.TC_USER_03, TESTCYCL.TC_USER_01, TESTCYCL.TC_USER_04
order by ALL_LISTS.AL_DESCRIPTION, TEST.TS_Name
It would suggest that you have two copies of each test in the Test Lab. Collect the values in TESTCYCL.TC_TESTCYCL_ID and TESTCYCL.TC_CYCLE_ID and print those out. The first is the id of the test instance, and the second is the id of the Test Set that holds the Test Instance. That will tell you if you are getting two unique instances of each test.
(Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)