Take the 2-minute tour ×
Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. It's 100% free, no registration required.

IN HP QC 10, I'm looking to find all tests that have not had their design steps altered in the last 6 months. Having trouble finding the correct table and query to do this..... Thanks,

share|improve this question
add comment

1 Answer 1

You want to use the DESSTEPS table, grouping by test ID. You can join this on the TEST table to get details on the test

SELECT DS_TEST_ID, max(ds_vts)
FROM DESSTEPS s inner join TEST t on s.DS_TEST_ID = t.TS_TEST_ID
group by DS_TEST_ID
having max(ds_vts) < DATEADD(month,-6,GETDATE())     --6 months ago
share|improve this answer
    
I hope you don't mind but I suggested an update as the OP was asking for tests that have not been edited in the last 6 months this should be < instead of >=. +1 for the solution –  Harrison Jan 30 at 21:34
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.