Jira - filtering worklogs by users from Tempo team

Question

Hi All,

I want to do a custom Jira dashboard that would filter out ALL worklogs for a users being members of a specific Tempo team. So the case is as follows:

- I have a project XYZ in Jira

- I have created the XYZ team in Tempo and linked it to XYZ project

- Now I want to create a JQL filter that will filter out ALL worklogs for members of XYZ team but made in all projects on Jira as members of XYZ team logged time in XYZ and ABC projects and I want to filter out all of them.

I know this is possible to access thorugh tempo reports, but I need it in JQL so that I can provide it as a filter for a specific Dashboard Gadget.

lkoral · Answer

Correct, but this will return only the issues from project XYZ and will lack the issues in project ABC where members of XYZ team also logged time.

Susanne Götz _Tempo_ · Answer

Hi @lkoral

When using Tempo to track your time the worklog information is stored in the Tempo database. The information is also synced to the JIRA database, but in this sync, the worklog author is anonymized to "Tempo Timesheets" (https://tempo-io.atlassian.net/wiki/spaces/KB/pages/488931333/Why+do+the+worklogs+appear+with+the+author+Tempo+Timesheets+instead+of+the+user+s+name).

As jql retrieves information only from the JIRA database and JIRA has no information about the actual worklog owner, the "worklogAuthor" parameter can not be used in jql.

It is possible to create a filter based on the Tempo Team that is set in the Tempo Teams custom fields on issues by using the jql option Team.id = team_id.

Please take a look at https://tempo-io.atlassian.net/wiki/spaces/KB/pages/1276346758/Tempo+JQL+functions+for+Cloud for Tempo specific jql options.

Best regards,
Susanne Götz
Tempo team