Skip Navigation LinksHome Page > Forums > 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

Tuesday, April 21, 2015

reporting

database

Shadowfoot

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. https://www.inflectra.com/Support/KnowledgeBase/KB73.aspx 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

Tuesday, May 5, 2015

~~inflectra.jimx~~

re: Shadowfoot Tuesday, April 21, 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.
Regards
Jim

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

Statistics

Started: Tuesday, April 21, 2015
Last Reply: Tuesday, May 5, 2015
Replies: 1
Views: 6241

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

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

Edit Thread

Edit Message

Search Results