nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL filter by time

Administrator_06gna8

Good afternoon

I need to make a filter that brings tickets from the previous month, being the time from 18:00 of the current day until 09:00 of the following day.

I tried this one below, but it didn't.

created = startOfMonth("-1") AND createdDate >= startOfDay(0h) AND createdDate <= endOfDay(-17h)

Accepted answers

All comments

Carla Ann Rowland

Hi Carlos:

You can modify this filter: project = "scrap service desk project" and ((createddate <"2022-01-01 18:00") AND (createddate >="2021-10-01 09:00"))

Regards, Carla

Jack Brickey

@Administrator , your request is a bit confusing. You state you want issues created during previous month but you go on to say current day which would seem to imply ‘today’ which is previous month. Can you elaborate on your exact goals?

Administrator_06gna8

Good morning,

I need to make a filter where only calls appear from 18:00 at night until 09:00 in the morning of the other day. And it has to be a month.

Administrator_06gna8

Good morning, Carla.

I did it this way, but this way it filters calls within business hours, my search needs to look for calls that are outside business hours. In other words, you give 6:00 pm one day until 9:00 am the other day. He understands?

Jack Brickey

I do not think that is currently possible OOTB. Please see this open suggestion- JRACLOUD-69417 - Allow a JQL query for a specific time span of the day, from a period of time

Carla Ann Rowland

so adjust the times to get the correct scope to be outside business hours:

You can modify this filter: project = "scrap service desk project" and ((createddate <"2022-01-01 09:00") AND (createddate >="2021-10-01 18:00"))

Administrator_06gna8

Hi Carla

Even adjusting the time scope, the jira doesn't recognize the filter. I talked to a senior analyst at jira, and he said that this filter doesn't really work.
Grateful for the attention.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management