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; } } }

Help with JQL. Results not as expected.

Paul Stansberry

Hello All -

I'm trying to write a JQL statement that will gather stale issues across two projects we have running. The problem is that I'm getting issues in the results that aren't stale. I'm defining stale as an issue that has remained in it's current status for more than 5 days.

Here's what I wrote:

(project = SCOPE AND "Epic Link" in (SCOPE-1701, SCOPE-2322) OR project = GCPIT) AND STATUS in ("Development Complete", "In Progress", "ON GCP INT", Testing) AND Flagged is EMPTY AND STATUS changed before -120h ORDER BY Rank ASC

I'm getting 12 issues returned, but when I check each individual issue returned, several have transitioned within the past 5 days. I have written this query six-ways-from-Sunday and get invalid issues in it no matter what I do.

What am I missing here?

Accepted answers

edwin vasquez_f9df79

Try this. Let me know if it works.

(project = SCOPE AND "Epic Link" in (SCOPE-1701, SCOPE-2322) OR project = GCPIT) AND STATUS in ("Development Complete", "In Progress", "ON GCP INT", Testing) AND Flagged is EMPTY AND NOT STATUS changed during (-120h, now()) ORDER BY Rank ASC

All comments

edwin vasquez_f9df79

Try this. Let me know if it works.

(project = SCOPE AND "Epic Link" in (SCOPE-1701, SCOPE-2322) OR project = GCPIT) AND STATUS in ("Development Complete", "In Progress", "ON GCP INT", Testing) AND Flagged is EMPTY AND NOT STATUS changed during (-120h, now()) ORDER BY Rank ASC

Ignacio Pulgar

Well done, edwin! This is a correct answer.

Just for mere syntax simplicity, I'd use this last part instead:

...AND NOT status changed after -5d

which is just a little bit shorter. But your answer is absolutely correct and will work perfectly.

Regards

edwin vasquez_f9df79

Awesome! Thanks for the feedback. 🙂

edwin vasquez_f9df79

Paul,

Did this resolve your issue? If so, please mark as answered. :-)

Paul Stansberry

Hi @edwin vasquez and @Ignacio Pulgar - Thanks for your feedback. I think this is an improvement, and this does seem to have eliminated issues from the results that were transitioned within the past 5 days as I was looking for.

However, now I can identify issues that were transitioned MORE than 5 days ago that _should_ be included in these results, but are not. And I'm not sure why that would be.

Here's an example:

There are more than just the above example. I can see several cards that I expect to appear in the "Stalled Tasks" section. I can't for the life of me figure out why these cards aren't showing in the correct section of the Kanban board.

Paul Stansberry

It did! Thanks. I have marked the answer as accepted.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql