Defects not linked to Requirement report

We are trying to generate a list of defects out of ALM that are not linked to a requirement so we can go back and link the requirements to defects manually because the tester did not create the defect during their test run.

 

I have been trying to use the Analysis View and creating a standard defect report, but cannot seem to figure this out.

 

Any help would be greatly appreciated and a huge timesaver!


Regards.

Victoria

  • Defects are not technically linked to requirements directly because by default requirements are covered by test cases. Then instances of a Test Cases (not the actual test case) are run inside test lab (you can run same instance multiple times). When you run an instance of a test case, it creates a "run" record. So the tester links a defect (he/she found during execution of an instance of a test case) to the run ...

     

    In order for you to find requirements with underlying defects you have to link requirements to test cases to test instances to runs to defects ... if you search for end to end traceability report via SQL there should already be posts around that. Good luck!

  • Read your post again ... you know what my post is not relevant because it is more suited towards finding requirements with/without defects when you wanted to find defects not linked to requirements. Two separate things. Sorry I dont have experience with that kind of report. Good luck!

  • @vlrbon09

     

    Show us what you've tried (provide screen images) and explain how it is not giving you what you want.

     

    Also, what version of the product are you using?

     

    With v11.52 I am able to create a Project report to list all defects. I can then Add a Report Section to that for Requirements. If I then print the report it shows all the defects, and for those that have linked requirements it includes the linked requirement information. I can look through that and manually pick out which ones don't have linked requirements.

     

     

     

     

  • @vlrbon09

     

    Show us what you've tried (provide screen images) and explain how it is not giving you what you want.

     

    Also, what version of the product are you using?

     

    With v11.52 I am able to create a Project report to list all defects. I can then Add a Report Section to that for Requirements. If I then print the report it shows all the defects, and for those that have linked requirements it includes the linked requirement information. I can look through that and manually pick out which ones don't have linked requirements.

     

     

     

     

  • @vlrbon09

     

    Show us what you've tried (provide screen images) and explain how it is not giving you what you want.

     

    Also, what version of the product are you using?

     

    With v11.52 I am able to create a Project report to list all defects. I can then Add a Report Section to that for Requirements. If I then print the report it shows all the defects, and for those that have linked requirements it includes the linked requirement information. I can look through that and manually pick out which ones don't have linked requirements.

     

     

     

     

  • The Link table in your database/schema stores all of the links for your defects/bugs.

     

    If you run a SQL qry against the Bug table and the Link table, you can find the defects that have no links out tests or requirements.  Just make sure to filter out the bug to bug links to avoid false results.

  • I figured out the right query for this. This can be run as an Excel report in the Analysis View of the Dashboard. It will return a list of Bug IDs that do not have a link to a Requirement.

     

    select 
      bg_bug_id
    from 
      bug
    except
    select 
      ln_bug_id
    from 
      link
    WHERE 
      ln_ENTITY_type='REQ'

     

  • I am unable to find table called "Links" under Excel report for Query builder >> Entiries view ( user and SQl Entities).

    So above query didnt work as resulted in SQL Error when run

     

    Attached are the table names preceding "L"

  • Thanks Trudy.  I wasn't at my workstation at the end of the day to craft a SQL.  My memory is good enough to remember what table does what when sitting in meetings on a tablet, but not good enough to remember the column names!

  • if you are using the query builder, the actual table name is listed in parenthesis.  Over the years some features or modules have changed names, but the underlying tables have stayed the same.  Best example is Defects, which used to be called Bugs, and are still stored in the BUG table.

     

    IIRC, LINK is probably called Associated or Association.  It will have (LINK) next to it however.  I am away from my workstation so I cannot validate this exactly, but it should put you in the ballpark.

     

    When you put it in the query window it will show up as LINK, with columns as LINK.LN_BIG_ID.  Trudy's query should work.