Database Tempo


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.



1 answer

1 accepted

Hi Marco!

(Sorry for the copied answer, but this is basically the same question as in your comment here:

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

Allright, I understand that.

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

I have create the same of the documentation: (

/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,


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?

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....

Suggest an answer

Log in or Join to answer
Community showcase
Jason Wong
Published Tuesday in Agility Beta

Welcome to agility

Every team in the world is unique, and so   Atlassian believes   that each and every team's best way of working  needs to  be molded to their unique circumstances  – ...

408 views 6 16
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot