JQL Query Questions

[Geoff Schipske]

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!

[Alex Koxaras -Relational- · Accepted solution]

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]

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

@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]

@Alex Koxaras -Relational-  Thanks again!!