Time in Status

Time in Status Overview

 

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.

Time in Status fields are located in a separate Time In Status tab.

Supported Add-Ons - Time in Status.gif

 

How to Add Time in Status Token

 

Time in Status Token is required to export the Time in Status tables.

 

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

  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. Go back to Apps, and then select SQL Connector for Jira.

 

  1. On the left-side menu, select Tokens, and then select the Time in Status tab.

 

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

 

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