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

How can I determine if today is monday?

Cash Coyne_tanpr0

I want to have a JQL that will basically do this now() = StartofWeek()

And use it like this:

(now() = StartofWeek() and commentedOn >-3d) or and (now() != StartofWeek() and commentedOn >-1d))

With the goal of retrieving issues commented on yesterday, or if today is Monday, retrieve issues commented on Friday.

But it appears that I can't use the now function like that.

How can I do this?

Accepted answers

Cash Coyne_tanpr0

I was trying to get issues with an update date from the prior day, but that wouldn't work for Mondays. However, I added this to my JQL and that seems to have done the trick:

 (updated < -3d AND updated > startofWeek() OR updated < -5d)

All comments

Ste Wright

Hi @Cash Coyne

It looks like you have Scriptrunner, based on the commentedOn function (which isn't native to Jira) - is that correct? Or potentially another App which extends JQL functions?

If this is Scriptrunner, I envisage it would be better to use lastCommentedDate - i.e

Monday: lastCommentedDate >= startOfWeek(1)
Before Weekend: lastCommentedDate <= startOfWeek(-2)

^ I haven't tested these, but as far as I can tell, the logic is correct.

Just to note, startOfWeek() is classed as Sunday, with Saturday being the endOfWeek(). See more information on this help page.

Ste

Cash Coyne_tanpr0

Unfortunately, I tried different configurations of this and am still not able to get ONLY Friday's comments to show up only on Monday and the rest of the days of the week that the query is run to get only the prior day's comments to show up.

It will work for Monday, when specifying startofweek, but on other days, I get the prior day's AND Friday's comments

Still need it to give me Friday's comments on Monday and the prior day's comments on all other days. Only want to see one day's worth of comments.

Ste Wright

Hi @Cash Coyne

You can refine the queries above to specifiy a specific day, for example...

Comments on Monday: lastCommentedDate >= startOfWeek(1) AND lastCommentedDate < startOfWeek(2)
Comments on Friday: lastCommentedDate >= startOfWeek(-2) AND lastCommentedDate < startOfWeek(-1)
Prior Day: lastCommentedDate >= startOfDay(-1) AND lastCommentedDate < startOfDay()

These use a second lastCommentedDate query to specify the day - so for example, (2)'s logic is now that the comment was made after or equal to Friday, but not Saturday (and consequentially, not Thursday).

Ste

Cash Coyne_tanpr0

@Ste Wright , that all makes sense. But my problem is that I want to use this part of the filter when someone runs the filter on Monday.

 lastCommentedDate >= startOfWeek(1) AND lastCommentedDate < startOfWeek(2)

Every other day of the week, I want to use this part of the filter:

lastCommentedDate >= startOfDay(-1) AND lastCommentedDate < startOfDay()

The problem is, I can't do something like:

(now() = "Monday" and ( lastCommentedDate >= startOfWeek(1) AND lastCommentedDate < startOfWeek(2)) or (now() != "Monday" and (lastCommentedDate >= startOfDay(-1) AND lastCommentedDate < startOfDay()))

It's the now() = "Monday" part that I'm having toruble with.

Andrew Laden

The nested and with or functionality should work as a defacto if. Thats a standard programming trick.

So the question is how to get the current day into something that can be used in the left side of the comparison, since you cant use the function there. You need it in a field value. So...

Try creating a calculated custom field where the value is based on the day of the week. Even if it is not on screen it should be calculated. I don't have script runner so I cant tell you how to do that calculation, but is should be easy. Worst case, you can create some automation to update that field in every open issue every midnight.

You could then use that in your comparison. if the field was called "CurrentDay" and calculated to the 3 letter abbreviation

(CurrentDay = "mon" AND lastCommentedDate >= startOfWeek(1) AND lastCommentedDate < startOfWeek(2)) OR (CurrentDay != "mon" AND lastCommentedDate >= startOfDay(-1) AND lastCommentedDate < startOfDay())

Cash Coyne_tanpr0

I was trying to get issues with an update date from the prior day, but that wouldn't work for Mondays. However, I added this to my JQL and that seems to have done the trick:

 (updated < -3d AND updated > startofWeek() OR updated < -5d)

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud