nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Extract parent issues and all it's sub issues.

akukkuje

Hi,

Is there a way to extract sub issues along with the parent issue while using a JQL with the parent filter field?

Example: https:base/rest/api/3/search?jql=project=TEST+and+cf[10814]~'user@test.com'

Note:

cf[10814] = parent field

Currently, I'm able to extract only parent issues and I'm missing sub issues.

Accepted answers

Ste Wright

Hi @akukkuje

What kind of parent field is it? If I'm reading the above right, Parents are usually not email addresses!

Ste

Jack Nolddor [Sweet Bananas]

Hi,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack (if you are on Server / DataCenter) you can type the following:

1) A bunch of issues

project = PL AND issuetype = Task AND fixVersion = "v1.2"

2) Find all subtasks under a given issues

issue IN subtasksOf(' project = PL AND issuetype = Task AND fixVersion = "v1.2"   ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

Regards

All comments

Ste Wright

Hi @akukkuje

What kind of parent field is it? If I'm reading the above right, Parents are usually not email addresses!

Ste

akukkuje

Hi @Ste Wright

It's a custom field and using this custom field to store some email address and I'm trying to filter issues based on the value in the custom field.

Please note: The above custom field is not present in sub issues.

currently, I'm able to get only the list of parents but not their sub issues in the final response.

I'm trying something like: key in subtasksOf(jql)

Ste Wright

Hi @akukkuje

Just to confirm, you want to see:

All the issues in project Test...
Which contain that email address in a custom field and...
All the children of those parent issues that contain this email address?

You mention subtasksOf - this kind of JQL function is only available via an app, allowing you to include a sub-query.

Apps such as ScriptRunner allow you to have:

issueFunction in subtasksOf("project = TEST AND cf[10814] ~ 'user@test.com'") or project = TEST AND cf[10814] ~ "user@test.com"

^ This gives you the sub-tasks below the parent issues, and the parents themselves

This is the actual JQL, which you could for the REST API call.

Ste

akukkuje

@Ste Wright thanks for your suggestion.

I found "key in subtasksOf(jql)" while searching on google.

Can we do the above task using cloud REST API?

Jack Nolddor [Sweet Bananas]

Hi,

1) A bunch of issues

project = PL AND issuetype = Task AND fixVersion = "v1.2"

2) Find all subtasks under a given issues

issue IN subtasksOf(' project = PL AND issuetype = Task AND fixVersion = "v1.2"   ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

Regards

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software