What is the JQL code for issues and all subtasks not related to a specific parent?

Question

I am using the grouped filter results app by SumUp to display a chart that will show the number of story points by assignee for all active sprints that are open. I have the following JQL code listed to pull the results -

status in ("To Do", "In Progress", "Needs Approval", "Done") AND sprint in openSprints() AND assignee in ("Haylee Love", "Brandon Willett", "Bobbi Jo Shortt", "Calvin Cupini", "Scott Noorthoek", "Jenifer Smith", "Jonah Driggers", "Jeff Kopmen") AND issuetype in ("task", "subtask", "asset", "FD content item", "Review", "Creative Engagement", "Internal (Audience, data, testing etc)", "Story (Advocacy Task)")

The issue that I am having is that it is not pulling any results for subtasks. We story pont on sub tasks so I want it to pull those in as well. When I try to add the sub-task issue types to the issue type code it gives me an error. Does anyone know what I should enter to also pull in data from all sub-tasks that meet the parameters?

Thanks!

Thorsten Letschert _Decadis AG_ · Answer

Hi @Bobbi Jo Shortt ,

since it doesn't sound like the problem is related to sumUp itself, is your JQL returning the sub-tasks of interest?

What exactly do you mean by

When I try to add the sub-task issue types to the issue type code it gives me an error.

What is 'it'? And what exactly is the error message?

Cheers
Thorsten

Bobbi Jo Shortt_yvtyc6 · Answer

I tried it both ways. Should it recognize subtask or sub-task as an issue type?

Walter Buggenhout · Answer

Have you checked that you refer to subtasks correctly?

-> I see in your question both subtask (in the filter criteria) and sub-task (in the description that follows). Those are 2 different things.