Each assignee leadtime by SQL...

[Nate _이슬기_ _Project Management_ _]

Dear Guys,

We are very satisfied with Jira and JSD. we apply Jira for Company task management system. 

The system is wonderful. Our next step is, performance check about each assignee.

I'd like to analyze that each assignee lead-time per each ticket. but it seems like very difficut or impossible in JQL.

So I was wondering that is there any way to analyze 'Each assignee leadtime' by SQL level...

Could you let me know the answer?

Regards,

Nate

[Thomas Deiler]

Dear @Nate (이슬기) [Project Management] ,

I cannot recommend to directly access Jiras Database. Best you do this with the REST API. Aggregating the history information of an issue will let you track down the lead-time.

But you will need some coding skills ...

So long

Thomas