What would be the result of worklog worklogDate <= endOfMonth(-1)

[Vikrant Yadav]

Hi Guys,

Need one help to understand the result of below query :- 

worklogDate >= startOfMonth("-1") AND worklogDate <= endOfMonth("-1")

May i know what would the result of above query ?

As per my understanding, it display issues in which work is logged in October Month (1st-31st) along with issues in which some work logged in october and some work in november. 

[Fabio Racobaldo _Catworkx_]

Hi @Vikrant Yadav ,

you are right! That JQL will retrieve all issues with at least a worklog date added in the previous month.

Fabio

[Vikrant Yadav]

Thanks @Fabio Racobaldo _Catworkx_ But it's not working as expected. It's showing zero result when searching :- 

In 3064 issue key, work is logged in both Nov and Oct month, when searching in JQL is showing No result found. 

[Fabio Racobaldo _Catworkx_]

It's weird. It means that that jql is searching for issue with worklogs ONLY in the previous month.

[Vikrant Yadav]

FYI , Issue Key 3064 is a subtask. User is logging work in both task and subtask. 

Subtask  and Tasks makes any difference in issue search ? 

[Fabio Racobaldo _Catworkx_]

JQL should search at parent and subtask level in the same way. My opinion is that query is searching for issues (parents or subtasks) with worklogs just in a specific month.

[Vikrant Yadav]

@Fabio Racobaldo _Catworkx_  I was also thinking the same, but when i searched without putting the issue key it gives me 10 issues, in which work is logged in both month by same user/same workauthor, while in some issue no work is logged by that author in Oct-Nov month even then displaying in the result. 

Please suggest :- 

[Fabio Racobaldo _Catworkx_]

it is strange

[Vikrant Yadav]

Yeah :(
Let me check with Atlassian Support. Will post the answer here..once i get solution..

[Vikrant Yadav]

Hi @Fabio Racobaldo _Catworkx_ If you check the first screenshot clearly, you will find the reason why it's not showing in JQL. User work logged date is Oct 2021 and searching Oct 2022. Minor mistake but difficult of us to find :)