/
Issue Subtasks
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)
SSP-10 | SSP-11 | John Smith |
SSP-10 | SSP-12 | George Washington |
SSP-6 | SSP-7 | Freddy Mercury |
SSP-2 | SSP-25 | Bruce Springsteen |
Related content
JQL
Read with this
Issue Custom Fields
Issue Custom Fields
Read with this
Issue Links
Issue Links
Read with this
Issues
Issues
Read with this
Table
Read with this
Custom JQLs (built on the fly)
Custom JQLs (built on the fly)
Read with this