Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

0 votes
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

Thanks a lot to both of you @Susanne Götz @Nic Brough _Adaptavist_ 

 

Best regards

Suggest an answer

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

🤺 Atlympic Event: Partnerships

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

151 views 2 6
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