ISSUESUBTAKS | ||
|---|---|---|
Column | PARENTID | SUBTASKID |
Type | BIGINT | BIGINT |
Indexed | x | x |
Get all the subtasks created in my reported issues by a different user than me (Who has created subtasks in my reported issues?)
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) |
SSP-10 | SSP-11 | John Smith |
SSP-10 | SSP-12 | George Washington |
SSP-6 | SSP-7 | Freddy Mercury |
SSP-2 | SSP-25 | Bruce Springsteen |