nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Why does my filter by resolved fail?

Stefan Meier_iyjvda

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! ;-)

Accepted answers

Gezim Shehu [Communardo]

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_iyjvda

I found the following filter to be working:

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

All comments

Gezim Shehu [Communardo]

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.

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

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_iyjvda

I get all done issues.

Where do I see if the set resolution is specified?

Stefan Meier_iyjvda

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

Stefan Meier_iyjvda

I found the following filter to be working:

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

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