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

Reminder to log work

Hey!

I'm trying to set up a rule to notify the assigne that he/she forgot to log work that day.

My idea is to check about 5PM if the assignee logged work, if not, notify the person via email.

I tried with this JQL, but it's not working, it's still getting the other tasks whithin:

project = XXX AND issuetype in (História, Task) AND status in ("XXX", "XXX", "XXX", XXX) AND worklogDate >= -1d

Any ideas?

Accepted answers

Adam Rypel _MoroSystems_

Hello @Lusca Fontoura ,

So if I understand correctly, you are trying to find the issues, which were not logged today, is that right? You could use:

project = XXX AND issuetype in (História, Task) AND status in ("XXX", "XXX", "XXX", XXX) AND worklogDate < startOfDay() AND assignee = currentUser()

All comments

Adam Rypel _MoroSystems_

Hello @Lusca Fontoura ,

So if I understand correctly, you are trying to find the issues, which were not logged today, is that right? You could use:

project = XXX AND issuetype in (História, Task) AND status in ("XXX", "XXX", "XXX", XXX) AND worklogDate < startOfDay() AND assignee = currentUser()

Yeah, that's what I'm trying.

I did what you suggested, but still not working. I begin to think that there's a bug.

When I try that JQL you suggested, it shows all the issues in the project.

I logged work on one of them, to see if something would change and the JQL still got me the same result.

I changed the JQL to "AND NOT" before workLogDate, to check if it gets just the one I logged work and this one worked well. So why the suggestion you gave me isn't work?

Isn't this a bug?

Adam Rypel _MoroSystems_

That is interesting, I am trying this with different scenarios but everything works well for me with worklogDate < startOfDay():

I tried to log the work to the past and log the work for today and the result is correct - only issues in the past are shown.
If I try worklogDate >= startOfDay(), only issues logged today are shown.
If I put NOT before worklogDate < startOfDay(), issues with log from today are shown, which is correct (works same for the other way around).
I tried that with combination of other fields, as project and status and everything works fine as well.

The only thing I noticed is, that Jira ignores the time you enter during the log work - all the worklogs are always set to 00:00. So if you log now for today, the date and time would be "11/06/2021 00:00".

I cannot really tell for sure if this is a bug or not. I have just found this reported bug, which relates to NOT though: https://jira.atlassian.com/browse/JRACLOUD-74621 , which also does not seem to appear for me though.

Since you are on a Standard plan, I would suggest to raise a support ticket with Atlassian - that will probably be quicker and they can help you with that more.

Also it would be nice to share the results of the solution with Atlassian here.

Regards,
Adam

So, what I was trying to do was the scenario 3, like this:

project =XXX AND issuetype in (História, Task) AND status in ("X", "X", X) AND NOT worklogDate > startOfDay()

With this one I get the only issue I logged work today.

After that, I did some changes, and got the same result:

project =XXX AND issuetype in (História, Task) AND status in ("X", "X", X) AND NOT worklogDate < startOfDay()

Looks like with > or < I get the same results, showing just the one I logged and not showing all the others.

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

automation