We have multiple projects setup in Jira - "Global", "Modernization", etc. These are the projects that represent active work, or active projects. We also have a separate project for the intake of new ideas, suggestions, etc. called "Discovery." A new idea in Discovery includes a field that indicates which department submitted the idea - Sales, Finance, etc. Once an idea is activated and becomes a working project, an initiative is created n one of the other projects, and that's where we keep track of status as we move forward.
When the initiative is created, that initiative ID is added to the idea, but the Sponsoring Department field from the Idea isn't carried over to the initiative; it is only on the idea. The problem I have is how to create a filter of active projects (from "Global", "Modernization" etc.) and filter /group it by the Sponsoring Department (from "Discovery"). Any help would be appreciated.
