Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to write a JQL query that pulls all tasks with an Epic that contains a particular phrase? Edited

I am trying to write JQL query to use as a filter in the Smartsheet-Jira Connector that will find all tasks (all issue types) across multiple workspaces/Jira boards that contain the word "Exchange".  So far the query:  "Epic name" ~ exchange is the closest I have gotten, however it only pulls up epics and not the tasks within the Epic and trying to include the Issue Type in the formula as well does not work.

1 answer

Hello @Neda Hadisadegh 

Welcome to the community.

Can you clarify your criteria?

You said find all issues of all issue types, that contain the word "Exchange". Which issue fields do you want to check; Summary, Epic Name, Description, ...?

You said you got an Epic back that had the word in the Epic Name, but you didn't get the tasks within the Epic. Do you want all the tasks in the Epic, even if those tasks do not contain the word "Exchange"?

Are you really trying to get all and only the issues that have the word "Exchange", or are you trying to get all the issues with the word "Exchange", plus the child issues of any Epics in that list even if the child issues don't have the word "Exchange"?

Hi @Trudy Claspill

Thank you for your help... no I'm not trying to pull all issues with the word exchange, I am trying to pull Epics with "Exchange" in the Epic Name and all issues within those Epics... does that make more sense?

JIRA Cloud does not natively support subqueries. If it did you might be able to do something like

"Epic Link" in (" 'Epic Name' ~ 'Exchange' ")

... where the criteria in the parentheses would give you a set of Epics, and outside the parentheses would give you all the child issues of all those Epics.

There are a variety of apps in the Marketplace that extend the JQL functionality in various ways that could offer you a solution; either a generic subquery option of a specific function that could help you get the data. If adding an app is an option for you, try searching the Market place for JQL extensions.

If adding an app is not an option, you will have to to the query in two stages. You will have to create the filter to get the Epics, export the results to get a list of the Epic Issue IDs, and then plug that comma-separated list into a second query:

"Epic Link" in (<comma separated list of Epic Issue IDs>)

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

167 views 6 7
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you