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?

[Mohamed Benziane · Accepted solution]

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.