How to write query to get a list of issue having status changed after a certain date?

[manikanta ch]

How to write a query to get a list of issues having status changed after a certain date(custom date field at the issue)?

Example - 

Project=xyz and status was in "x" AFTER "custom date field"

Thanks in advance,

CH

[Walter Buggenhout]

Hi @manikanta ch ,

I don't see an immediate way to pull that off with JQL. If you know the date, you could write a fairly simple query like this:

Project = xyz AND Status CHANGED AFTER StartOfWeek()

where StartOfWeek() may just as well be any other date.

I am trying to get my head around what you are trying to achieve. The best I an come up with, is that your are trying to assess whether a certain action has taken place before or after the foreseen target date.

So if that may be your use case, you could simplify your search by adding a postfunction to the transition that you are tracking and conditionally setting e.g. a custom field on the issue with either your transition date or just an indication that the issue was delivered on time or not.

Depending on your implementation, you could perform a simple search on that marker (on time or not). Or if you have Scriptrunner, you could then search with a DateCompare function to retrieve the relevant issues. e.g:

issueFunction in dateCompare("", "resolutionDate > dueDate")

Quite a few assumptions there, but still hope this helps!

[Jack Nolddor _Sweet Bananas_]

Hi ya!

As far as i know, you cannot use a custom datetime field on AFTER operator just relative amounts like -1d and so on...

Sorry.