OVERVIEW
In some cases, you may wish to list out distinct test cases with the test steps failed but there is no defect linked with that failed step. To do so, we need to add the query in our filter
CREATE FILTER
- Filter with Projects=Project A and Item Type =Test Run
- User-defined Criteria: id in (select distinct Test_case_id from TEST_RUN_STEPS where Step_status in (‘FAIL’,’FAIL_STOP’) and Defect_id =0)
- Embed the View in the Item Description
Now, you will see all those test cases which have at least one failed step and that failed step has no defect associated with it
In case the user wants to filter the test cases with failed test steps only for those test case whose last test run status is Fail or Fail(Stop), use the user-defined criteria:id in (select distinct Test_case_id from TEST_RUN_STEPS where Step_status in (‘FAIL’,’FAIL_STOP’) and Defect_id =0 and Test_run_id in (select Test_run_id from TEST_RUN_CASES TC1 where id =(select max(TC2.id) from TEST_RUN_CASES TC2 where TC2.Test_case_id =TC1.Test_case_id)))
Make sure to replace single quotes in query in case we get the syntax error on Save Filter