How to query & get a list of multiple projects based on similarities in project name or key?

[Deleted user]

I have multiple projects in my instance of JIRA, some of which are active, some are not. Is there a way (either through JQL or the API) to query a list of all projects based on a common word or string of characters in the project name or key?

For example, if I have a lot of projects whose name contains the word 'Test' and/or the Key contains the characters 'TST' is there a way for me to query all of those projects to view which have seen activity in the last 90 days?

[Bharath Kumar Kappala · Accepted solution]

hi @[deleted] 

You can just use the filter "updatedDate >= -90d" this would give you the list of all the tickets which got updated in the last 90 days.

Then you can save that filter and go to your dashboard create a test dashboard and add a gadget called Issue Statistics then add the filter to the gadget (using the Statistic types and Project) this will give you the list of all the projects that are updated in the last 90 days its tricky but definitely works I use it all the time.

Hope this works!

[Jack Nolddor _Sweet Bananas_]

You can enhance the above query by using projectMatches() jql function provided by JQL Booster Pack third-party app to filter issues created under projects containing the word 'Test' name, this way:

project IN projectMatches(".*Test.*") AND updatedDate >= -90d

Regards