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

How to set up advanced JIRA filter for created date less than 30/6/18

Nicole_Glen

Hi All,

Looking for some help on the below query please, it works but when i add in the condition on created date, it doesn't like it. Can anyone advise?

project = ICR AND (labels not in (SmallChange) OR labels is EMPTY) AND Status not in (Closed) ORDER BY created DESC AND created <= 2018-06-30

Thanks

Nicole

Accepted answers

Michael Thompson

Your ORDER BY parameter needs to be the last thing in the filter, like this:

project = ICR AND (labels not in (SmallChange) OR labels is EMPTY) AND Status not in (Closed) AND created <= 2018-06-30 ORDER BY created DESC

All comments

Michael Thompson

Nicole_Glen

Thanks very much it works now

Manuel Bastardo Castellano

project = ICR AND (labels not in (SmallChange) OR labels is EMPTY) AND Status not in (Closed) AND created <=2018-06-30 ORDER BY createdDate