JQL Trick and subtask

[Fred BEAUFILS]

Hello !

I would like to get a list of issues with all subtask associated on each

Issue-1
subtask-2
subtask-3
subtask-4
Issue-6
subtask-12
subtask-32
subtask-44
Issue-61
subtask-121

I tried with the query
project = XXX AND issue in hasSubtasks() and issuetype = AAA
but I only get issuetype AAA and not subtask assiciated.

I don't know if it is possible, if yes, please tell me how.

[Fred BEAUFILS]

Hi Andre

thank you forthe request.

No error inthe query But I get issutype I dont' want which have no subtask.

[Andre Lehmann]

Hi Fred,

try:

project = XXX AND ((issue in hasSubtasks() and type = MAINTASKTYPE) OR issuetype = SUBTASKTYPE)

[Fred BEAUFILS]

Hi Andre

thank you forthe request.

No error inthe query But I get issutype I dont' want which have no subtask.

[Jobin Kuruvilla [Adaptavist]]

Fred, Can you try this?

(project = XXX AND issue in hasSubtasks() and issuetype = AAA) OR issue in parent(project = XXX AND issuetype = AAA)

[Fred BEAUFILS]

Hello Jobin, sorry for the delay.

It does not work. :-(

[Jobin Kuruvilla [Adaptavist]]

Hey Fred, what is missing when you try this query?

[Fred BEAUFILS]

on the second part "issue in parent(project = XXX AND issuetype = AAA)" I got this message "Error in the JQL Query: Expecting ')' or ',' but got '='. "

[Jobin Kuruvilla [Adaptavist]]

Can you try:

(project = XXX AND issue in hasSubtasks() and issuetype = AAA) OR issue in parent("project = XXX AND issuetype = AAA")

[Fred BEAUFILS]

I get this message :

The JIRA server could not be contacted. This may be a temporary glitch or the server may be down.

[JK]

I am sorry but I can not see any connection between your question and this message. Please make sure your server has no other severe problems.

[JK]

Does something like that work for you?

project = XXX and (issueFunction in hasSubtasks() or issuetype = Sub-task)

So you should get your wanted issues, but I fear you can not order them like you want to.