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!
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't think that you can consolidate them to be honest. If your filter works, then leave it as is.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.