SQL queries for summary incidents

Thursday, September 26, 2013 5:54:28 PM

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?

Thank you

 

 

3 Replies
Thursday, September 26, 2013 8:52:51 PM
Avatar
re: julianasaito on Thursday, September 26, 2013 5:54:28 PM

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

Monday, September 30, 2013 12:21:28 PM
Avatar
re: inflectra.adam on 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 1:50:48 PM
Avatar
re: julianasaito on 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"
Statistics
  • Started: Thursday, September 26, 2013 5:54:28 PM
  • Last Reply: Tuesday, February 18, 2014 1:50:48 PM
  • Replies: 3
  • Views: 759