SQL queries for summary incidents

Thursday, September 26, 2013

  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?

Thank you



3 Replies
Thursday, September 26, 2013
re: julianasaito Thursday, September 26, 2013

Using real database SQL you could use:



using EntitySQL in the custom report generator, you could use:

select value R from SpiraTestEntities.R_Incident

Monday, September 30, 2013
re: inflectra.david Thursday, September 26, 2013

Thank you!

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?
Expand Node WDS WDS (150)
Expand Node DPS DPS (49)
Expand Node FME FME (2)
Expand Node GIS - Consumidores GIS - Consumidores (22)
Expand Node GIS Logradouros GIS Logradouros (8)
Expand Node LOGOS LOGOS (6)
Expand Node Migração - Distribuição Migração - Distribuição  (211)
Expand Node SIAS SIAS (2)
 Expand NodeGIS OMS GIS OMS (370)

Thank you again!

Tuesday, February 18, 2014
re: julianasaito Monday, September 30, 2013
Hi Juliana,

do you have founded for it : " I need extract one test case report and graphics report for each folder"

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885


  • Started: Thursday, September 26, 2013
  • Last Reply: Tuesday, February 18, 2014
  • Replies: 3
  • Views: 2906