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; } } }

how to get stories list which are not in closed state and task relates to story (same) is closed sta

Suryaprakash Thonupunuri

how to get stories list which are not in closed state and task relates to story (same) is closed status.

For a given project in JIRA, wanted to get the list of stories are not closed but tasks relates to this story got closed.

In my project story contains multiple tasks, each task handled by different user, as and when tasks are in closed status, we should change Story status to close. wanted to get the list of stories which are not closed but Task (issue type) relates to this story are in closed state.

Query: project = "Project name" AND type = Story ) AND assignee = current user AND status != Closed , and have analyse each story and change to close. So looking for option here . this Query gets stories but wanted stories and tasks of that stories in closed status.

Accepted answers

Mohamed Benziane

So, if you can't use an addon, i will suggest you to use jira python, here a code that i tried today (i'm not an expert but it's working)

from jira import JIRA


jira_cloud = JIRA(basic_auth=("username", 'token_cloud'), options={'server': 'https://jira_url/'})
issues_Jql = 'project = "ABC" and type = story'
my_issue = jira_cloud.search_issues(issues_Jql)


issue_list = []

for story in my_issue:
    for issue_task in story.fields.issuelinks:
        if hasattr(issue_task,"inwardIssue"):#look for the inward linked (the task issue type)
        linked_task = jira_cloud.issue(issue_task.inwardIssue.key) 
        if str(linked_task.fields.status) == "To Do":#status name that i'm looking for
            issue_list.append(story.key)
            issue_list.append(linked_task.key)




key_list = ""

for i in issue_list:
    key_list= key_list + i+","

key_list = key_list[:-1]#remove the last comma


jql_list = f"project = ABC AND issuekey in ({key_list})"
print (jql_list)

This code will return a jql with the story and linked task that are in to do status.

Or you can use google sheet and use 2 different jql one for the story and another one for the task and work on it to have everything in one sheet.

https://community.atlassian.com/t5/Jira-articles/Jira-Cloud-for-Google-Sheets-Automatically-Refresh-Your-Data/ba-p/1200264

Hope this helps

All comments

Lenin Raj

Hi @Suryaprakash Thonupunuri

When you say 'tasks', do you mean 'sub tasks'?

Mohamed Benziane

Hello,

The task are linked to your storie ? So to achieve what you want you'll need a plugin like Scriptrunner:

https://scriptrunner.adaptavist.com/4.3.4/jira/jql-functions.html#_linkedissuesof

It provides a JQL function that find linked issue with specific status.

edit : As @Lenin Raj asked, if by task you meant subtask you will also need an addon like scriptrunner too.

https://scriptrunner.adaptavist.com/4.3.4/jira/jql-functions.html#_hassubtasks

Hope this helps.

Suryaprakash Thonupunuri

jira atlassian.png

@Lenin Raj it is not the sub tasks,. it is issue type =task (in my project) and we are using option called "relating to" as shown in picture.. any comments

Mohamed Benziane

Ok, so you will need an-addon, you can look at my answer below.

Muhammad Ramzan_Atlassian Certified Master_

a third part plugin JQL Search Extensions for Jira & reports is available on Cloud which can solve your issue.

I create your scenario and its successfully returning the results.

What you need to do is.

Create one sub query "issuetype= Story and status= "closed""
Then use this query to get your results.

(subTaskOfQuery="subquery" and status="closed") or issuesInQuery="subquery"

Please note that "subquery" is the alias of the sub query. This query will return

stories list which are not in closed state and task relates to story (same) is closed status.

Here is the documentation , how to use it

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/173211649/Subqueries+-+Jira+Cloud

Suryaprakash Thonupunuri

Thank you, im not looking any add-on. Add-on required to add by Admin/Dev ops. this is forbidden in my case.

Suryaprakash Thonupunuri

apart from Add-on, any other solution?

Suryaprakash Thonupunuri

Thank you, Im not looking any add-on. Add-on required to add by Admin/Dev ops. this is forbidden in my case.

Mohamed Benziane

So, if you can't use an addon, i will suggest you to use jira python, here a code that i tried today (i'm not an expert but it's working)

from jira import JIRA


jira_cloud = JIRA(basic_auth=("username", 'token_cloud'), options={'server': 'https://jira_url/'})
issues_Jql = 'project = "ABC" and type = story'
my_issue = jira_cloud.search_issues(issues_Jql)


issue_list = []

for story in my_issue:
    for issue_task in story.fields.issuelinks:
        if hasattr(issue_task,"inwardIssue"):#look for the inward linked (the task issue type)
        linked_task = jira_cloud.issue(issue_task.inwardIssue.key) 
        if str(linked_task.fields.status) == "To Do":#status name that i'm looking for
            issue_list.append(story.key)
            issue_list.append(linked_task.key)




key_list = ""

for i in issue_list:
    key_list= key_list + i+","

key_list = key_list[:-1]#remove the last comma


jql_list = f"project = ABC AND issuekey in ({key_list})"
print (jql_list)

This code will return a jql with the story and linked task that are in to do status.

Or you can use google sheet and use 2 different jql one for the story and another one for the task and work on it to have everything in one sheet.

https://community.atlassian.com/t5/Jira-articles/Jira-Cloud-for-Google-Sheets-Automatically-Refresh-Your-Data/ba-p/1200264

Hope this helps

Suryaprakash Thonupunuri

Thank you @Mohamed Benziane , it is helping some extent. little work around but great helps. thank a lot.

Indu_88zie2

Please see if this helps

https://docs.automationforjira.com/issues/branching.html#related-issues-condition

Suryaprakash Thonupunuri

Thanks @Mohamed Benziane @Indu with PIP we are success .

global str
from jira import JIRA
jira = JIRA(basic_auth=("user ID", 'password'), options={'server': 'https://jira.xyz.com'})
for issue in jira.search_issues('project = XX AND type = "Story" AND assignee = "current User" AND status != "Closed" AND labels = new', maxResults=100):
if (issue.fields.issuelinks):
#print('{}: {}'.format(issue.key, issue.fields.status))
if str(issue.fields.status) != "Closed":
for links in issue.fields.issuelinks:
if hasattr(links, "outwardIssue"):
outwardIssue = links.outwardIssue
if str(outwardIssue.fields.status) != "OPEN":
print(outwardIssue.key,outwardIssue.fields.status,issue.key,issue.fields.status)

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-cloud