nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

Alex Koxaras -Relational-

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.

All comments

Alex Koxaras -Relational-

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud