JQL Help

[Melissa McGough]

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

[John Funk]

Maybe try for 1: 

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

[Antoine Berry]

Hi @Melissa McGough ,

I am not sure if I missed something, but your first query correct if you add date2 : 

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

 this is working fine on my instance.

Antoine

[Melissa McGough]

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.

[Antoine Berry]

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