title: JQL: Show all sub-tasks of stories in current sprint
body: <p>###Background###
  I'm using Atlassian's Confluence to make a page where to display our teams subtasks. Subtasks that do not have the status <em>Done</em> will prevent the Sprint from being closed by the Scrummaster.</p>
  <p>In our case, users do not assign values (like sprintvalue, assignee or status) with the same care as they do for stories and epics.
  ###Goal###
  To make sure I have a list of all the subtask that would prevent a sprint from closing, I'd like to generate a list in confluence</p>
  <pre><code>All incomplete Sub-tasks -&gt; that are part of a userstory -&gt; which is the currently active sprint.
  </code></pre>
  <p>Currently, I have it set up like this:</p>
  <pre><code>type = sub-task AND status != Done AND parent = 
  </code></pre>
  <p>The parent field only supports search by issue key or by issue ID, not by another query. This means that my original idea does not work:</p>
  <pre><code>type = sub-task AND status != Done AND parent = (type = story and sprint = &quot;Sprint 1&quot;)
  </code></pre>
  <p>###Note###
  I am in no position to use plugins.
  Using Atlassian Cloud</p>
  <p>###Answer###
  As Kevin pointed out, and I already feared, this can only be done by using a plugin like scriptrunner. So far, the options seem:</p>
  <ol>
  <li>Try and talk to admins, see if they can get clearance on a plugin.</li>
  <li>Painstakingly input all the id's of the userstories in the JQL query.  This will take a few minutes to set-up every sprint, but it is as much work as clicking every story for sub-tasks.</li>
  <li>Try to find a way to visualize this in Jira itself. Since everything is bolted shut for users, this might not be as straightforward as it seems.</li>
  </ol>