Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Query: Updated bugs assigned to user in last 15 minutes

I have the following use case:

A customer assigns all Bugs to my user account. But I want the team to get an email each time a bug is assigned to me, or when a bug that is already assigned to me is updated.

I have written the following filter:
issuetype = Bug AND updated >= -15m AND assignee in (myUser)

This is working great for issues that are already assigned to me and then updated.
But sometimes, the customer completely describes a bug and then assigns it to me as the last action.
In this case, the filter doesn't work. Probably because the issue was not assigned to me when it was updated. BUT it is assigned to me after the last update.

How can I rewrite this query to include these issues?

1 answer

1 vote
Alex Koxaras Community Leader Dec 15, 2021

Hi @Dominik Damerow and welcome to the community!

If you want to include also the issues that are assigned to you, why don't you rewrite your JQL like:

issuetype = Bug AND (updated >= -15m AND assignee in (myUser)) OR assignee = myUser

As far as I can see, this would lead to a different result.
It would also include all issues assigned to me at any time.
Which means the mail would include a huge number of issues of no relevance.

assignee in (myUser)

differ from
assignee = myUser
in the results? I would not expect it to differ, since it is a sql like query language.

Alex Koxaras Community Leader Dec 15, 2021

So what are your business requirements?

  1. See all bugs assigned to you and updated within the last 15 minutes
  2. ?

My requirements are:

1. See all bugs that were assigned to me - and have been updated in the last 15 minutes

2. See all bugs that were updated in the last 15 minutes by changing the assignee to me

My query fulfills requirement 1, but does not fulfill requirement 2.

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you