Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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 Cloud

Confluence Bingo Round 3!

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....

41 views 0 3
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