Query: Updated bugs assigned to user in last 15 minutes

Question

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?

Dominik Damerow · Answer

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.

Alex Koxaras -Relational- · Answer

So what are your business requirements?

* See all bugs assigned to you and updated within the last 15 minutes
* ?

Dominik Damerow · Answer

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.
Does

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.