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 en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/1773.aspxthreadId=1773David J (adam.sandman+support@inflectra.com)custom reports esql tasks requirements deleted 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 Tue, 21 Nov 2017 20:39:38 -05002017-11-21T20:42:14-05:00/Support/Forum/spirateam/reports/1773.aspxmessageId=3162David J (adam.sandman+support@inflectra.com) For information on how to use custom reports, please check out this webinar: https://www.inflectra.com/ideas/entry/516.aspx Tue, 21 Nov 2017 20:42:13 -05002017-11-21T20:42:13-05:00/Support/Forum/spirateam/reports/1773.aspx#reply3162