We need to create a filter with specific date and time criteria

[Sagar Ghuge]

We have a requirement where we want to filter a Jira incidents with below criteria.

- Specify a start date and end date where the tickets will be shown only from 9am to 9pm of each day. (Ignoring night time tickets)
AND
- Ignoring incidents (ticket) which are already resolved and having false alarm.

[PVS]

HI @Sagar Ghuge 

Try This 

createdDate >= "2019-11-16 9:00" and createdDate <= "2019-11-21 21:00" 

Thanks,

PVS

[Sagar Ghuge]

Thanks, but I am looking for something else. This query is fetching all incidents from 2019-11-16 9AM to 2019-11-21 9pm. I want to exclude all incidents which falls in night time (21:00 to 9:00) in those days.  

[Ashutosh Maheshwari]

So, What @Sagar Ghuge is trying to say is, he needs to filter from one specific date lets say: 15th November to 21st November. But the tickets should be showing time from morning 9 AM to 9 PM only, so tickets of 8 AM or 10 PM should not be shown.

[PVS]

Yes  using this JQL createdDate >= "2019-11-16 9:00" and createdDate <= "2019-11-21 21:00"    Its Not showing the data ofter 9

[Ashutosh Maheshwari]

@PVS  It doesn't work. Please have a look at screen-shot below:

Query used by me - project = INCDT AND createdDate >= "2019-11-16 9:00" and createdDate <= "2019-11-21 21:00"