Forums

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

JQL Query Questions

Geoff Schipske January 21, 2023

Hey, Atlassian Community - Can you help with these JQL Questions?

1: Does anyone know how to search for active issues that haven't been updated in more than 7 days except by one user? The example would be a PM adding labels to a bunch of tickets or pings for updates but otherwise, the ticket hasn't been updated by engineers or anyone but that person.

Here is what I have so far :   

project in (ABC, DEF, JKL) AND updatedDate <= -7d AND status not in ("To Do", Canceled, Closed, Declined, Done, Resolved, "Will Not Fix", "Will Not Implement") ORDER BY issuekey 

2: Is there a good JQL repository somewhere?

Thanks in advance!

 

1 answer

1 accepted

1 vote
Answer accepted
Alex Koxaras -Relational-
Community Champion
January 21, 2023

Hi @Geoff Schipske 

About the repository, everything can be found here: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

You can use the "updatedBy" clause.

project in (ABC, DEF, JKL) AND updatedBy = "PM" AND updatedDate <= -7d AND status not in ("To Do", Canceled, Closed, Declined, Done, Resolved, "Will Not Fix", "Will Not Implement") ORDER BY issuekey 

Let me know if that helps.

Geoff Schipske January 22, 2023

Hi @Alex Koxaras -Relational- 

 

Thanks for the reply! You got me on the right track! The below seems to be working to differential tickets updated by me with in a year but other specific users but its pretty messy. Any idea if its possible to consolidate the issuekey not in updatedby statements?

labels != DSIF_FL AND project in (ABC, DEF, JKL) AND (issuekey in updatedby (geoff.schipske, -365D) AND issuekey not in updatedby ("User1",-7D) AND 
issuekey not in updatedby ("User 2") AND issuekey not in updatedby ("User3",-7D) OR updated <= -7D) AND status not in ("To Do", Canceled, Closed, Declined, Done, Resolved, "Will Not Fix", "Will Not Implement") ORDER BY issuekey
Alex Koxaras -Relational-
Community Champion
January 23, 2023

@Geoff Schipske 

I don't think that you can consolidate them to be honest. If your filter works, then leave it as is.

Geoff Schipske January 23, 2023

@Alex Koxaras -Relational-  Thanks again!!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events