Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Questi... > SQL queries for summary i...
Hi, I would like extract some data for incidents summaries using the SQL queries. But I don't know the name of tables for to do this. Someone can I help me?
Using real database SQL you could use:
SELECT * FROM VW_INCIDENT_LIST
using EntitySQL in the custom report generator, you could use:
select value R from SpiraTestEntities.R_Incident
I need another help... I have tests cases separated by folders. I have these folders bellow in my project and I need extract one test case report and graphics report for each folder. Can you help me? WDS (150) DPS (49) FME (2) GIS - Consumidores (22) GIS Logradouros (8) LOGOS (6) Migração - Distribuição (211) SIAS (2) GIS OMS (370)
Thank you again!