Jira API Resource
|
Relational Parent Table(s)
|
Relational Child Table(s)
|
Application roles
|
ApplicationRoles
|
![]() ![]() |
Audit records
|
Auditing
|
![]() ![]() |
Dashboards
|
Dashboards
|
DashboardSharePermissions
|
Filters
|
Filters
|
![]() ![]() ![]() |
FilterDefaultColumns
|
NA
|
|
Groups
|
Groups
|
GroupLabels
|
GroupUsers
|
NA
|
|
Issue attachment
|
Attachments
|
NA
|
AttachmentMeta
|
NA
|
|
Issue comment properties
|
CommentProperty
|
NA
|
CommentPropertyKeys
|
NA
|
|
Issue comments
|
Comments
|
NA
|
Issue fields
|
Fields
|
FieldClauseNames
|
Issue link types
|
IssueLinkTypes
|
NA
|
Issue resolutions
|
Resolutions
|
NA
|
Issue types
|
IssueTypes
|
NA
|
Issue votes
|
Votes
|
Voters
|
Issue watchers
|
Watchers
|
NA
|
Issue worklogs
|
Worklogs
|
![]() ![]() |
Issues
|
Issues
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
IssueChangeLog
|
NA
|
|
IssueChangeLogItems
|
NA
|
|
IssueTransitions
|
NA
|
|
Comments:
![]()
SELECT TOP
or
SELECT ... LIMIT
![]() |
||
Jira expressions
|
Boards
|
NA
|
Epics
|
NA
|
|
Sprints
|
NA
|
|
Comments:The Sprints table requires either an ID or a KEY, in the Where clause.
|
||
Jira settings
|
AdvancedSettings
|
AdvancedSettingsAllowedValues
|
ApplicationProperties
|
ApplicationPropertiesAllowedValues
|
|
Configuration
|
NA
|
|
Permissions
|
MyPermissions
|
NA
|
Projects
|
Projects
|
ProjectIssueTypes
|
Project components
|
Components
|
NA
|
Project Versions
|
ProjectVersions
|
ProjectKey
|
Project role actors
|
Roles
|
RoleActors
|
Users
|
UserDetails
|
![]() ![]() ![]() |
Workflows
|
Workflows
|
NA
|