How can I use JIRA to take a photo from my issues status in a specific date?

Question

Hey guys, I was wondering if it's possible to do take a photo from my backlog at specific date.

How can I do that? Jira mix things that was not supposed to, like if I search for something like this:

project = NTCCCO AND status was not in (Done, REJECTED) on 2018-07-13

I get issues that were created in the date also I think Jira thinks that if the item didn't exist back then, then it was not in the status I'm searching. See the date 19/07/18 below,

NTCCCO-2119[Regressão] - Relatório Comportamento do Motorista - Sistema não gerar exportáveis

DONE19/07/1819/07/18

If I try to filter with the created field like this:

project = NTCCCO AND status was not in (Done, REJECTED) on 2018-07-13 and created < 2018-07-13

I get this instead, an Issue that was created before my date, but was updated afterwards and now  is DONE

NTCCCO-2002[ Fleet Management ] - Real time information is missing - PROBLEMA ##PB-3666##

DONE12/07/1817/07/18

So, in another words, why JIRA treat an item that wasn't as it was using historic search?

Earl McCutcheon · Answer

Hello Maiko,

The Search is not basing any Criteria off the create date value until you add that paramater in.

when you perform the search :

project = NTCCCO AND status was not in (Done, REJECTED) on 2018-07-13

The JQL is searching first for ALL issue in the noted Project.  Then from that list excluding any issue where the status was not in the Done OR REJECTED on the noted date, this should include any issue created after that day as logically from the data point specified they did not have a value at that time.

You are on the right track of adding in the additional created parameter to exclude all issues created that day or later by passing in the additional logic to look at this new datapoint.

Regards,
Earl