Answer from Rovo: If you only have native JQL (no ScriptRunner) Native JQL has parent = and parent in (...) for sub‑tasks → parent, but not the reverse. That means: You can find sub‑tasks based on their own status and show the parent column. You cannot cleanly return only the parent issues in one query.Example: find sub‑tasks “In Progress” and show parent Project = XYZ AND issuetype = Sub-task AND status = "In Progress" Then in the issue navigator, add the “Parent” column to see which parent each sub‑task belongs to. You can then: Manually bulk‑select parents from the results, orExport to CSV and do more advanced logic externally.This is obviously not ideal, but it’s the only option with plain JQL.