Using JQL with hiearchies

[Antoni Abella Vendrell]

Is it possible in JQL to retrieve all ideas connected to a given idea, e.g., all solutions that belong to a given opportunity? I'm trying to share a spreadsheet based on a view. I can't just use export CSV from a list view because I need the description field, and I cannot add it to a list. Ideas?

[Tanguy Crusson · Accepted solution]

What @Jeremy Drexler said!

Connections are based on issue links.

Here's a demo: https://www.loom.com/share/e4d9d28d168a43879807fbf7b1a4e675?sid=7593a9b3-f1b9-4e81-b7b1-7aa9cc992d83

The JQL I used: 

issue in linkedIssues("P2-728") and type=Solution

[Jeremy Drexler]

Can you use: issue IN linkedIssues("card number")

[Freyr Gudmundson]

This is not exactly what you asked for, but you can use Plans and there you can group by the Idea. I haven't tried it, but I would guess that you can then export CSV from there.

[Antoni Abella Vendrell]

The other option is easier, but thanks for offering the answer Freyr!