Making a JQL filter, with issues and epics

[Jon]

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 

[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]

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

[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]

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]

yeah, I have cloud verison. does that matter? 

[Jon]

and then I would like it to show the epic name, as you can see the column comes up blank. probably cause the issue is not an epic per se but the epic its linked to does have these fields which is what I would want to show. 

[Mohamed Benziane]

I'm not an expert but i don't think it matter. When you click on choose columns yon don't have the epic link option ?

[Jon]

that's correct. 

[Mohamed Benziane]

You will only be able to see value of fields or customfield that's exists in your screen issues and not the epic.

[Jon]

so then script runner will not help me in achieving what I'm trying to do or it would take programming beyond what a novice could handle? 

[Mohamed Benziane]

If you want to retrieve data from the epic and the linked issues i guess you will need some work with API and python or other language.

[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

[Jon]

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]

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]

Try this:

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

issueFunction in issuesInEpics(status=open) 

[Jon]

does this jql look proper? 

issuesInEpics(status=open)

It doesn't work but in theory if it did I would be able to work out the other pieces. 

[Mohamed Benziane]

Try to use double quote like this

IssueInEpics("status = open")

Instead of status=open who can use an another filter if you want.

[Jon]

still doesn't work. 

[Mohamed Benziane]

Try:

IssueFunction IssueInEpics("status = open")