How do I show in a query when a change was made?

[Ocie Mitchell]

I am trying to build a query to list the items I have moved into a "ready for QA" state.  So far, I have:

status changed to "ready for qa" by <userid>

I can add after -7d to restrict this to just the items I moved to that state in the last week, but what I'd really like is to have another "synthetic" column that gives 'time when status changed to "ready for qa" by <userid>'.  I can't just look at the "updated" field, because other users could have updated the issue after me.  I want to see the time of the specific change that was made by me.

[Ignacio Pulgar]

Built-in JQL doesn't allow to get what you want directly.

As a workaround, I think (never done myself) you can:

1. create a custom field of an appropriate type for managing dates
2. set the current date to that custom field by adding a post function to all transitions to the status 'ready for QA'
3. include your custom field to be shown as a column in your search results

Please, let me know if that approach works.