Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL Filter to find clients with no tickets completed over the last x Days?

Ben Weisman
Contributor
October 25, 2022

Hey all,

   I'm trying to locate projects in our JIRA system that have not seen any completed tickets over the last 30 days. Is there way to do this using JQL?

1 answer

1 accepted

3 votes
Answer accepted
Mark Segall
Community Champion
October 25, 2022

Hi @Ben Weisman 

JQL is based upon issues so there would be no way to query in that way.  Without some type of marketplace app, I'd recommend simply executing this:

  1. Execute JQL
    1. resolved >= -30d
  2. Export to csv
  3. Export project listing to csv
  4. Pivot or vlookup against project to find which projects have 0 matches
Ben Weisman
Contributor
October 26, 2022

Thanks @Mark Segall . The issue is going to be that we will have far more than 1,000 results in that time period. Any way around that?

Mark Segall
Community Champion
October 26, 2022

Unfortunately, not without doing some scripting through the API.  

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events