I need to write a JQL ticket to get the results of tickets which has no updates in the last 4 hours.
project in ("ABC") AND status not in (Closed, Cancelled) AND priority in (Blocker, Critical) AND updated > -4h AND type not in ("Deployment Request", "Operational Request") ORDER BY updated DESC
Please help me if this query is correct?
Or it should be
project in ("ABC") AND status not in (Closed, Cancelled) AND priority in (Blocker, Critical) AND updated < -4h AND type not in ("Deployment Request", "Operational Request") ORDER BY updated DESC
Hi Vinod,
"updated > -4h" will show you issues that have been updated within the last 4 hours.
"updated < -4h" whill show you issues that do not have been updated within those 4 hours.
Please be noted there is meanwhile an accepted/recommended answer:
https://community.atlassian.com/t5/Jira-questions/Need-to-get-results-of-tickets-not-updated-in-the-past-4-hours/qaq-p/1542576
It looks like this has been a double post.
Cheers,
Daniel
Hi @Vinod Madhappan ,
Jira's built in capabilities are enough for this requirement. You don't need an add-on.
You first query is correct.
project in ("ABC") AND status not in (Closed, Cancelled) AND priority in (Blocker, Critical) AND updated <= -4h AND type not in ("Deployment Request", "Operational Request") ORDER BY updated DESC
Cheers,
Gökçe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Optionally, you can try SLA Time and Report app. It let you set a timer, time limits and automate actions for exceeded issues. Add-on lets you select issues by any issue field parameters: project, status, priority, assignee, etc.
Best Regards
Zoryana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
can someone help me with providing the right answer asap
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Vinod Madhappan ,
Your query is correct. You don't need an additional tool for this.
project in ("ABC") AND status not in (Closed, Cancelled) AND priority in (Blocker, Critical) AND updated <= -4h AND type not in ("Deployment Request", "Operational Request") ORDER BY updated DESC
Cheers,
Gökçe
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.