Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > How to get a list of all ...
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.
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:
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.
This helps a lot.