Excel Add-In for Jira

Build 25.0.9434

Configuration

Returns system-level Jira configuration details, such as time tracking and attachment settings.

Table Specific Information

Select

The add-in processes all filters specified on this table client-side within the add-in.

SELECT * FROM Configuration

Columns

Name Type References SupportedOperators Platform Description
VotingEnabled Boolean Common Indicates whether users are allowed to vote on issues to signal importance or interest.
WatchingEnabled Boolean Common Specifies whether users can watch issues to receive notifications about updates or changes.
UnassignedIssuesAllowed Boolean Common Determines whether issues can remain unassigned, without a designated responsible user.
SubTasksEnabled Boolean Common Specifies whether sub-tasks can be created under standard issues to break down work into smaller pieces.
IssueLinkingEnabled Boolean Common Indicates whether issues can be linked to each other using relationship types such as 'blocks' or 'relates to'.
TimeTrackingEnabled Boolean Common Controls whether time tracking features, such as logging work and estimating time, are enabled.
AttachmentsEnabled Boolean Common Determines whether users can upload attachments to issues, such as documents, screenshots, or logs.
WorkingHoursPerDay Double Common Specifies the standard number of working hours per day, used in time tracking and reporting.
WorkingDaysPerWeek Double Common Specifies the standard number of working days per week, typically used for capacity planning and time estimation.
TimeFormat String Common The format used to display time values, such as 12-hour or 24-hour format.
DefaultUnit String Common The default unit of time used in Jira, such as minutes, hours, or days, for time tracking and estimation.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434