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 for Mon 05:30AM IST to Next Mon 05:30AM IST

WasimBuden

Dear Community,

I need to write a JQL that would give me the results of all the tickets created between Mon 05:30 AM IST till Next Mon 05:30 AM IST.

For this I wrote -> created >= "2022-01-31 05:30" AND created <= "2022-02-07 05:30", but I don't want to write this every week, my profile timezone is set to +05:30GMT. Is there a way to get a JQL that dynamically gets me data for this each week so I can use this JQL on a dashboard?

TIA,

Wasim

Accepted answers

Piotr Zadrożny _Eyzee_

Hi @WasimBuden

Try something like:

created >= startOfWeek(330m) AND created <= endOfWeek(330m)

All comments

Piotr Zadrożny _Eyzee_

Hi @WasimBuden

Try something like:

created >= startOfWeek(330m) AND created <= endOfWeek(330m)

Piotr Zadrożny _Eyzee_

Well I dont know if I understand correctly. If you need issues created after last Monday 5:30 till now, you just need: created >= startOfWeek(330m)

Best,

Piotr

Pramodh M

Hi @WasimBuden

Here's the JQL

created >= startOfWeek("+1d")

Thanks

WasimBuden

Hello @Piotr Zadrożny _Eyzee_ thank you for your response , what i really need is created >= startOfWeek(330m) AND created <= endOfWeek(330m) data for previous week.

So it should be created >= startOf(previous)Week(330m) AND created <= endOf(previous)Week(330m)

WasimBuden

Hello Pramod

I would need data for tickets from last Monday 5.30 AM to this Monday 5.30 AM, not the current week!

Piotr Zadrożny _Eyzee_

Well its not the prettiest way but you can write (you just can't mix time unit in those functions):

created >= startOfWeek(-9750m) AND created <= endOfWeek(-9750m)

where: 9750m is 7*24*60-5h30m (1 week minus 5h30m)

Welcome!

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

Quick Links

Find more posts tagged with

jira-service-desk-cloud

jql

jira-service-management-cloud

jira-service-management