Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to search for issues for which the created and updated date (not hours) is the same ?

JulienFritsch
Contributor
July 18, 2018

We would like to search for issues that have the same created and updated date, but we can't find a good and generic way to do: createdDate = updatedDate.

 

We can use tricks like "project = MDEV and updatedDate >= -8h and createdDate >= -8h" but it's not good enough since it cannot be used to find issues much further in time.

 

Apparently, the addition plugin such as: https://www.j-tricks.com/jql-tricks-plugin.html, don't help.

 

I guess, that it's possible with a custom field, but I wanted a more simple & light solution.

1 answer

1 accepted

0 votes
Answer accepted
Payne
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 18, 2018

It can be accomplished using the ScriptRunner add-on with the following JQL:

issueFunction in dateCompare("", "created = updated")

JulienFritsch
Contributor
August 13, 2018

Thank you, I will try this.

Payne
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 14, 2018

@JulienFritsch - 

In hindsight, I see that I was too quick to recommend this, as it checks for equality not only on the date component, but also the time component, which you stated you do NOT want to check. Sorry about that. I'm not sure offhand how to limit the check just to the date.

-Payne

Suggest an answer

Log in or Sign up to answer