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; } } }

Operator WAS IN with optional DURING returns the false results

Evgeniy Cherny

Hi,

Try to find all tasks closed by an employee but date filter doesn't work. Such a query displays all the issues closed by the user:

project = CA AND status was Done by a.andrusenko during ("2019/07/09", "2019/07/20") AND assignee != a.andrusenko AND reporter != a.andrusenko

the operator DURING doesn't work (same thing with BEFORE, AFTER).

Are there any fixes?

Accepted answers

Mohamed Benziane

Hi @Evgeniy Cherny

Can you try this

project = "your project" AND status changed TO "your status" DURING ("2019-01-01","2019-02-01")

Hope this helps

All comments

Mohamed Benziane

Hi @Evgeniy Cherny

Can you try this

project = "your project" AND status changed TO "your status" DURING ("2019-01-01","2019-02-01")

Hope this helps

Evgeniy Cherny

Thank you, but I need to see changes by the user. The query works correctly and filters issues in the right way except the time frame. It returns issues for all the time, not that chosen.

And same is for BEFORE, AFTER.

Mohamed Benziane

Hi @Evgeniy Cherny

I tried this one

project = "project" AND status changed to Closed during ("2018/01/01", "2019/02/01") AND assignee != mohamed.benziane AND reporter != mohamed.benziane ORDER BY updated ASC, created DESC

And it works fine. Do you look the updated column ? This query return all issue that was updated to closed during 2018/01/01 and 2019/02/01. So if you look the updated column it will be in your time frame. You can see issue that was open before the 2018/01/01.

Hope this helps

Evgeniy Cherny

Thank you a lot, Mohamed. It helped and seems working fine (just added after 'status changed to Closed by ___USER' to filter the user I need.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-software

jql