Database Tempo

[MarcoC]

Hi,

I'm working on my MySQL db configured for JIRA.

Is there any Database Schema for the plugin Tempo??

In the tables of Tempo database, where can I find the Worklog attribute? Because I think that in ao_86ed1b_timeplan I find the data for my plan time, but I don't understand where I can find the Worklog Attributes of the Plugin Tempo. that I've created.

Regards,

Marco

[Benedikt Bjarni Bogason [Tempo] · Accepted solution]

Hi Marco!

(Sorry for the copied answer, but this is basically the same question as in your comment here: https://answers.atlassian.com/questions/120256/worklog-attributes-tempo-plugin#comment-120573)

We store most of the Tempo specific data in the JIRA property tables but some data is stored with the JIRA Active Objects plugin. This means that all the Tempo data is in the JIRA database and is backed/restored just like other JIRA data.

The data in the property tables is stored in a proprietary XML format and the Active Objects tables are just normal database tables.

Note that we can change the format/layout at any time and that we do not support any direct access or manipulation of the data.

Kind regards,

Benedikt Bjarni Bogason

Tempo Team

[MarcoC]

Allright, I understand that.

But I don't understans WHERE is the WorkLog Attributes?

I have create the same of the documentation: (http://wiki.tempoplugin.com/display/TEMPO/Worklog+Attributes+Types)

/rest/tempo-rest/1.0/accounts/json/getDynamicDropdown/|1|2|3|4/Please Select|Red|Yellow|Green|Blue

When I go to Report > Views, I add the "Type" and I can see the colour that I set.

If I want to extract the data that I can see in the Tempo Report (Issue, Planned, Worked, Type), I know where I can find the Issue, Planned and Worked value in the database, but I don't understand where is the colour? Where can I find the association between issue and Type?

I know it could be crazy, but I want to extract few info.

Best regards,

Marco

[Amit Girme]

Hi Marco,

Did you get success to achieve this?

Like few more I am also looking for the database tables for worklog from where we can query it. Can you please help me?

[MarcoC]

Hi Amit,

I understand that if I try to find the Worklog put form Tempo, I can find it in the Worklog table of JIRA.

If I try to find the Worklog attributes in the database, there isn't nothing. So I suppose that it is a Javascript, but I don't understand where JIRA take the info....