JQL Help

Question

I want to write a JQL query that says the following:

Issuetype in (bug, story) where status WAS NOT in (Accepted) ON "Date" AND issues that were created between date1 and date2 and sprint = x and project = HHP

I'm having a difficult time getting it to work and what I've come up with so far is two queries that only sort of give me what I want.

1. Issues not in accepted status before a specific date (returns more records than expected)

issuetype in (Bug, Story) AND status was not in (Accepted) on "2019-04-30 23:59" AND createddate < 2019-05-01 AND sprint = 97 AND sprint != 98 AND project = HHP ORDER BY created DESC, summary ASC

2. Issues that were created after a specific date

issuetype in (Bug, Story) AND createddate >= 2019-05-01 AND sprint = 97 AND project = HHP ORDER BY created DESC

Antoine Berry · Answer

Hi @Melissa McGough ,

I am sorry I am not notified on comment update. Maybe you are looking for something like this then ?

sprint = 97 AND project = HPP AND (status was not in (Accepted) BEFORE "2019-04-30 23:59" OR (issuetype = Story and createddate > 2019-05-01 AND createddate < 2019-05-15))

Antoine

John Funk · Answer

Maybe try for 1:

issuetype in (Bug, Story) AND status was changed to (Accepted) after "2019-04-30 23:59"

Melissa McGough · Answer

Hmm, I thought this was what I wanted but now I'm looking at the dates and I don't know.

I want a query that returns all the things that were not in accepted status by the 4/30/19 date as well as all the stories that were created between 5/1/2019 and 5/15/2019 for the specific sprint.