Calculated fields

SQL Connector for Jira allows to export data about the time issue spent in certain status and per assignee.

This is really helpful, as Jira users do not need to build complicated calculations between several tables on the SQL side, and that is really time-consuming. SQL Connector for Jira makes all the calculations automatically and allows to export ready-to-use data about Issue Time in Status and Issue Time by Assignee

Issue Time in Status

Field Name	Field ID	Description
Duration in 24/7	`DURATION_IN_NORMAL_HOURS`	The sum of time in seconds a task spent in particular status. The time is counted 24 hours 7 days a week.
Formatted Duration in 24/7	`DURATION_IN_NORMAL_HOURS_FORMATTED`	Shows `DURATION_IN_NORMAL_HOURS` formatted seconds to hh:mm:ss
Duration in Business Days (24/5)	`DURATION_IN_BUSINESS_DAYS_24H`	The sum of time in seconds a task spent in particular status. The time is counted 24 hours 5 days a week (Monday-Friday).
Formatted Duration in Business Days (24/5)	`DURATION_IN_BUSINESS_DAYS_24H_FORMATTED`	Shows `DURATION_IN_BUSINESS_DAYS_24H` formatted seconds to hh:mm:ss
Duration in Business Hours/Days (8/5)	`DURATION_IN_BUSINESS_DAYS_BH`	The sum of time in seconds a task spent in particular status. The time is counted 8 hours 5 days a week (Monday-Friday).
Formatted duration in Business Hours/Days (8/5)	`DURATION_IN_BUSINESS_DAYS_BH_FORMATTED`	Shows `DURATION_IN_BUSINESS_DAYS_BH` formatted seconds to hh:mm:ss
Issue in Status Count	`ISSUE_IN_STATUS_COUNT`	Shows the number of times an issue was in the status
First Transition to Status	`FIRST_TRANSITION_TO_STATUS`	Shows the date and time the issue was transitted to the status for the first time
Last Transition to Status	`LAST_TRANSITION_TO_STATUS`	Shows the date and time the issue was transitted to the status for the last time
First Transition From Status	`FIRST_TRANSITION_FROM_STATUS`	Shows the date and time the issue was transitted from the status for the first time
Last Transition From Status	`LAST_TRANSITION_FROM_STATUS`	Shows the date and time the issue was transitted from the status for the last time

Issue Time by Assignee

Field Name	Field ID	Description
Duration in 24/7	`DURATION_IN_NORMAL_HOURS`	The sum of time in seconds a task spent in particular status. The time is counted 24 hours 7 days a week.
Formatted Duration in 24/7	`DURATION_IN_NORMAL_HOURS_FORMATTED`	Shows `DURATION_IN_NORMAL_HOURS` formatted seconds to hh:mm:ss
Duration in Business Days (24/5)	`DURATION_IN_BUSINESS_DAYS_24H`	The sum of time in seconds a task spent in particular status. The time is counted 24 hours 5 days a week (Monday-Friday).
Formatted Duration in Business Days (24/5)	`DURATION_IN_BUSINESS_DAYS_24H_FORMATTED`	Shows `DURATION_IN_BUSINESS_DAYS_24H` formatted seconds to hh:mm:ss
Duration in Business Hours/Days (8/5)	`DURATION_IN_BUSINESS_DAYS_BH`	The sum of time in seconds a task spent in particular status. The time is counted 8 hours 5 days a week (Monday-Friday).
Formatted duration in Business Hours/Days (8/5)	`DURATION_IN_BUSINESS_DAYS_BH_FORMATTED`	Shows `DURATION_IN_BUSINESS_DAYS_BH` formatted seconds to hh:mm:ss