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