JQL Query - Search Tickets

Is it possible to filter tickets with the following conditions please?

Tickets from
Date: 01/08/2018 (dd/mm/yyyy) to 01/05/2022 (same date format as the latter).

Time: all tickets opened after 17:00 or 17:30.

Can these conditions be applied for a full period, and if possible with time as those are the specifics needed?

If not would a different jql query be possible using time as this is the most important requirement rather than date?

1 answer

0 votes

Hi,

Jira supports below date formats only.

Valid formats include: 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'yyyy/MM/dd', 'yyyy-MM-dd', or a period format e.g. '-5d', '4w 2d'.

You search as below

created >= "2022/05/10 17:00"

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

WOuld prefer the specific jql query if possible. Search for tickets from 01/08/2018 - 05/05/2022 17:00 - 23:59

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Do you mean, you want the tickets created between 5 P.M and 11:59 only for all these days?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Exactly. If not possible maybe there is a way to do them month by month

BR
Luke Brincat

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.