How to write JQL to find issues sharing non-specific component? (with scriptrunner)

[Erik Bjartnes]

Need: Early identify issues with planned changes in the same components.  Ideally highlight all issues in a board appended a component one or more issues in the board is also appended to.

Example: Issue 1 has change in component A, Issue 2 has change in component B. Issue 2 has change in component A and B. Issue 4 has change in component C. I would like to write a query returning Issue 1-3 which are "sharing" components without having to specify components (there are many).

Not sure if JQL can do this. So any alternative approaches would be appreciated.

In the dashboard I can create a statistics view returning and sorting all components which groups and sorts the issues on components which is the closest I have come solve to this need.

(With SQL one could join and group by and rollup the issues and filter>=2 to find components with more than one issue and return all issues appended to these components.)

[Tessa Tuteleers · Accepted solution]

Hi @Erik Bjartnes , 

Welcome to the community!

The easiest way to do this seems like a two dimensional dashboard gadget, where you use a project or filter and roll up the issues per component, or the mentioned statistics report. 

Gives you no visualization in the board, but you have a nice overview on the project dashboard maybe. You can just click through each component and see which issues have them. 

In a JQL you would always need the What. What component you want to see, or from Which issue you want to see the "component sharers" (I've not gone through with testing this as it is not your requirement). 

And the reason why it isn't really possible on a board is that issues can only be visible once on a board, and an issue can have multiple components, so it won't show up correctly there, even if you add the components one by one as a query swimlane.

Other than a BI tool, I see no other way of achieving this. 

Hope this helps! 

- Tessa

[Erik Bjartnes]

Thanks for the input and structured explaination. 

Thought maybe I could test with PowerBI.

[Tessa Tuteleers]

Hi Erik, 

good luck, I'm sure you can create some great helpful views in PowerBI for this! 

- Tessa