ISSUESUBTAKS | ||
|---|---|---|
Column | PARENTID | SUBTASKID |
Type | BIGINT | BIGINT |
Indexed | x | x |
Example
Get all the subtasks created in my reporter reported issues by a different user than me (Who has created subtasks in my reported issues?)
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
SELECT
KEY(JQL.ISSUE) AS "ParentMy 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 |