Timepiece (Time in Status)

Owned by Nataliya Timoshina
Last updated: Aug 12, 2024 by Liliia Ostrovska
3 min read

Timepiece Overview

 

Timepiece - formerly Time in Status app (from OBSS Marketplace Partner) is used to identify bottlenecks in the business processes by allowing users to easily create reports on issues that show how much time each issue spent on each status, assignee, or group. This information is critically important when building complex reporting for business analytics purposes. Thus, being able to export Time is Status data to SQL databases is a commonly used feature in SQL Connector for Jira.

Timepiece fields are located in a separate Timepiece tab.

timepiece-tables.gif

 

How to Add Timepiece Token

 

Timepiece token is required to export the Timepiece tables.

 

  1. Being signed in to your Jira Cloud instance, select Apps, and then select Timepiece.

apps-timepiece-time-in-status.gif

  1. Select , and then select API Settings.

For more information related to API Settings, please refer to this article.

  1. Select Create New Token.

  1. In the Notes field, enter SQL Connector for Time in Status or any other convenient name, and then select Save.

The Your token is ready pop-window will appear.

 

  1. Copy your token, and then close the window.

Before closing the window, make sure to copy your token, you won’t see it again. Store it safely as it has access to your data.

  1. Return to Apps, and then select SQL Connector for Jira.

apps-sql-connector-for-jira.gif

 

  1. On the left-side menu, select API Integrations, and then select the Timepiece tab.

api-int-timepiece-time-in-status.gif

 

  1. In the Token* field, paste your token, and then select Validate & Save.

api-int-timepiece-time-in-status-validate-and-save.gif

 

Starting now, all users with granted permission to work with the data sources can select Timepiece (Time in Status) tables and fields for export.

timepiece-time-in-status-tables.gif