Inflectra Customer Forums: Report that link an incident to a test step (Thread) Hi, Im trying to make a report that link a incident to a test step but I dont see any query that can help me. I can link an incident to a test case or to a test set but not to a test step. Can someone help me? thanks, Mchellaoui en-US(C) Copyright 2006-2024 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/2118.aspxthreadId=2118mokhtar chellaoui (chellaouimokhtar@gmail.com)Report that link an incident to a test step Hi, Im trying to make a report that link a incident to a test step but I dont see any query that can help me. I can link an incident to a test case or to a test set but not to a test step. Can someone help me? thanks, Mchellaoui Thu, 28 Nov 2019 12:55:31 -05002019-11-28T15:11:38-05:00/Support/Forum/spiratest/issues-questions/2118.aspxmessageId=3694mokhtar chellaoui (chellaouimokhtar@gmail.com) After browsing the documentation for hours, the best candidate table I could think of is R_Artif After browsing the documentation for hours, the best candidate table I could think of is R_ArtifactAssociations. But the result of this query is not complete: select value R from SpiraTestEntities.R_ArtifactAssociations as R where R.PROJECT_ID = ${ProjectId} All the associations are not present in this table... Is that a bug? When looking at a test run artifact, spira shows the steps where an incident occured. What is the query used to get this information? Thu, 28 Nov 2019 14:57:52 -05002019-11-28T14:57:52-05:00/Support/Forum/spiratest/issues-questions/2118.aspx#reply3694messageId=3695mokhtar chellaoui (chellaouimokhtar@gmail.com) I need to add that this query: select value R from SpiraTestEntities.R_ArtifactAssociations as I need to add that this query: select value R from SpiraTestEntities.R_ArtifactAssociations as R where R.PROJECT_ID = ${ProjectId} Gives me the following error message: System.Data.EntitySqlException: PROJECT_ID is not a member of type Inflectra.SpiraTest.DataModel.R_ArtifactAssociation in the currently loaded schemas. Near simple identifier, line 1, column 75. So by removing where R.PROJECT_ID = ${ProjectId}, I get a result, but this result is incomplete. I only see a related-to artifact association type between two incidents in my current project, the rest of the data are from years ago. Thu, 28 Nov 2019 15:11:38 -05002019-11-28T15:11:38-05:00/Support/Forum/spiratest/issues-questions/2118.aspx#reply3695