How can I search for issues that had sprint values at one point which currently do not?

Question

Assume for a moment that a bulk operation occurred, and as a result of this operation, the Sprint field was cleared for some issues.

Is there a way to search for issues with no Sprint value that had sprint values at one point?

If so, is there a way to query for specific previous values?

The goal of this exercise is to find the issues that were altered and restore the last known Sprint value.

Scriptrunner solutions will be fine in this case, and I am open to other suggestions.

Rob Horan · Answer

This particular instance has Scriptrunner - might that work?

Eugenio Onofre_v78igo · Answer

Hi @Rob Horan

There is a "changed" operator that can be used for some fields in JQL but this does not work for Sprints.

At this point, I believe you probably are not going to be able to achieve this with out-of-the-box JQL.

I would suggest looking into some Script plugins in the Atlassian Marketplace.

Regards,
Eugenio