You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am looking for all issues made for projects started with ABCD. I am familiar with SQL queries where you can work with "*" and "???".
What are the possibilities with JQL?
Besides the previous correct answers, you may also want to create a Project Category named ABCD and add all ABCD projects into it.
That way you'd be able to query issues from all ABCD projects at once with this simple JQL:
category = ABCD
project = XOXO AND text~ABCD
successfully almost daily. I get a list of everything beginning with ABCD. It only works in the Advanced view and I strip out other filters, but that doesn't mean they won't work. I just don't want to confuse Jira.
I also sort by Summary if I have a relatively small set to scroll through.
At this moment, there is no straightforward way to put a wildcard in the project name, like ABC* and have Jira look in both ABCD and ABCC projects. There might be an add-on that provides this functionality and I found feature request here regarding this.
As a workaround, you can create a JQL like
project in (ABCD, ABDD)
(make sure you specify all the projects)
And save it as a filter, named ABC* Then do a JQL like
filter = ABC* AND issuetype = Bug
This will show all bugs in projects ABCD and ABDD.
Jira has in general a big lack of being able to add informations on project level and building JQL filters with it.
On Jira Server we have the app Metadata where we could add various informations to a project and build this informations into JQL.
Unfortunately there is nothing similar available in the cloud..
A big large minus for the cloud!
Claudiu mentioned that there may be a way via an add-on, and there is ... ScriptRunner offers a projectMatch() function that can be used like this:
You can use this addon if you are using Jira server: https://marketplace.atlassian.com/apps/1218367/jql-booster-pack?hosting=server&tab=overview
Some of examples:
• Find issues in projects that ther name starts with 'LATAM':
|project IN projectMatches("LATAM.*")|
• Find issues in project that their name contains 'Academy':
|project IN projectMatches(".*Academy.*")|
• Find issues in projects that ther name ends with 'EMEA':
|project IN projectMatches(".*EMEA")|
• Find issues in projects whose category starts with 'LATAM':
|category IN categoryMatches("LATAM.*")|
• Find issues in projects whose category contains 'Development':
|category IN categoryMatches(".*Development.*")|
• Find issues in projects whose category ends with 'EMEA':
|category IN categoryMatches(".*EMEA")|