Jira Query Language JQL used for filtering/searching Jira issues, is a little tricky sometimes especially when working with custom fields, cascading select field types and sprints.
With this JQL you can find past sprints that had items with a specfic status:
Sprint in (411, 413, 415) AND status = “In Production”
You find Sprints by searching using the Advanced filter and just start typing the sprint name; notice the key in parens.
When you select the sprint name, the key will be inserted for you (the warning symbol just means that I didn’t close the parens).
That’s it – short and done.