Help searching for subtask and issue types with different status'

[Nicole smith]

I'm trying to search for all subtasks with the status of Open only when the standard issue type is in the status of Testing, is that possible? I need to show how many subtasks have been created with or without a testing subtask (we have a custom field identifier to identify which subtask is a test task or not).

To better clarify, I need to show all open children tickets (subtasks) when the parent ticket (standard issue/non subtask) has a status of Testing.

[mwarton]

Hi Nicole,

If you are generating reports Intelligent Reports can easily handle this kind of nested query. You can just point and click to set it up, no scripting or API to learn.

[Udo Brand]

Hi Nicole,

beside what Peter mentioned there is another plugin (Script Runner) where you could use following query:

status = open and issuefunction in subtaskOf("status = Testing and issuetype =<YourParentIssueType>")

Cheers,

Udo

[Peter T]

You need to use a add-on for that. Based on my experience two add-on will do tha work:

https://marketplace.atlassian.com/plugins/org.craftforge.jira.craftforge-jql-functions-plugin

Look at the following example in their documentation: http://cpsli4j.craftware.biz/examples

subtaskIssuesFromFilter()

The other add-on is JQL J-Tricks

https://marketplace.atlassian.com/plugins/com.j-tricks.jql-plugin

Look at the JQL Functions: subtaskIssuesFromQuery()

Let me know if you need more details how  to use those functions.