JIRA JQL EXCEL - Worklog Author is not displayed

Cyro F. Klaus

Hi
I am trying to get the list of users who registered working time via JIRA.JQL () in Excel.

Expected result:
Responsible | Worklog Date | Spent Time | Issue Type | Worklog Author

JQL used:
= JIRA.JQL ("project in ('XXX') AND (worklogDate> = 2020-05-11 AND worklogDate <= 2020-05-20)"; "assignee.displayName, worklog.Created, timespent, issuetype, worklogAuthor. displayName ";;)

However, in the last column(Worklog Author), "no found field" is displayed.

What is the correct field to display the worklog author?

 

Below are the fields I tried:

worklog.User, worklog.Author, worklog.Assignee, worklog.displayName

 

 

Earl McCutcheon

Hello @Cyro F. Klaus ,

The worklog author is not going to be an individual field that can be pulled but rather part of meta data on the issue relating to the time entries as a separate element.  This is going to be exported as the "Log work" column when when doing a Export all Fields action,  Noting there will be 1 "Log Work" column for each :

The formatting will be semi colon delimited in the column in the following format:

;Date & Time; worklog author; time logged in seconds

And an actual export would look like the following for 15 minutes as the input loged work:

;30/May/20 2:27 PM;emccutcheon;900

The following Thread gives a great example of how the data formatting occurs for imposting as well, if you are looking to import time log items:

• https://community.atlassian.com/t5/Jira-questions/While-importing-issues-by-csv-How-to-map-log-work/qaq-p/1028031

Regards,
Earl