cannot filter issueType by subtask

[digital solution]

hello, i use JQL to filter my ticket
use this JQL

`

project = x-project AND sprint IN openSprints() AND issuetype = Subtask

`

but in real board, there are not subtask exist in open sprint

result

should be return this subtask

[Ste Wright · Accepted solution]

Hi @digital solution 

Is that the correct "Subtask" wording? There's often two Sub-task Issue Types in Jira I find...

• Company-managed - Sub-task
• Team-managed - Subtask

Try changing Subtask > Sub-task (it should be visible when auto-completing the search phrase), and see if this works.

You could also try...

issuetype in subTaskIssueTypes()

...as a catch-all instead.

Ste

[digital solution]

yes already correct issue type

also i try your query 

use

project = x-project AND sprint IN openSprints() AND issuetype in subTaskIssueTypes()

same issue, no tiket shown

[Ste Wright]

Hi @digital solution 

Looks like it's a bug/feature request - see:

• JSWCLOUD-21968 - as mentioned already
• JRACLOUD-81069 

^ Your options would be to either...

• Move to a Company-managed Project as @Evgenii suggested or...
• Find a workaround, likely using Automation to populate another field you can search by

If you did consider using Automation, this is what I'd do:

• Create two rules, one triggered by sprint starting, the other sprint completing
• Have the rule locate Sub-tasks related to the sprint which is starting/completing, and populate a label as "Open Sprint" or "Closed Sprint"
• Build search queries which include the label parameters in them

^ Not ideal, but a partial workaround at this point :)

Ste

[Prerna Sony · Accepted solution]

Hello @digital solution ,

Welcome to Atlassian Community !

If you are using Team Managed project, then we have below known bug for your issue. 

JSWCLOUD-21968 - Using the JQL sprint in openSprints() doesn't include team-managed subtasks

Hope this helps !

[digital solution]

oke thanks, so for Team Managed project still there is bug

[Prerna Sony]

@digital solution , Yes for team managed projects , using JQL sprint in opensprint() does not include subtasks. 

If my post helped you, kindly accept the answer. 

Thanks,
Prerna

[Evgenii · Accepted solution]

Hi, @digital solution 

Try next query:

project = XP AND sprint IN openSprints() AND issuetype in subTaskIssueTypes()

or

project = "x-project" AND sprint IN openSprints() AND issuetype in subTaskIssueTypes()

[digital solution]

same, no subtask shown

[Evgenii]

Then, looks like it's problem @Prerna Sony had written earlier.

You can change project type (but it's not very fast process https://support.atlassian.com/jira-work-management/docs/migrate-between-team-managed-and-company-managed-projects/), or change approach, stop using sprints for subTasks.

[digital solution]

thanks @Evgenii