JIRA: I need to export an excel sheet with log time of all projects in a specific time period

Afaf Gamal

Hello,

I can only now export excel sheet with all projects by creation date, but the aim of my report to calculate the time spent in projects and by users weekly.

but some users may work on some tasks that created in a previous created date. 

the search criteria include creation date, resolution date and so on, there is no way to find a search criteria that allow me to export an excel sheet with the tasks that ONLY had been logged into in a specific period of time?

Tarun Sapra

Hello @Afaf Gamal

As you shared

"excel sheet with the tasks that ONLY had been logged into in a specific period of time?"

You can use the JQL's "worklogDate " to find the issues which had work logged in a specific time period.

Possible duplicate

https://community.atlassian.com/t5/Jira-questions/jql-query-time-spent-between-two-dates/qaq-p/799573