Struggling with a specific JQL search

Yasmine_o77ylz

Hi Everyone, 

We have used JQL advance search a few times and it's great, but i am having a hard time with a specific one. I'm hoping someone has some insight on what i'm missing.

Search that i need: 
All standard issue types, in a specific project, and the status was in x on x day.

JQL i have so far: 
project = "PROJECT NAME" AND status was in ("STATUS")

Im having a hard time with the date and standard issue type portion

Dirk Ronsmans

Hey @Yasmine ,

For the standard issue types that's an easy one, you can use 

AND issuetype in standardIssueTypes()

For the Status there should be a way to add it to the WAS operator

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-WASWAS

There are a few examples on that link to the documentation. You could maybe use DURING and set 2 dates where it needs to fall between to get the exact date