/
Issue Subtasks

Issue Subtasks

Owned by Pablo Beltran (Unlicensed)
Last updated: Oct 08, 2018

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)

My reported Issues  

Subtask  

The creator of the subtask  

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