Jira filter excluding status change from certain users

[adrian]

i am trying to search for issues submitted during a certain period but exclude those that have been modified by certain users. so far i've got this filter but it does not work

project = iso AND issuetype = Bug AND Status changed from "Ready to Test" to (Open, Closed) after startOfDay() AND Source in (Core, Dev) AND updated >= -10h AND (Not status changed BY x@abc.com) AND (NOT status changed BY y@abc.com)

any ideeas? :(

[Alexey Matveev · Accepted solution]

Hello,

Your JQL query looks correct. What is not working?

[adrian]

It is not excluding the issues that have been changed by the given email addresses 

[Alexey Matveev]

You should provide users after the By keyword, not email addresses. 

[adrian]

Tried with names, still got the same issue. The bugs list is not filtered accordingly. 

[Alexey Matveev]

I just tried this JQL:

 (Not status changed BY myuser) and it worked correctly for me. It showed only issues where myuser never changed the issue status.

I tried it on Cloud

[adrian]

Yes, worked for me also (even with emails) i just had to add quotes before and after email address and correct a typo where i used NTO instead of NOT. 

Thanks a lot !

[Alexey Matveev]

You are welcome!

If you think that my answer helped you, kindly mark my asnwer as accepted.