How to get a list of all tables under SpiraTestEntities

Friday, May 24, 2019
Avatar

Hello comminity,

I'm 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 

2 Replies
Wednesday, May 29, 2019
Avatar
re: AndriiB Friday, May 24, 2019

We don't 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:

NameEntity Collection
ArtifactAssociationsSpiraTestEntities.R_ArtifactAssociations
ArtifactAttachmentsSpiraTestEntities.R_ArtifactAttachments
AttachmentsSpiraTestEntities.R_Attachments
Automation HostsSpiraTestEntities.R_AutomationHosts
BuildsSpiraTestEntities.R_Builds
CommentsSpiraTestEntities.R_Comments
ComponentsSpiraTestEntities.R_Components
Custom ListsSpiraTestEntities.R_CustomLists
Custom List ValuesSpiraTestEntities.R_CustomListValues
Custom Property DefinitionsSpiraTestEntities.R_CustomPropertyDefinitions
EventsSpiraTestEntities.R_Events
History Change-SetsSpiraTestEntities.R_HistoryChangeSets
HistoryDetailsSpiraTestEntities.R_HistoryDetails
IncidentsSpiraTestEntities.R_Incidents
ProjectsSpiraTestEntities.R_Projects
Project GroupsSpiraTestEntities.R_ProjectGroups
Project Release ResourcesSpiraTestEntities.R_ProjectReleaseResources
ReleasesSpiraTestEntities.R_Releases
Release Test Case MappingSpiraTestEntities.R_ReleaseTestCases
RequirementsSpiraTestEntities.R_Requirements
Requirement IncidentsSpiraTestEntities.R_RequirementIncidents
Requirement Test Case CoverageSpiraTestEntities.R_RequirementTestCases
Requirement Test Step CoverageSpiraTestEntities.R_RequirementTestSteps
TasksSpiraTestEntities.R_Tasks
Test CasesSpiraTestEntities.R_TestCases
Test Case FoldersSpiraTestEntities.R_TestCaseFolders
Test Case IncidentsSpiraTestEntities.R_TestCaseIncidents
TestConfigurationEntriesSpiraTestEntities.R_TestConfigurationEntries
TestConfigurationSetsSpiraTestEntities.R_TestConfigurationSets
Test RunsSpiraTestEntities.R_TestRuns
Test Run IncidentsSpiraTestEntities.R_TestRunIncidents
Test Run StepsSpiraTestEntities.R_TestRunSteps
Test SetsSpiraTestEntities.R_TestSets
Test Set FoldersSpiraTestEntities.R_TestSetFolders
Test Set IncidentsSpiraTestEntities.R_TestSetIncident
Test Set Test CasesSpiraTestEntities.R_TestSetTestCases
Test StepsSpiraTestEntities.R_TestSteps
UsersSpiraTestEntities.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.

Wednesday, June 5, 2019
Avatar
re: inflectra.david Wednesday, May 29, 2019

This helps a lot.

Thanks Adam.

Statistics
  • Started: Friday, May 24, 2019
  • Last Reply: Wednesday, June 5, 2019
  • Replies: 2
  • Views: 160