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_db00h3

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