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? en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/1205.aspxthreadId=1205Brian Logan (brian.logan@verifone.com)database reporting 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? Tue, 21 Apr 2015 20:54:58 -04002015-05-05T16:04:48-04:00/Support/Forum/spiratest/issues-questions/1205.aspxmessageId=2118Jim R (donotreply5@kronodesk.net) 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 Tue, 05 May 2015 16:04:48 -04002015-05-05T16:04:48-04:00/Support/Forum/spiratest/issues-questions/1205.aspx#reply2118