...
ISSUESUBTAKS | ||
|---|---|---|
Column | PARENTID | SUBTASKID |
Type | BIGINT | BIGINT |
Indexed | x | x |
Example
How to obtain the keys for the Get all the issues and subtasks of the currentuser():
...
subtasks created in my reporter issues by a different user than me (Who has created subtasks in my reported issues?)
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
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) |