Custom Report Query to Find Tasks Linked to Deleted Requirements

Tuesday, November 21, 2017 8:39:38 PM

We had a customer that was looking for a custom report to find all of the Tasks in SpiraTeam that are linked to deleted requirements. These are requirements that are soft-deleted (i.e. have not been purged and can therefore be undeleted).

The ESQL query to use is:

select T.TASK_ID, T.NAME as TASK_NAME from SpiraTestEntities.R_Tasks as T
join SpiraTestEntities.R_Requirements as R on T.REQUIREMENT_ID = R.REQUIREMENT_ID
where T.PROJECT_ID = ${ProjectId} and R.IS_DELETED = True

 

1 Replies
Tuesday, November 21, 2017 8:42:13 PM
Avatar
re: inflectra.adam on Tuesday, November 21, 2017 8:39:38 PM

For information on how to use custom reports, please check out this webinar:

https://www.inflectra.com/ideas/entry/516.aspx

Statistics
  • Started: Tuesday, November 21, 2017 8:39:38 PM
  • Last Reply: Tuesday, November 21, 2017 8:42:14 PM
  • Replies: 1
  • Views: 56