Hi @Svetlana Mandrosova !
Unfortunately, there's no native way in JQL to query "who was the assignee WHEN the status was X", status WAS and assignee WAS exist independently but you can't combine them temporally.
Workaround for the future (Automation)
You can capture the tester automatically going forward with a simple rule:
- Trigger: Issue transitioned → status = "In Testing"
- Action: Edit issue → set a custom field (e.g., "Tester") =
{{assignee.displayName}}
This will store the person who was assigned at the moment the issue entered "In Testing". From there, you can filter/report on that field normally.
Limitation
This only works prospectively (for new transitions going forward). For historical data, Automation can't help, even if you call the REST API via "Send web request" to get the changelog, the JSON response requires correlating timestamps between status changes and assignee changes, and Automation smart values don't support that kind of conditional logic over nested arrays.
For historical data: ScriptRunner
If you have ScriptRunner installed, this becomes much easier. You can write a Groovy script that:
- Iterates through the issue's changelog
- Finds the entry where status changed to "In Testing"
- Gets the timestamp of that transition
- Finds who was the assignee at that point in time
- Optionally populates a custom field with that value (for bulk backfill)
This gives you full control to backfill the historical data and also run it as a scheduled job or listener going forward.
Hope that helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.