Inflectra Customer Forums: How to get a list of all tables under SpiraTestEntities (Thread) Hello comminity, Im new in Spira and currently working with Custom Report creation so have few questions. 1. Is it possible to extract all table from SpiraTestEntities by using something similar to the following? SELECT * FROM INFORMATION_SCHEMA.TABLES 2. Currently in the project we are using electronic signature for Test sets, Incidents, Requirments. So what is the way to retrieve electronic signature date and hash for those entities? Would be appreciated for any help. Best Regards, Andrii B 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/spirateam/reports/2035.aspxthreadId=2035Andrii Bilous (andrii.bilous@edetek.com)custom reportHow to get a list of all tables under SpiraTestEntities Hello comminity, Im new in Spira and currently working with Custom Report creation so have few questions. 1. Is it possible to extract all table from SpiraTestEntities by using something similar to the following? SELECT * FROM INFORMATION_SCHEMA.TABLES 2. Currently in the project we are using electronic signature for Test sets, Incidents, Requirments. So what is the way to retrieve electronic signature date and hash for those entities? Would be appreciated for any help. Best Regards, Andrii B Fri, 24 May 2019 10:19:48 -04002019-06-05T04:34:21-04:00/Support/Forum/spirateam/reports/2035.aspxmessageId=3593David J (support1@inflectra.com) We dont have an exact list, but if you go to the Edit Reports page, you can see the list in the dro We dont have an exact list, but if you go to the Edit Reports page, you can see the list in the dropdown. I put that into a spreadsheet and got: Name Entity Collection ArtifactAssociations SpiraTestEntities.R_ArtifactAssociations ArtifactAttachments SpiraTestEntities.R_ArtifactAttachments Attachments SpiraTestEntities.R_Attachments Automation Hosts SpiraTestEntities.R_AutomationHosts Builds SpiraTestEntities.R_Builds Comments SpiraTestEntities.R_Comments Components SpiraTestEntities.R_Components Custom Lists SpiraTestEntities.R_CustomLists Custom List Values SpiraTestEntities.R_CustomListValues Custom Property Definitions SpiraTestEntities.R_CustomPropertyDefinitions Events SpiraTestEntities.R_Events History Change-Sets SpiraTestEntities.R_HistoryChangeSets HistoryDetails SpiraTestEntities.R_HistoryDetails Incidents SpiraTestEntities.R_Incidents Projects SpiraTestEntities.R_Projects Project Groups SpiraTestEntities.R_ProjectGroups Project Release Resources SpiraTestEntities.R_ProjectReleaseResources Releases SpiraTestEntities.R_Releases Release Test Case Mapping SpiraTestEntities.R_ReleaseTestCases Requirements SpiraTestEntities.R_Requirements Requirement Incidents SpiraTestEntities.R_RequirementIncidents Requirement Test Case Coverage SpiraTestEntities.R_RequirementTestCases Requirement Test Step Coverage SpiraTestEntities.R_RequirementTestSteps Tasks SpiraTestEntities.R_Tasks Test Cases SpiraTestEntities.R_TestCases Test Case Folders SpiraTestEntities.R_TestCaseFolders Test Case Incidents SpiraTestEntities.R_TestCaseIncidents TestConfigurationEntries SpiraTestEntities.R_TestConfigurationEntries TestConfigurationSets SpiraTestEntities.R_TestConfigurationSets Test Runs SpiraTestEntities.R_TestRuns Test Run Incidents SpiraTestEntities.R_TestRunIncidents Test Run Steps SpiraTestEntities.R_TestRunSteps Test Sets SpiraTestEntities.R_TestSets Test Set Folders SpiraTestEntities.R_TestSetFolders Test Set Incidents SpiraTestEntities.R_TestSetIncident Test Set Test Cases SpiraTestEntities.R_TestSetTestCases Test Steps SpiraTestEntities.R_TestSteps Users SpiraTestEntities.R_Users Then if you choose the entity in the dropdown, Spira makes a query that does a SELECT * from the entity set, showing all of the columns in the Preview. Wed, 29 May 2019 19:48:46 -04002019-05-29T19:48:46-04:00/Support/Forum/spirateam/reports/2035.aspx#reply3593messageId=3601Andrii Bilous (andrii.bilous@edetek.com) This helps a lot. Thanks Adam. This helps a lot. Thanks Adam. Wed, 05 Jun 2019 04:34:20 -04002019-06-05T04:34:20-04:00/Support/Forum/spirateam/reports/2035.aspx#reply3601