Hello,
I'm hoping someone on the community can help with this. I'm trying to write a filter using ScriptRunner JQL functions but I've hit a roadblock.
Here's my current filter
project = AEM AND issuetype != Initiative AND status != Unreviewed OR status != Unreviewed AND issueFunction in epicsOf("project = AEM and issuetype != Initiative AND status != Unreviewed") ORDER BY Rank ASC
What I can't seem to take out of this filter are any issues linked to Epics in which the status of the Epic is "Unreviewed". I don't want those to show up. Any ideas for what I could do here?
(project = AEM AND issuetype != Initiative AND status != Unreviewed) OR (status != Unreviewed AND issueFunction in epicsOf("project = AEM and issuetype != Initiative AND status != Unreviewed")) ORDER BY Rank ASC
Try adding parenthesis to clarify the order of operations. I took a guess at the order you're going for. Set A OR Set B. Also, consider adding/substituting ...
AND issueFunction in issuesInEpics("project = AEM AND status != Unreviewed")
Which should search for issues in AEM, Unreviewed Epics. My logic may be off because I don't know know your project like you do, but I suspect that issuesInEpics function may help you.
https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html
Thanks for the reply Kyle. The parenthesis didn't change anything and the "issuesinEpics" function doesn't help either. Stories under "Unreviewed" Epics are still showing up.
I used the "epicsOf" function because I wanted to be able to pull in linked Epics that may exist in another Jira Project.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.