How to search for all projects that contain the word ABC in the key.

[Jovânio Sousa Morais Junior]

How do I create a JQL that searches for all projects that have the word ABC in the project key?

[Mayuresh Kamble]

Hi @Jovânio Sousa Morais Junior ,

To search for the projects with the key containing specific word ex. "ABC" you would need to explicitly mention the project keys in the JQL 

project in (ABC1, ABC2, ABC3, ...)

You cannot search for the projects directly with a jql that can return all the projects having a specific word in their project key.

Regards,
Mayuresh

[Jovânio Sousa Morais Junior]

Thanks for your help.

[Hannes Obweger - JXL for Jira]

Hi @Jovânio Sousa Morais Junior

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called smart columns that aren’t natively available, including the project key.

This is how it looks in action:

As you can see above, you can easily sort and filter by your issues' project keys, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,

Best,

Hannes

[Alex Koxaras _Relational_]

Hi @Jovânio Sousa Morais Junior 

You could search via the project list:

OR

You could try and use smart values inside an automation with condition field set to contains.

[John Funk]

Hi Jovânio - Welcome to the Atlassian Community!

If you are not already a specific project Category for those projects, I would create a Category specific for them and attach that Category to the project. Then you can easily query on the Project Category. 

[Jovânio Sousa Morais Junior]

for example: I have the following projects on my instance:

ABC1
ABC2
ABC3
DDD1
DDD2
DDD3
POL1
POL2
POL3

How do I search for only ABC projects?