Filtered tasks are not appeared in the JQL

Shailender Kumar

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

Walter Buggenhout

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!