Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Wildcard search on jira and projects in particular

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?


8 answers

2 accepted

9 votes
Answer accepted
Ignacio Pulgar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Jul 09, 2018

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
0 votes
Answer accepted

I use 

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.

4 votes
Claudiu Lionte
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Jul 09, 2018


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. 


Doing searches over a group of projects with a certain prefix seems like really basic functionality... I'm a tad bit disapointed this is not possible (in a basic way)
Any plans to include this in future updates?

Martin Flury
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Oct 30, 2023

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!

2 votes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Jul 09, 2018

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:



How is this not possible just using a like clause? 

You can use this addon if you are using Jira server:

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

Return all parent Epics with their underlying stories and tasks across all projects with all statuses except Done, close, closed.

Any ideas?

Thanks so far. For now I will use category.

Suggest an answer

Log in or Sign up to answer