How do I create a JQL that searches for all projects that have the word ABC in the project key?
for example: I have the following projects on my instance:
ABC1ABC2ABC3DDD1DDD2DDD3POL1POL2POL3
How do I search for only ABC projects?
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
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.
Thanks for your help.
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.
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
It looks like you're new here. Sign in or register to get started.
