How to group all tasks when status for epic is in progress using JQL?

[Swarna Radha]

Hi,

I want to get a JQL when status is in progress then all tasks appear on the kanban board.

Thanks

Swarna

[kavi shree]

Hi @Swarna Radha

Need to have some JQLfunctions which is provided by script runner

eg:

Filter1

project = xxx and issuetype = epic and status = "in progress"

Filter2:

Project = xx and issuetype=task and isuefunction in issuesInEpic("filter = filter1")

Guess this should work

issuesInEpic retrieves the issues that are associated to a epic based on sub query..

Cheers

[Swarna Radha]

@kavi shree,

I have tried  issueFunction in issuesInEpics("filter= Epic-In Development") but getting error.

• Error in scripted function: issuesInEpics, see below
• NoViableAltException(59@[])

[kavi shree]

@Swarna Radha 

try with the available scripted JQL functions(available in your jira) which will retrieve issues linked to a epic

[Swarna Radha]

@kavi shree, It works but I want to get the epic also. I am getting all tasks when epic is in progress.

[kavi shree]

Try with some recursive functionality.

Check out the below to get an idea

https://community.atlassian.com/t5/Jira-questions/Find-linked-issues-recursively-without-epic-links/qaq-p/201296

Cheers,

[Alexey Matveev]

Hello,

I am not sure what you want to do. But the JQL query would be 

status = "In Progress"

[Swarna Radha]

@Alexey Matveev 

I want to have a JQL filter to be used on a kanban board when epic will be in progress, then its tasks will appear on the kanban . If epic is status "To do", then the board should be empty.