Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Afaf Gamal
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 27, 2018

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?

1 answer

1 vote
Tarun Sapra
Community Champion
December 27, 2018

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events