Thread

Skip Navigation LinksForums > SpiraTeam Forums > SpiraTeam Issues & Questi... > SQL queries for summary i...

SQL queries for summary incidents RSS Feed

Thursday, September 26, 2013

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
Adam SAdam S
re: Juliana F Saito on Thursday, September 26, 2013
Thursday, September 26, 2013

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

Juliana F SaitoJuliana F Saito
re: Adam S on Thursday, September 26, 2013
Monday, September 30, 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!

Julien DELVOYEJulien DELVOYE
re: Juliana F Saito on Monday, September 30, 2013
Tuesday, February 18, 2014
Hi Juliana,

do you have founded for it : " I need extract one test case report and graphics report for each folder"
Tagged
Statistics
  • Started: 9/26/2013
  • Last Reply: 2/18/2014
  • Replies: 3
  • Views: 675
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.