Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Search for terms across all issues/projects to just see list of matching projects

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.

 

Thanks, Kirill

2 answers

0 votes
Ignacio Pulgar Community Leader Mar 21, 2019

Hi Kirill,

Try this:

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.

Hello Kirill,

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:

<your_jira_url>/rest/api/2/project

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:

Working with search results

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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Introducing External Collaboration for Confluence

We’re excited to introduce external collaboration for Confluence, now available in early access. It is available to preview for Confluence Cloud Premium and Enterprise customers. (If you're not on ...

208 views 0 8
Read article

Community Events

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

Events near you