Can filter criteria omit Jira where the person who did the last update is currentUser()?

[robjones3008@yahoo.co.uk]

Due to how our company use Jira, emails for support staff who are Reporters or Watchers of a Jira that has been updated are sent to the 1st Tier team who add the comment to the support call and then the support system notifies the support analyst that the support call has been updated.

However, human error means that this does not work correctly, so the support analyst Reporter/Watcher does not get to know about the update of the Jira.

So I created a Filter that I regularly use with the following search criteria to return any Jira updated within the last week where I am the Reporter or a Watcher

(reporter = currentUser() OR watcher = currentUser()) AND updated >= -1w ORDER BY updated DESC

Unfortunately, this includes all the updates that I did myself.

Is there any way of excluding Jira where the person who did the last update is currentUser()?

[Ste Wright]

Hi robjones3008@yahoo.co.uk

Do you want to specify who the last updated was (i.e not yourself)? Or do you want the search to ignore updates you made as part of the search?

The former is possible but you'd need a JQL enhancer like Scriptrunner to achieve this - then you could use...

issueFunction not in lastUpdated("by currentuser()")

...to show issues where you weren't the last one to provide an update.

The latter I haven't seen done before - I'm not sure it's possible to exclude from a search a user's updates in that manner.

Ste

[Tessa Tuteleers]

Beat me to the punch :) 

[Bill Sheboy]

Hi robjones3008@yahoo.co.uk   Welcome to the community!

Others have suggested add-ons for helping solve your question.  If your company wants this type of filtering without add-ons, please consider reviewing and voting for this enhancement.  Thanks!

Add missing, SQL features to filters

https://jira.atlassian.com/browse/JSWCLOUD-18477

Best regards,

Bill

[Tessa Tuteleers]

Hey Bill, 

Native would indeed be so much better!! 

Is there a feature request for Server as well? Since Rob seems to be on server and the request is for cloud. 

Kind regards, 

Tessa

[Bill Sheboy]

Hi Tessa,

I missed Rob was on server; my bad.  If there is a desire for this enhancement in the server version, please consider creating one and linking the suggestions.  Thank you!

Best regards,

Bill

[Tessa Tuteleers]

Hi Rob, 

You can find a lot of requests about this online. Sadly, it is just not possible with native JIRA. 

However, as a solution partner we advice all our customers to add Scriptrunner for JIRA to their stack, as it is super useful and we use it on a daily basis. 

Is you should have Scriprunner on the instance, you can use their own JQL function and add it to your provided JQL: 

(reporter = currentUser() OR watcher = currentUser()) AND updated >= -1w AND issueFunction not in lastUpdated("by currentUser()") 

-> this eliminates all issues where the logged in user did the last update. Update being 

• edits

• state changes

• adding/removing links, labels etc

• commenting) 

Hope this helps! 

Tessa