Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,445
Community Members
 
Community Events
165
Community Groups

MicrosoftSQL-statement für Jira Tempo Timesheets - 11.5.0

Hi,

 

I need help with the SQL statement.

Namely, we need information like:

 

DATUM - Date for the time booking 

DETAIL - Description of the activity carried out 

PROJEKT - PROJECTKEY

auftrg - account 

STD - Time in industrial hours 

ErfDatum - Acquisition date 

teilprojekt - custom fields

bereich - custom field

sendDatum - Modification date (if there has been a change )

sendUser - User of the last change of entries

 

the problem is that all the tables are very scattered. Can help from someone who has already had a similar request?

 

best regards

1 answer

1 accepted

1 vote
Answer accepted

The Jira database really isn't intended for any form of reporting, and I strongly recommend that you stop reading it.  It's the worst possible way to get data out of Jira.

The REST API for Jira and Tempo can easily return all of that data in a very simple call, rather than the 30-50 joins you are going to need to do to try to get it in SQL.

Hallo @Nic Brough _Adaptavist_ 

 

Alright. Can you refer me to the documentation on how to get the requested via the REST API?

 

Best regards

I think you need https://apidocs.tempo.io/#worklogs

But check the panel to the left for other areas that might be useful

Hi @Jurica Petricevic

The documentation that Nic refers to is for the Cloud version of Tempo.

For the Tempo Server REST API documentation, please take a look at https://www.tempo.io/server-api-documentation.

As most of the information you are looking for is native JIRA data, you might also want to take a look at https://docs.atlassian.com/software/jira/docs/api/REST/8.13.1/.
Please note that this documentation is JIRA version specific.

Best regards,
Susanne Götz
Tempo team 

Like Jurica Petricevic likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: AppLiger

This month the spotlight is on AppLiger. We caught up with Pavel Pavlovsky, CEO and Product Manager, to learn how the company started and what fuels the team's creativity.    Atlassian:...

388 views 0 7
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you