Reporting: Change History for Test Steps; for Test Set Contents?

Tuesday, August 16, 2011 9:19:56 PM
Is there a way I can report on the following in SpiraTeam:
  1. Changes to the Test Steps within a particular Test Case (where "Test Steps" would include both regular/native steps and "linked steps")?
    • I've tried the Test Case Detailed Report, with Artifact Change History and Test Steps - but that apparently only tracks change to the Test Case metadata, not the actual step contents.
  2. Changes to the set of Test Cases contained within a particular Test Set
Cheers.

3 Replies
Saturday, August 27, 2011 3:07:31 AM
Avatar
re: julierob on Tuesday, August 16, 2011 9:19:56 PM

Julie

You'd need to query the TST_TEST_CASE, TST_TEST_STEP AND the appropriate HISTORY tables (the names changed between v3.1 and v3.0) to get this data, we don't have a report available.

Let us know which version you're using and we can send over the names of the appropriate history tables.

Tuesday, August 30, 2011 4:31:52 PM
Avatar
re: inflectra.adam on Friday, August 26, 2011
Thanks.  If you can provide the appropriate history tables for v3.1, that would be appreciated!

Long term, it'd be a nice enhancement to get this kind of reporting baked into the tool itself (I imagine we're not your only "regulated" customers who need this info), but my initial requirements should be satisfied as long as we can access the info from the database.
Wednesday, September 7, 2011 5:09:40 PM
Avatar
re: julierob on Tuesday, August 30, 2011

The tables are:

TST_HISTORY_CHANGESET and TST_HISTORY_DETAIL

Statistics
  • Started: Tuesday, August 16, 2011 9:19:56 PM
  • Last Reply: Wednesday, September 7, 2011 5:09:40 PM
  • Replies: 3
  • Views: 974