Worklog Attributes Tempo Plugin

Hi,

I don't understand where are saved the new attribute that I create in the Worklog attributes of the plugin tempo. In the issue I can't see noting of the value of the select list that I have inserted. Where is saved?

http://wiki.tempoplugin.com/display/TEMPO/Worklog+Attributes+Types

I create the same select list that is in the Dynamic Drop-Down. Where are saved the color??

regards,

Marco

5 answers

1 accepted

Hi Marco,

The worklog attributes are stored in a proprietary XML format (which can change at any time) and we offer no direct method of accessing those attributes. We do however offer XML and Excel exports which include those worklog attributes:

http://wiki.tempoplugin.com/display/TEMPO/Tempo+Servlet+Manual#TempoServletManual-GetWorklogs

Cheers,

Benedikt

Thank you!

Marco

I've found where I can see the attribute!!!

In Tempo > Report, on the right there is "Worklog" and with Views, I can add my attribute.

Wonderful!!

But where is saved in the db???

Regards,

Marco

Hi Marco,

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

Ok!

Now I have removed the color and I have created a dynamic drop-down where the 2 value that I can select are: "ON SITE" and "REMOTE". They rapresent the position of the developer when he is working and he put the log work. So I can know who has work from home and who as work in the office.

I go to Tempo > Report, I have the issue with: Planned, Worked and Location (that have the select of on_site/remote).

If I want to make a personal report makinq queries on the db I can extract the value of plan and log work, but I can't finde the value of the Location.

Now I'm thinking that it could be stored in Jira Activity Objects plugin, like you wrote me. How can I catch that value for my personal report??

Kind regards,

Marco

The TEMPO guys never disclose where the TEMPO data is saved in the JIRA DB, isn't it?

 

If TEMPO keeps the tables constant, just providing the table names will save a lot of people their time.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in Featured Groups

Are you managing your users efficiently?

Hi everyone, I am Marek, a Senior Product Manager for Crowd   Server and Data Center   here at Atlassian. I would like to spark a discussion about challenges you have with managing use...

109 views 2 3
View post

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