Issue Subtasks

ISSUESUBTAKS
Column	PARENTID	SUBTASKID
Type	BIGINT	BIGINT
Indexed	x	x

Example

Get all the subtasks created in my reported issues by a different user than me (Who has created subtasks in my reported issues?)

Example 1

SELECT 
    KEY(JQL.ISSUE) AS "My reported Issues",
    KEY(JQL2.ISSUE) AS "Subtask",
    REPORTER(JQL2.ISSUE) AS "The creator of the subtask"
FROM 
  JQL
    JOIN
  ISSUESUBTASKS S ON S.PARENTID = JQL.ISSUEID
     JOIN
   JQL JQL2 ON JQL2.ISSUEID = S.SUBTASKID
WHERE
  JQL.QUERY = ' reporter=currentUser() '
    AND
  REPORTER(JQL.ISSUE) != REPORTER(JQL2.ISSUE)

My reported Issues	Subtask	The creator of the subtask
SSP-10	SSP-11	John Smith
SSP-10	SSP-12	George Washington
SSP-6	SSP-7	Freddy Mercury
SSP-2	SSP-25	Bruce Springsteen