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.
(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.
Benedikt Bjarni Bogason
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)
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.
I understand that if I try to find the Worklog put form Tempo, I can find it in the Worklog table of JIRA.
It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...
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!
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