Skip Navigation LinksForums > SpiraTest Forums > SpiraTest Issues & Questi... > How can I find (and updat...

How can I find (and update) the expected result of many test steps matching a specific Test Step Description RSS Feed

Tuesday, April 21, 2015
We have a situation where we have many tests that require the checking of records created. Our test cases have steps checking each field. The value of one field is the same in every record it appears and we need to change the expected value.

Is there a way I can bulk update the expected value of every test step matching a specific description? I don't have direct access to the database.

I tried creating a custom report to let me see the test cases and steps, but can't find any record of the fields available. tells me the tables I can report against, but doesn't tell me the fields available in R_TestSteps. Is there a way I can see the schema available for custom reports?

1 Replies
Jim R.Jim R.
re: Brian Logan on Tuesday, April 21, 2015
Tuesday, May 5, 2015
Hi Brian

If you don't have direct database access then you cannot really do a bulk update of the steps based on a criteria. You could use the MS-Excel Add-In to download all of the test cases (with steps), make the updates and then upload them back. That might be the best way? To see all the fields in the R_TestSteps view, simply choose the "Test Steps" value from the dropdown list of views and it will generate a default query that includes the clause:

select value R ...

That will display all of the fields in the view for you.
  • Started: 4/21/2015
  • Last Reply: 5/5/2015
  • Replies: 1
  • Views: 436
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.