How can I email filter results on demand?

[Leigh Riffel]

I have multiple filters for which multiple people need to be able to email the results of the filter on demand. 

A subscription will not work because we don't know when the email will need to be created/sent.  I could use the cron scheduling to send one every minute to every user just so they always have the one they need, but that seems like an excessive amount of email.  Essentially I need an easy - schedule to run once and never again.

We can't just send a link to the filter in the email because the state of items in the filter will likely have changed by then and  the email needs to contain the current state.

I can't come up with any single ticket states or ticket transitions that could trigger an email.

Just because the filter returns results does not mean an email should be sent.  Only conditions outside of Jira cause the email to need to be sent.

The primary way I can see to do this currently is to export the filter results to excel and then copy them from the excel spreadsheet into a new email, which is rather cumbersome and error prone.

I believe my ideal solution would add a button to the filter that when clicked emails the filter results to the logged in user.  I can create a button with Adaptavist ScriptRunner (https://scriptrunner.adaptavist.com/4.3.9/jira/fragments/WebItem.html#_simple_link_example) and I can create a REST Endpoint that returns the results when the button is clicked, but that just gets me the JSON.

Any suggestions would be appreciated.