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

worklogDate JQL query does not reflect the timeframe selected.

Hi,

 

I am using JIRA Software 7.2.4 and I have an issue with JQL using worklogDate() function.

I am specifying the date range as worklogDate > "2019/01/01" but the time spent or work log column shows very minutes logged till date instead of what is logged January 2019 onwards. 

Capture.PNG

 

Untitled.png

1 answer

0 votes

Hello @Smita

The JQL query is for filtering the issues, and the columns in the issue navigator are for showing the actual data. In a way both things are mutually exclusive, because you used "worklogDate " to find the issues which you were intersted in and the issue navigator displayed the relevant issue columns. You can't at run-time make the time-spent column display only the work logged after the date which has been used in the query. 

Hi @Tarun Sapra, I am slightly confused here. How should I modify the query and view results then? All I would like to do is, get the time logged for all relevant issues for a specified person in a given sprint. 

So I need to specify the date range right?

Hello

@Tarun Sapra 

You can't at run-time make the time-spent column display only the work logged after the date which has been used in the query. 

Thanks for the clarification, as I was searching exactly for this feature.

I have searched for a related issue in Jira, I found this one and contributed one comment about it.

@Smita Feel free to vote and contribute as well with your use case: https://jira.atlassian.com/browse/JRACLOUD-12312

Thank you

JM

There is also the Jira Server issue (basically the same idea):

https://jira.atlassian.com/browse/JRASERVER-12312

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

872 views 6 24
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