Need a JQl querry to exclude an issue type

Question

project = ABC AND issuetype in (Epic, Story, Sub-task) ORDER BY cf[10008] ASC, assignee ASC, created DESC

Currently i am using above JQL querry to filter our my view on board, but as along with 'Story' my 'Internal Bugs' epic also as Sub-Tasks, so its appearing in my board which i dont need.

i need only Stories and their subtasks to be visible iso including Internal bugs which as subtasks too.

Pls help me out with an querry

Charlotte Santos -Appfire- · Answer

Hi @MN, Sunil

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find Stories and their Sub-tasks from project ABC:

issue in parentsOfSubtasksInQuery("") AND project = ABC AND type = Story OR issue in subtasksOfParentsInQuery("project = ABC AND type = Story")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Rebekka Heilmann (viadee) · Answer

Hi @MN, Sunil and welcome to the Community!

So if I understand you correctly, you only want to see Sub-Tasks of a specific Issue Type?

That's not possible with Jira Standard, but have a look at this thread, where a solution with ScriptRunner is suggested:

Solved: JQL: Filtering parent issue type (atlassian.com)