JQL rquery for not displaying stories with status "cancelled" and which are released in Structure

Question

Hello Community,

In my structure, I have added a filter not to display Epics, which are completed, cancelled and implemented, at current level.

JQL I have used = status not in (completed, cancelled, implemented) -- it is working fine :)

Now along with above filter I want stories, only with status "cancelled" and "which are released", should also not display. I have tried extending it to level 2 but it is not giving desired result :(

Could you please help with JQL?

Thanks in advance!

Yashveer

Jack Brickey · Answer

So what are you or are you not seeing with the above query? I suspect the flaw in the above is that it does not honor the association between the epic and the stories. TBH, Assuming I understand your goal, I’m not sure you can accomplish OOTB and would point you to an app like Scriptrunner or Power Scripts.

Yashveer · Answer

Hello Jack,

Thanks for your response!

In my structure where all issue types are available. I want to add a filter by which I should be able to see

1. All EPICS with status != Completed, Cancelled, Implemented. at current level (Level 1)

2. All stories under EPICS with status != Cancelled and fixVersion is not released. at child level (Level 2)

3. And all respective issuetypes (sub-tasks, test cases and defects) linked to stories available. at sub-child level (Level 3)

To start with, I have tried with below JQL (suggestions provided by you and Petterson) but could not get desired result :(

(issuetype = epic AND status not in (Completed, Cancelled, Implemented)) or (issuetype = Story and status != Cancelled AND fixVersion not in (releasedVersions()))

Cheers!

Yashveer

Yashveer · Answer

Hello Petterson,

Thanks for your response!

I have tried with below JQL but not able to achieve the desired result :(

(issuetype = epic AND status not in (Completed, Cancelled, Implemented)) or (issuetype = Story and status != Cancelled AND fixVersion not in (releasedVersions()))

Cheers!

Yashveer