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

Conflict in query related to search of issues with empty time logs

Vlad Olekhnovich

Hey there!

I have following query, which should return issues, what has no time logged by current user for previous month:

assignee in (currentUser()) AND (worklogAuthor != currentUser() or timespent is EMPTY) AND project not in ("project1", "project2", "project3") and created >= startOfMonth(-1) AND created <= endOfMonth(-1)

Currently, it returns issues that has time logged by a current user.

I tried to consolidate condition worklogAuthor != currentUser() or timespent is EMPTY via AND operator, but in this case I got nothing.

Seems like, it returns issues that that has logged time, because issues has time logged not only by current user. I made this conclusion, since all four issues, what query returns to me, has time logged by me as current user and another user:

Accepted answers

Bill Sheboy

Hi @Vlad Olekhnovich -- Welcome to the Atlassian Community!

Please try to substitute that clause with this:

( (worklogAuthor != currentUser() AND timespent IS NOT EMPTY) OR (timespent IS EMPTY) )

This will separate the two things you are checking for:

Time was spent by someone other than the current user, or
No time was spent

Best regards,

Bill

All comments

Bill Sheboy

Hi @Vlad Olekhnovich -- Welcome to the Atlassian Community!

Please try to substitute that clause with this:

( (worklogAuthor != currentUser() AND timespent IS NOT EMPTY) OR (timespent IS EMPTY) )

This will separate the two things you are checking for:

Time was spent by someone other than the current user, or
No time was spent

Best regards,

Bill

Vlad Olekhnovich

Thanks for warm welcoming and your answer, Bill!

Your proposal is reasonable, but main idea of the filter is to receive issues that was assigned to a current user (or still assigned, but were resolved or done) and has no time logged by him/her

Sorry, if my description confused you🙌

Bill Sheboy

Hi! I thought that was what I was suggesting, so here is a more complete example for one specific project. Please add/adjust any additional criteria that you need.

project = myProject
 AND ( assignee = currentUser()
      OR assignee WAS currentUser() )
 AND ( timespent IS EMPTY
       OR ( timespent IS NOT EMPTY AND worklogAuthor != currentUser() ) )

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server

time-tracking