Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL Help with work logs?

Hi, I need to find issues that have no time logged on them. 

timespent is EMPTY doesn't work, this is an issue returned by query using this parameter:

image.png

image.png

My JQL:

project = "SD" and created >= 2020-12-01 and created <= 2020-12-22 AND timespent is EMPTY

2 answers

Hi @Gleb Kartashov

If you were to run the same query again now, would that same issue still show in your search results?

Though it's still early in the morning and I may not be very well awake yet, I don't see anything wrong with your JQL. It should return the correct results. I think there may be an indexing issue or a delay between the moment you ran the query and the background processing of those 5 minutes that were logged in the system. If my guess is correct, then the worklog might have come in just when you ran the query and wasn't properly indexed yet. 

@Gleb Kartashov -

I agreed with Walter's reply.  Your JQL looks fine.  Your JQL should not return the issue in your screenshot, since it has logged work.  You need to work with your Jira systems admin to look into the indexing process to see if there are any issues causing the JQL oddity.

Best, Joseph Chung Yin

@Gleb Kartashov - Furthermore if you have ScriptRunner for Jira installed, then you can use the issueFunction call for "workLogged" to assist your effort.

EX - project = TESTPROJECT and issueFunction in workLogged("after 2020/01/01")

Best, Joseph

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

Why upgrade to Jira Service Management Premium?

We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan.  &nb...

227 views 1 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you