I'd like to be able to report on test cases where the Jira issue is in a certain state and test execution criteria matches a set of parameters, such as never executed or hasn't been executed in the last N weeks or months.
For example, the Jira Test issue may have states such as "Authoring", "Under Review", "Ready for Manual Testing", "Automated", and "Deprecated". An example query would be all Test issues that are in the Ready for Manual Testing or Automated states that do not have a passing execution in the last 3 months.
|I would like...||to query for Test issue types based on the issue state and test case execution date|
|So that I...||find test cases that have not been executed recently.|