worklogDate JQL query does not reflect the timeframe selected.

[Smita]

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. 

[Tarun Sapra]

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. 

[Smita]

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?

[Jean-Michel Bernard]

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

[Jean-Michel Bernard]

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

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