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

JQL I want to filter all issues excepted those was done for 1 month

Laëtitia Montrichard

Hello,

in my JQL, i want to filter all standard issues (Epic and story) excepted to those are done one month ago. Indeed, I will got all issues that the status have not passed to done this current month.

I put this, does not go well:

(statusCategory != Done AND status changed after -30d) AND issuetype in standardIssueTypes()

Thank you for your reply

Accepted answers

Jack Brickey

how about this...

statuscategory != done or status was done after startOfDay(-30)

now this will return any issue not in a done status category as well as any in the DONE status within the last 30d. Please note you cannot use statuscategory with any history operators (e.g. WAS) so you would need to include each "done" status in the above JQL

All comments

Jack Brickey

how about this...

statuscategory != done or status was done after startOfDay(-30)

Laëtitia Montrichard

Hello, I don't want issues with "OR", I don't want issues that are DONE before the last 30 days. And with issuetype in standardIssueTypes()

Jack Brickey

Are you saying that you don't want to include any issues that were created more than 30 days ago and not yet done? You can simply add the standardIssueTypes() to my suggested JQL as below.

statuscategory != done or status was done after startOfDay(-30) and issuetype in standardIssueTypes()

if I'm still missing the mark here please try to be explicit on what you precisely are looking to have returned by the query.

Laëtitia Montrichard

I don't want to include the issues that were passed to status Done more than 30 days ago. For example, I have an issue passed to Done on 25th of March, I don't want to back up this issue.

Moreover, I need only standard issues: EPIC and story, not subtasks.

Jack Brickey

Sorry, there was an error in my original filter. Does this get you closer?

Project =test and (statuscategory != done or status was not done before startOfDay(-30d) and issuetype in standardIssueTypes())

Laëtitia Montrichard

Thanks, that's better !

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud