Filtered tasks are not appeared in the JQL

Shailender Kumar March 19, 2024

I want to extract the tasks that have been open over the past 30 days through JQL. When I run the query, only few tasks appear in the list.

Project = "Business Excellence" and issuetype = Task and status not in (Done,Closed, Withdrawn) and labels! timesheet and createdDate <= -30d order by created DESC

1 answer

0 votes
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 19, 2024

Hi @Shailender Kumar

There is a typo in the JQL you shared at the labels part. But that would make the filter to fail entirely, so I guess that's a copy/paste glitch here in community.

There may be an issue with issues without any labels being ignored here. Try the following:

Project = "Business Excellence" and issuetype = Task and
status not in (Done,Closed, Withdrawn) and
(labels != timesheet OR labels is empty) and created <= -30d order by created DESC

Hope this helps!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events