problem with query to find all stories in epics

Hi...I am following the steps found in the scriptrunner doc here https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html but when I try to do issuesInEpics("project = DFWTEAM2") I get the following error:

Error in the JQL Query: Expecting operator but got '('. The valid operators are '=', '!=', '<', '>', '<=', '>=', '~', '!~', 'IN', 'NOT IN', 'IS' and 'IS NOT'. (line 1, character 14)

 

what am I missing?

Thank you for your assistance

 

1 answer

1 accepted

This widget could not be displayed.

The rest of the clause?  You seem to be missing "issueFunction in" on the beginning of that.

Hi Nic...thank you for your reply...I was trying to follow the steps under the More Complex Examples section :

More Complex Examples

Find all the stories in an epic, and all their subtasks. With these complex queries it helps to break them down into pieces, so the first step is to find the stories of the epics in a particular project, let’s say the JRA project.

issuesInEpics("project = JRA")

Now save that as a filter, called for example, Stories in Epic.

 

I guess I just need to save the filter like that (without actually executing it) since it will be used later on as part of the more complex filter....thank you for your quick assistance.

Another quick question though...is there a way to find all stories in epics in my instance (without restricting it by projects or status or any other criteria)

 

Thank you

No, you need to use the simple examples to form a valid clause first.  The advanced line you're looking at is different to all the other usages, and it looks like a mistake in the doc to me, as it doesn't work.

You could try a clause that is always going to return everything like "issue type is not empty"

got it...thank you Nic

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

143 views 1 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you