How to retrieve both Jira STORY and BUG using JQL

[Sachin_Argade]

Sample JQL

project in ("Test") and type= story and duedate >= "2024/01/01" and status not in (Remove)) and assignee= John

[Ragavendran S · Accepted solution]

project in (Test) and issueType in (story, bug) and duedate >= "2024/01/01" and status not in (your expected status) and assignee = John

Please note

If something has space in it, it has to be encoded with " "

E.g : "Test Project"

If it's a single word, it doesn't need to be encoded

E.g : Test

Check the due dates are in future

And status is from the defined list of values 

[John Funk]

Hi Sachin - Welcome to the Atlassian Community!

Use this: issuetype in (Story, Bug)

[Bill Sheboy]

Hi @Sachin_Argade -- Welcome to the Atlassian Community!

Adding to John's answer...

Here is some free training and documentation from Atlassian to learn how to make such queries in the future:

• https://university.atlassian.com/student/activity/1225443-intro-to-jql-in-jira-software-course-description
• https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql
• https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

Kind regards,
Bill