Is there a way in Jira to compare values of different issue types?
Here's an example:
I want to know for any project if we're in a certain project stage (represented by an issue type = stage) if there are any reports (represented by an issue type = report) that are outstanding and if so, I want to know which reports those are and on which project.
I think I'm joining two statements (I am not a developer, but rather a functional person looking for a solution)
- issuetype in (stage) and summary ~"Stage 4" and resolution in (Unresolved)
- issuetype in (report) and resolution in (Unresolved)
Then return a list of those unresolved reports.
Is this possible within Jira or with an add-on for Jira?
Thanks!!