Before operator not working with "updated" field

[Julien GERARD]

Hello guys,

I do not understand why this jql request doesn't work : 

status was not  "Some_Status" before updated

I got this error message : "Date value 'updated' for predicate 'before' is invalid. Valid formats include: 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'yyyy/MM/dd', 'yyyy-MM-dd', or a period format e.g. '-5d', '4w 2d'"

Updated is not a date?

any suggestions?

[Vasiliy Zverev · Accepted solution]

Dear Julien, hi!

In JQL after before it is possible to use fixed dates or specified date functions. 

See more information here: https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-fields-reference-764478339.html 

[Julien GERARD]

Ok but not the updated field as mentioned here https://confluence.atlassian.com/jiracorecloud/advanced-searching-fields-reference-765593716.html#Advancedsearching-fieldsreference-UpdatedUpdatedDateupdatedDateUpdated

This is the documentation for Jiracloud, but I think it's the same behaviour for jira server.

Thanks for the response.

[Fazila Ashraf]

Hi @Julien GERARD

I do not understand why you would want to check on the 'before updated' ?

Won't "Status was not 'some_status'" get you the result you are looking for?

[Julien GERARD]

Hello Fazila,

We got the Riada Notifications Assistant email sender plugin.

With this plugin, I have a notification triggered by the "updated event" of a transition.

In this notification triggered, I want to get the list of issues that WASN'T in the a special status before the last update by a JQL query.

I must admit that is not clean, but I'm still figuring out how to manage this notification.