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

Making a JQL filter, with issues and epics

Jon_4n6t23

Can anyone help me set up a JQL filter correctly. What I'm trying to do is include all issues of a certain type but exclude issues that have linked to an epic of a certain type.

Specifically, the epic are either open or closed. the issues have names of open, assigned, loaded, sailed, or paid. I want my filter to include all issues (open, assigned, loaded, sailed and paid) but exclude the issue if its linked to an epic that is closed.

thanks

jon

Accepted answers

All comments

Pete Singleton

To do this, you need the ScriptRunner plugin. This allows you more powerful queries using the "issueFunction". We have a query which does pretty similar to what you want, which is:

issueFunction in issuesInEpics("project = RIM and resolution = unresolved")

More info here:

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html

Mohamed Benziane

Hello Jon,

I think you will have to use a plugin like scriptrunner that allow you to have more keyword to make you jql query like

hasSubtask(),

issueFunction

And many more

You can look and find more informations here:

https://community.atlassian.com/t5/Jira-questions/Filter-Subtasks-Where-Parent-Task-Is-a-Certain-Issue-Type/qaq-p/525337

https://community.atlassian.com/t5/Jira-questions/How-to-find-stories-in-a-set-of-epics/qaq-p/455734

Hope this helps

Regards

Jon_4n6t23

I have script runner installed now. what do I have to do so that it works when setting up the JQL filters?

Mohamed Benziane

Nothing, when you go to search for issue enter the keyword you want like issuefunction and you will be able to see it in the suggestion:

Jon_4n6t23

this doesn't have a subtask. I have it configured as issues and epics. Each issue is linked to an epic. an Epic has different statuses. when I added script runner I see I can make a JQL but I notice it doesn't let me add the column epic link to the screen. Nor does it allow me to add in epic status of the epic the particular issues is linked to.

do you have any guideance?

Mohamed Benziane

Do you mean this column ?

Jon_4n6t23

yeah, I have cloud verison. does that matter?

Jon_4n6t23

this is a current JQL I have is below, which allows me to search by Epic Link but not that epic links status.

issuetype = Booking AND status in (Assigned, Loaded, "Not Loaded", Open, Paid, Sailed) AND "Epic Link" in (ES-9, ES-10)

but I would like to modify it to something along the lines of :

issuetype = Booking AND status in (Assigned, Loaded, "Not Loaded", Open, Paid, Sailed) AND "Epic Link" STATUS = OPEN

Do you have any ideas how to word that?

Mohamed Benziane

Or you can copy the value you want from epic to linked issue and show it on your issueview using the correct columns

Jon_4n6t23

sorry not sure if I understand this but the filter is something that is changing all the time so we wouldn't be able to put a hard number in there.

Mohamed Benziane

The value copy can be done automaticaly with scriptrunner

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud