Custom Report Query to Find Tasks Linked to Deleted Requirements

Tuesday, November 21, 2017

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
re: inflectra.david Tuesday, November 21, 2017

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

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: Tuesday, November 21, 2017
  • Last Reply: Tuesday, November 21, 2017
  • Replies: 1
  • Views: 8010