Test Management 2.0 - How are Tests tied to Stories?

[Duncan Pederse1]

We are using Agile 2.0 and Test Management 2.0.

When you access the Sprint Tracking tab on the Agile Board, you can add Tests to Stories. 

However, on the Test record itself, there is no field tying the Test to the Story. I would expect a reference field, titled "Parent" or "Parent Story" or something, but there does not appear to be a field like this. As there is no parent field, we are having difficulty with Reporting. We want to report on Stories which have no Tests, for example, but we cannot relate the Tests to the Stories.

There must be some relationship table, as the Test always appears under that Story in the Sprint Tracking tab. I am trying to figure out, where is that relationship table?

[Duncan Pederse1 · Accepted solution]

Found the answer using the Schema Map: the relationship table is Task test (sn_test_management_m2m_task_test)

[Balaji Mohan2]

Hi dppedersen1

Still I am facing this problem after using the table "sn_test_management_m2m_task_test"

I want to report on Stories which have no Tests linked to it. But this m2m table have stories with linked tests only so cannot find the stories without linked tests. How did you use this m2m table to find the stories without linked tests.

Any idea please.

Thanks

Balaji

[ggg]

so i had to do something similiar in Test management 1.0 where we want a report on test cases with or without related defects.

There is a m2m table linking defects to test cases.

I created a db view and used a left join to get test cases with or without defects.

I created a report source from the db view.

that is the source for my report.

[Duncan Pederse1]

I created a Script include that I used in a sys_idINjavascript:FindStoriesWithoutTests() condition.

That script queried the Story table for all stories, then queried sn_test_management_m2m_task_test for every story, and if no record for that Story was found in sn_test_management_m2m_task_test, then I included that sys_id in my returned String.