Filter out tickets not updated by assignee but are assigned to that person - within a time range

[Jaroslav Melich]

Hello,

I am trying to create a JQL, which would show me all the issues which were updated by anyone other than me but are assigned to me. 

What I got so far, but this is not working: 

issuekey NOT IN updatedBy("my_email_address") AND assignee = currentUser() AND updated >= -48h

But as soon as I change the issuekey from NOT IN to IN it works but the other way than expected, as I specifically want to exclude all the last updates which were done by me in the tickets. 

Also when I remove the assignee. then indeed it shows me all the tickets which were not updated by me in the last 48 hour.

But for some reason the combination of the two is not working. 

Thank you for any help.

[Anthony Morais]

Hi @Jaroslav Melich 

Welcome to the Atlassian Community!!!

Make the JQL below and it will work.

assignee = currentUser() AND updated >= -48h AND issuekey NOT IN updatedBy("my_email_address")

I hope it helps!

Regards,

Anthony

[Jaroslav Melich]

Thanks Anthony,

I still could not get the results I wanted, until I realized that updatedBy() is not taking into consideration new comments as updates. 

In the history of a given task I have a update by me in last 48 hours but there was a new comment from my colleague in the last 20 hours - so I would expect this to show since there was new comment but the "AND issuekey NOT IN updatedBy("my_email_address")" is unfortunately not taking into consideration new comments.

Do you might know a JQL query that shows the tasks which have new comments on them?

[Yuliia_Borivets__SaaSJet_]

Hi @Jaroslav Melich 

As a workaround, you can try Issue History for Jira app from my team. It records all changes made to the required issue list. You can add any issue field where you want to see changes (comments, description, etc.)

For your case:

1. Choose the assignee in the filter
2. Set dates you need with a flexible date picker
3. Select columns where you want to see changes and add them to the table

You can check if it works for you with a free 30-day trial.