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

[Michael Thompson · Accepted solution]

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

[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