Custom Report Query to Find Tasks Linked to Deleted Requirements

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