Search for issues with simultaneous field conditions in the same exact moment in the past

[Isabel Cruz]

I would like to search for issues that meet simultaneously the following conditions in the same exact moment in past time:

- a certain "status" (e.g. reopened);

- a certain "assignee" (e.g. my user).

I tried the following query "status was Reopened and assignee was currentuser()" . This query returned issues that were is status "Reopened" sometime in the workflow (assigned to other users) and that, afterwards or before, were assigned to me (in another status different from "Reopened"). 

Is there an alternative JQL query that ables to return issues that were "Reopened" and "assigned to me" at the same exact moment in time?

[Philipp Sendek · Accepted solution]

Hi @Isabel Cruz ,

while I generally second Florian's answer, I'm curious for the actual use case.
And, depending on if you have apps like eazyBI installed that are able to process time series data for issues, you could find results with them.

Also, if this is critical for you to find those issues, it might be possible to create a script that runs through this set of issues (as a valid sub set) to parse their issue history and check which issues match this criteria.

But this might be too much or unsuitable if you need this info regularly and e.g. in a dashboard.

Greetings
Philipp

[Florian Bonniec · Accepted solution]

Hi @Isabel Cruz 

This is not possible as far as I know.

Regards