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

[Jack Brickey · Accepted solution]

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

[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]

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 ! 

[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.