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?
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.
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.
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:...
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