Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > Custom Report Query to Fi...
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
For information on how to use custom reports, please check out this webinar:
https://www.inflectra.com/ideas/entry/516.aspx
And if you have any questions, please email or call us at +1 (202) 558-6885