Filter/View

Filter all test cases that have at least one test step failed without defect associated

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

  1. Filter with Projects=Project A and Item Type =Test Run
  2. 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)
  3. 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

RELATED LINKS

How to create Test Run Filter

Related Articles