Trouble filtering based on issue type

Question

Hi

I'm having trouble filtering based on specific issue types. The below query is displaying other issue types (e.g. story, epic etc).

How do I filter everything else out?

Here is my query:

issuetype in (standardIssueTypes(), subTaskIssueTypes(), "Campaign task (AS)", "Campaign task (SP)", "Campaign task (VS)", Task, Sub-task, Sub-Task) AND status in ("ACTION REQUIRED", Approved, "Awaiting Definition", Blocked, "Blocked -", Defining, "External Review", "In Progress", "Internal Review", NEW, "Not Started", Performance, "Selected for Development", "To Do") AND assignee is EMPTY ORDER BY created DESC

Thank you

John Funk · Answer

Did you try both suggestions of taking out "standardIssueTypes(), subTaskIssueTypes()"?

Sharla_Campbell · Answer

Hi @Joseph Chung Yin I was able to return the result I needed by updating the filter query to the following with additional parentheses around the issue type:

(issuetype in (standardIssueTypes(), subTaskIssueTypes(), "Campaign task (AS)", "Campaign task (SP)", "Campaign task (VS)", "Website task (AS)", "Website task (SP)", "Website task (VS)", Sub-task, Sub-Task, Task) AND issuetype not in (Epic))

Joseph Chung Yin · Answer

@Sharla_Campbell -

Welcome to the community.  If you know the issue types that you want to return in your JQL, you can just call them out in the issuetype in (xxxxx, yyyy, etc).  On the other hand, you can use "not in" to exclude all the issue types that you don't want.  You should avoid using the "standardIssueTypes(), subTaskIssueTypes()", because by default, it is giving you all the issue type associated with Standard/SubTaskIssue types.

Is your intention to get all specific issue types issues in all of your projects at once, or are you looking at only a specific project?

Please clarify your ask if you can, so we can assist you better.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.