JQL for subtaskof()

[Naresh]

Datcenter 8.20.10

Scenario :   When  subtask status in "Delivered", then it should check 

1) status of parent issue  (parent status should be "baseline")

2) issuetype of Parent issue  (Group, test)

3) if above 2 satisfies then copy fields from subtask to Parent

What is the JQL for issues with having parent status and issuetype as mentioned above

I tried ,,,  issue IN subtasksOf("status =Baselined") ,      getting error

stating Invalid subtasks.

Also tried using "copy issue fields (JSU)

with condition,

issue.parent?.issueType?.name == "1Requirement" || issue.parent?.issueType?.name == "1Group" || issue.parent?.issueType?.name == "1Informative"

but no result

[mauricio.groth]

Hi @Naresh 

As you're on Jira Server, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions 

You can use this query to find all your subtasks whose status is delivered with parents with status = baselined and the issue type is Group or test.

issue in subtaskOf("status = Baselined and issuetype in (“Group”, “test”)”) and status = delivered

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício