JQL search for issues added and removed from a sprint

It could be useful to be able to search for issues that were added or removed from a sprint during it's progress.

A customer even tried to get help from Script Runner support, but the according to the support, the respective function that could return that result is available only to the Server version of Script Runner.

It would be great to have it built natively.

Workaround

As with all Automation rules, please be aware of your Automation service limits.

1. Create a custom field of type "Paragraph" and call it something like Automation Sprint Logs:
   
2. Set up your automation rule like so:
   
   The Automation Sprint Logs field is updated with the following value:

   {{now}}: 
   Old Sprint Value: {{fieldChange.fromString}}
   New Sprint Value: {{sprint}}
   ***
   {{customfield_10195}}
   

Notes

• Including {{customfield_10195}} means that new changes are prepended to the existing logs rather than replacing them. "10195" is the ID of the custom field Automation Sprint Logs.
• The audit log action shown in the above rule is not mandatory but it does help with debugging.
• Here's how the field on the issue looks:
  
• You can search the field using the contains operator (~) like so:
  
• You can also exclude issues that currently belong to a certain Sprint using the following JQL:

"Automation Sprint Logs[Paragraph]" ~ "Dates sprint 3" AND Sprint != "Dates sprint 3"

• The Automation Sprint Logs custom field will only be populated from the time the rule is set up. Previous Sprint changes will not be shown there.

Please let me know if you have any questions!