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
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.