Exporting Tempo Worklogs via Jira Cloud for Sheets Add on

[Menno Meijer]

Hi All,

I would like to export all worklogs and subsequent information from my Jira Cloud instance. I am using Jira Cloud for Sheets add on, which I previously used to export information about issues. I am running into issues exporting the worklogs. I can export the time spend (worklog.timespent) and it gives all unique worklogs. I however am unable to get information on terms like account, account.key and worklogauthor. Could someone please shed some light on this and help me out? What am I missing here?

Example query: 

=query(Jira("project=INTPS order by summary ASC","worklog.timespent,worklog.created,account,account.key"), "Select * Offset 1",0)

[Levente Szabo _Midori_]

@Menno Meijer 

Atlassian's Excel import solutions don't necessarily play nice with other Jira apps that manage your data (like Tempo Timesheets), so you may want to expand your view.

You can give Better Excel Exporter a try which can export Tempo Timesheet-related data to native Excel reports.

Browse more Tempo Timesheets export samples or reach out if you need a hand with anything!

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)