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.
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"?
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>)
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...
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