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; } } }

Dynamic JQL-query for a fixed day of the week

RM_gv50ps

Hi Community,

I have a question regarding a JQL-query:

I need to create a query that recognizes, for example, the first Monday of the month. Is this even possible with a JQL query?

I have already tried the possibilities with startofweek or startofmonth etc..These work of course in principle, but have a certain fuzziness in the results (because of the wandering dates),if I do not manually change the + and - days in my query. Is there perhaps an automated way to do this?

Basically I am open for all possible solutions that go beyond a JQL query (e.g. create a dummy or similar).

Thanks for the help,

Robert

Accepted answers

John Funk

Hi Robert - Welcome to the Atlassian Community!

You are not going to be able to use dynamic values as such in JQL.

All comments

John Funk

Hi Robert - Welcome to the Atlassian Community!

You are not going to be able to use dynamic values as such in JQL.

Payne

You can do something like the following. You may need to massage it and/or expand it a bit, but this is an example that returns issues created on the first Monday of the current month.

created >= startOfMonth() and created < startOfMonth(7d) and created >= startOfWeek(1d) and created < startOfWeek(2d)

RM_gv50ps

Unfortunately, this is what I feared. Thanks for the confirmation of my thoughts

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

jql