Why does my filter by resolved fail?

[Stefan Meier]

Hi JIRA experts!!

I have a JIRA project with my own workflows. The final state is done.  Now I try to filter out all isses from the done column that were completed (i.e. moved to done) before today.

I am using the following filter (My Project is PRIV)

project = PRIV AND (resolved >= startofday() OR resolved is EMPTY) ORDER BY priority DESC

I expeted to get only open issues and those that were resolved today. However, I still get issues that were resolved yesterday.

Please find the error! ;-)

[Stefan Meier · Accepted solution]

I found the following filter to be working:

project = PRIV AND NOT (status = Done and updatedDate < startOfDay()) ORDER BY priority DESC

[Gezim Shehu [Communardo] · Accepted solution]

Hi,

Do you specifically get only issues from yesterday?

Since you mentioned you have your "own" workflow, could you check the transition to status Done? Is the set resolution specified.

JQL seems fine.

[Stefan Meier]

I get all done issues.

Where do I see if the set resolution is specified?

[Gezim Shehu [Communardo]]

Sorry for the late reply.

in case you get all done issues you most propably forgot to set the post function.

go to the specific workflow, to the Done transition.

check the post functions. If none is specified for update resolution field add a new one

[Coley Anderson]

Have you tried using status, instead of resolution? Something like:

project = PRIV AND  (status changed to done after startofday() OR resolution is EMPTY)

[Stefan Meier]

no its not working. I am getting all the old issues.

[Jack Brickey]

As Gezim points out "resolved" function operates off of the resolution being set and for sure you should work to have that occur whenever an issue is marked Done.

That said you could try this and I suspect it would work...

project = PRIV AND resolutiondate >= startofday() ORDER BY priority DESC