The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)
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
Comments for this post are closed
Community moderators have prevented the ability to post new answers.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.