I have multiple projects in my Jira instance. I would like to search for a few words ("reuters", "exegy", "mbpipe") across all issues in all projects for the past year to find just the list of matching projects.
So if the term "reuters" is found in 10 Jiras for project 1, 15 in project 2, 5 in project 3 ideally I want to see only a list of 3 projects: 1, 2, 3.
Bonus points for possibility to variate terms: "mbpipe" and "bpipe" are the same, for example.
More bonus points if there is a widget in Jira Dashboard that can dynamically and visually display the project lists for each term.
1. Create and save a filter like this one:
text ~ reuters OR text ~ exegy OR text ~ mbpipe OR text ~ bpipe
2. Add the Issue Statistics gadget to a board, set to be based on Project, and fed by the newly created filter.
Repeat both steps for each term, changing the filter accordingly in order to have distinct gadgets for each of them.
Hope it helps.
I understand that you would like to display a projects list of the issues returned by a filter. Is that correct?
By default, the JQL filter functionality of JIRA is configured to return issues and not any other data as projects, however, there are some options you can use to properly get this information:
1 - Use JIRA REST API
The REST endpoint is:
More info to build the query can be found here: https://docs.atlassian.com/jira/REST/latest/#d2e2046
2 - Export your issues to CSV and use an external app (Excel, LibreOffice, etc) to get in the project column all the unique results returned.
You can check the Exporting your search results sections of the documentation below to know how you can export your filter using CSV:
Although there is no gadget that would return a project list from a JQL filter, you can check for issues which contains a wild-card match for a word using the * parameter:
text ~ "bpipe*"
Let me know if this information helps.
That’s right! Grandma’s back at it again, and this time she’s brought all her friends. In honor of Team '21, this Bingo round is dedicated to all things team-related, and the prizes are no exception....
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events