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 have a simple question :
all our Internal projects start with [INT] in the project name.
for example '[INT] Redesign office'
I want to run a JQL with all issues from non-internal projects. That is : exclude all the projects starting with [INT]. (alternative : all projects that contain the string "[INT]".
It looks like the * wildcard doesn't work for projects....
My best guess was :
project != "^[INT]*"
but no juck with that.
The challenge you describe is the result of storing multiple pieces of information in a single field: a project classification and a project name.
Perhaps consider using the project category feature, to classify the projects, and then JQL could help search on the categories: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields/#Category
This would require some initial work to set the category values before querying.
Hello @Philippe Vlaemminck
Unfortunately there is currently no support for searching for issues based on matching the project name. There is a change request for that here:
Conversely there is no support for searching for issues where the project name does not match.
if you are open to solutions from the Atlassian Marketplace, this would now be easy to do using 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 number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to perform text matching on all issue fields:
JXL supports various logical operators like AND, OR, or NOT; for more sophisticated use cases, you can also use regular expressions.
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,