MicrosoftSQL-statement für Jira Tempo Timesheets - 11.5.0

[Jurica Petricevic]

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

[Nic Brough -Adaptavist- · Accepted solution]

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.

[Jurica Petricevic]

Hallo @Nic Brough -Adaptavist- 

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

Best regards

[Nic Brough -Adaptavist-]

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

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

[Susanne Götz _Tempo_]

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 

[Jurica Petricevic]

Thanks a lot to both of you @Susanne Götz _Tempo_ @Nic Brough -Adaptavist- 

Best regards