JQL for getting issues for which developer has logged time and within specific date range

[muhammad_mansoor]

JQL for getting issues for which developer has logged time and within specific date range

[Tarun Sapra · Accepted solution]

 worklogAuthor = tsapra and worklogDate > startOfMonth() and project = XYZ

As you see in the above query you can use workLogAuthor to mention user and workLogDate to mention date , you can also hard-code the date. If you wish to enter date range please use > & < operators with worklogDate field.

Valid formats include: 'YYYY/MM/DD', 'YYYY-MM-DD', or a period format e.g. '-5d', '4w 2d'.

[muhammad_mansoor]

Your solution does not work for time logging in sub tasks. I want to get those stories as well in which user has logged time in sub tasks as well.

[Tarun Sapra]

Hello @muhammad_mansoor

This JQL query is issueTYpe agnostic thus it works across all issueTypes.

Can you share the JQL query which you are using. If you want to filter by types then just add that criteria to the above query.

[muhammad_mansoor]

I used this query as a sub query in "issueFunction is parentsOf" and it worked like a charm.

[Tarun Sapra]

Glad to know @muhammad_mansoor that it works now. Script runner plugin does have loads of useful JQL functions. If you are satisfied with the answer please accept it so that others are also helped.

[muhammad_mansoor]

@Tarun Sapra Can you please answer this question as well https://community.atlassian.com/t5/Jira-questions/How-to-get-all-the-Team-Boards-under-a-scrum-board-using-JIRA/qaq-p/901820