How to get plan time by SQL

[Tuấn Minh Phạm]

Dear all,

I want to get Plantime and link it to Jiraissue. But i don't know where Plantime is

So how can I find the Plantime in Database?

[Fabio Racobaldo _Herzum_ · Accepted solution]

Hi @Tuấn Minh Phạm ,

welcome to the Atlassian community!

I think that you are referring to an external app. BTW, in order to retrieve that information you can go to : Administration -> System -> Plugin Data Storage

All information about plugins and their AO tables can be retrieved there.

Hope this helps,

Fabio

[Tuấn Minh Phạm]

Hi @Fabio Racobaldo _Herzum_, thanks for your respond!

I want to query the database to get Plantime, but i don't know which table contains it. Like log time in Worklog table.

Thank you!

[Tuấn Minh Phạm]

I found it in AO_2D3BEA_PLAN_ALLOCATION Table. 

Thanks for your help!

[Fabio Racobaldo _Herzum_]

you're welcome @Tuấn Minh Phạm