Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData Excel Add-In for Jira Views
| Name | Description |
| ActiveStatuses | Returns all statuses associated with active Jira workflows. This view provides a read-only list of workflow statuses along with their categories. To create, update, or delete statuses, use the Statuses table (Cloud only). |
| AdvancedSettings | Returns a list of advanced application properties configured in Jira, as displayed on the Advanced Settings page. |
| ApplicationRoles | Retrieves all configured application roles, which control user access and are managed through Jira's Application Access settings. |
| AssignableUsers | Returns users assignable to issues in a specific Jira project. |
| Audit | Retrieves audit log records, offering insights into changes and administrative actions performed within the Jira account. |
| BoardConfiguration | Displays the configuration settings of agile boards, including filters, estimation type, and card layout. |
| BoardIssues | Lists all issues displayed on agile boards, including their rank and column placement. |
| BoardSprints | Retrieves a list of sprints associated with a specific agile board, including active, future, and closed sprints. |
| Configuration | Returns system-level Jira configuration details, such as time tracking and attachment settings. |
| CustomFieldContext | Returns a list of contexts for a custom field in Jira. |
| Dashboards | Retrieves dashboards available to the user, including those shared with others or marked as favorites. |
| Epics | Lists all epics across Jira projects, including epic names, summaries, and keys. |
| FavouriteFilters | Returns filters marked as favorites by the current user, enabling easy access to commonly used searches. |
| Fields | Retrieves metadata about all fields available in Jira, including both system-defined and custom fields. |
| GroupsUsers | Retrieves mappings between users and their associated groups. |
| IssueAffectedVersions | Returns the software versions affected by specific issues, indicating where the bug or feature is observed. |
| IssueChangelogs | Provides a detailed history of changes made to issues, including field changes, timestamps, and authors. |
| IssueComponents | Lists components assigned to issues, which typically represent parts or modules of a project. |
| IssueCustomFields | Retrieves metadata and configuration of custom fields created in the Jira instance. |
| IssueFixVersions | Returns the list of versions in which specific issues are expected to be resolved. |
| IssueLinks | Displays relationships between issues, such as 'blocks', 'duplicates', or 'relates to'. |
| IssueLinkTypes | Lists all available link types that can be used to create relationships between issues. |
| IssueNavigatorDefaultColumns | Retrieves the default column layout for the issue navigator, which defines which fields are shown in search results. |
| IssuePriorities | Returns all priority levels available in the Jira instance, such as 'High', 'Medium', and 'Low'. |
| IssueResolutions | Retrieves all resolution values used to indicate how issues were completed, such as 'Fixed' or 'Won't Fix'. |
| IssueSubtasks | Lists all subtasks associated with Jira issues, including parent-child relationships and statuses. |
| IssuesUsers | Returns the available Users in Jira and their issues. |
| IssueTransitions | Displays all possible transitions for issues, including available status changes and transition rules. |
| MyPermissions | Returns the permissions granted to the current user based on their roles and group memberships. |
| Permissions | Lists the complete set of permissions available in Jira, such as 'Browse Projects' or 'Edit Issues'. |
| PermissionSchemes | Retrieves defined permission schemes, which are used to manage access control across Jira projects. |
| ProjectCategories | Lists all available project categories, which are used to organize and group Jira projects. |
| ProjectRoles | Retrieves role definitions that can be assigned across projects, such as 'Developers' or 'Administrators'. |
| ProjectsIssueTypes | Displays issue types configured for each project, including standard and custom issue types. |
| ProjectsPermissionScheme | Returns the permission scheme currently assigned to each project. |
| ProjectsUsers | Returns the available users in Jira and their projects. |
| ProjectTypes | Lists all available project types in Jira, such as business, software, or service management projects. |
| SecurityLevels | Returns all configured security levels, which determine visibility of issues for specific users or groups. |
| SecuritySchemes | Lists security schemes that group security levels and apply them to Jira projects. |
| SprintIssues | Retrieves issues assigned to agile sprints, including their rank and progress within the sprint. |
| Votes | Returns the available votes in Jira. |
| WorkflowStatusCategories | Lists all status categories such as 'To Do', 'In Progress', or 'Done' used to group workflow statuses visually. |
| WorklogDeleted | Retrieves records of deleted worklogs, useful for audit trails or troubleshooting time tracking inconsistencies. |