nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Retrieval of Time log data

Pushpkant

I want to get details of the time logged for an issue. My Requirement is, If an issue is assigned to 3 users, then I want Time Log details for each user in that particular issue.

Can anyone please help me how to get this data?

Accepted answers

Marcus Silveira

Hi,

I believe you could get this information running a query on your JIRA database like the following

select * from worklog 
where issueid in (select id from jiraissue where assignee in ('user1','user2','user3')) 
  and author in ('user1','user2','user3')

Hope this helps,

Marcus

All comments

Marcus Silveira

Hi,

I believe you could get this information running a query on your JIRA database like the following

select * from worklog 
where issueid in (select id from jiraissue where assignee in ('user1','user2','user3')) 
  and author in ('user1','user2','user3')

Hope this helps,

Marcus

Pushpkant

Thanks Marcus... I want detail on which status I logged the time. Do you know any table from where I can get those details. Jiraissue Table has workflow_id, but can we get the workflow_id name?

Michael Blake1

you can also use the workload piechart gadget to see the time.

Pushpkant

Hi Michael,

But it will not give me details about each Jira Issue vs Assignee.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

worklog