Trouble filtering based on issue type

[Sharla_Campbell]

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

[Joseph Chung Yin]

@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.

[Sharla_Campbell]

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))

[John Funk]

Hi Sharla - welcome to the Atlassian Community!

Those issue types are Standard issue types which are the first thing you are looking for. You probably just need to take out the parts about standard and sub-task types.

[John Funk]

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