Hide completed Tasks Links in Epic View

[Feldunoob]

Hello,

I am trying to make a clean view in Jira, with EPIC Projects and an aggregate of current Tasks Links to complete, or under work.

Currently using this JQL :

project = OTO AND status in (New, OnGoing) AND statusCategory != Done AND (watcher = currentUser() OR assignee = currentUser()) AND type = Epic

However the Completed / Done tasks still appears to be shown with this output (as example) : OTO1-45544.

I have tried to use different methods, like statusCategory, or to even mix type = EPIC and Type = Tasks with specific order to hide completed Tasks.
I asked as well Bard IA to help out with this situation, it asks to do a "Filter List" and as "Conditions" with value : "status = Done" to hide completed Tasks links.

I am unable to have a clean view of aggregated tasks for each Epic.

[Mohanraj Thangamuthu]

Hello, Good day. I believe you can add "Epic status" to your query. Try the following JQL

project = OTO AND status in (New, OnGoing) AND statusCategory != Done AND (watcher = currentUser() OR assignee = currentUser()) AND type = Epic AND "Epic Status" != done

[Feldunoob]

It seems that the following isn't recognized :

"Epic Status" != done

[Mohanraj Thangamuthu]

On the JQL you can type Epic and a suggestion list should be available like below.

[Feldunoob]

There is no Epic Status, seems it has been changed to "key" in the XML export, and filter with key doesn't work.

Edit : it's not the Epic Status that i wish to filter, but the Tasks Status associated to that Epic that have their link shown. I do not wish to have terminated tasks visibles next to the Epic as aggregated list.

[Trudy Claspill]

Hello @Feldunoob 

Welcome to the Atlassian community.

The problem likely has to do with the mix of OR and AND operators in your filter.

Let us explore your requirements.

1. Do you want Epics in the result set?

1a. If yes, do you want Epics of only a certain status in the result set?

1b. And, are there any other conditions you want to apply directly to the selection of the Epic issues.

2. I understand you want issues that are children under Epics in the results set.

2a. It seems that you want child issues that are "not done", correct?

3. You have criteria for Watcher and Assignee in your JQL.

3a. How do you want these to be applied to the child issues, if at all?

3b. How do you want these applied to the Epics, if at all?

[Feldunoob]

1. Do you want Epics in the result set?
List of watched Epics always remains, even if there is no associated task link, that's ok.

1a. If yes, do you want Epics of only a certain status in the result set?
Epics are listed by watchers, and i am watching them, so it remains visible at all times. This is fine.

1b. And, are there any other conditions you want to apply directly to the selection of the Epic issues.
No.

2. I understand you want issues that are children under Epics in the results set.
I already see tasks links that are done in this format OTO-45554 and ongoing ones in this format OTO-45544 next to the watched Epics.

2a. It seems that you want child issues that are "not done", correct?
I want to see only Tasks that are not in "Done" status.

3. You have criteria for Watcher and Assignee in your JQL.
Yes.

3a. How do you want these to be applied to the child issues, if at all?
Not applied.

3b. How do you want these applied to the Epics, if at all?
Applied on Epics for watchers.

[Trudy Claspill]

Hello @Feldunoob 

I believe then the JQL you need is

project = OTO AND ((statusCategory != Done AND issuetype != Epic) OR (watcher = currentUser() AND issuetype = Epic))

That JQL will include in its results:

1. Epics in the OTO project where the current user is a watcher, and

2. All non-Epics in the OTO project where the status of the issue is not part of the Done Status Category