Windsor brings all your Jira data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Jira Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| application_roles__defaultgroups | OBJECT | application_roles.defaultGroups | application_roles.defaultGroups | application_roles |
| application_roles__defaultgroupsdetails | OBJECT | application_roles.defaultGroupsDetails | application_roles.defaultGroupsDetails | application_roles |
| application_roles__defined | BOOLEAN | application_roles.defined | application_roles.defined | application_roles |
| application_roles__groupdetails | OBJECT | application_roles.groupDetails | application_roles.groupDetails | application_roles |
| application_roles__groups | OBJECT | application_roles.groups | application_roles.groups | application_roles |
| application_roles__hasunlimitedseats | BOOLEAN | application_roles.hasUnlimitedSeats | application_roles.hasUnlimitedSeats | application_roles |
| application_roles__key | TEXT | application_roles.key | application_roles.key | application_roles |
| application_roles__name | TEXT | application_roles.name | application_roles.name | application_roles |
| application_roles__numberofseats | NUMERIC | application_roles.numberOfSeats | application_roles.numberOfSeats | application_roles |
| application_roles__platform | BOOLEAN | application_roles.platform | application_roles.platform | application_roles |
| application_roles__remainingseats | NUMERIC | application_roles.remainingSeats | application_roles.remainingSeats | application_roles |
| application_roles__selectedbydefault | BOOLEAN | application_roles.selectedByDefault | application_roles.selectedByDefault | application_roles |
| application_roles__usercount | NUMERIC | application_roles.userCount | application_roles.userCount | application_roles |
| application_roles__usercountdescription | TEXT | application_roles.userCountDescription | application_roles.userCountDescription | application_roles |
| avatars__filename | TEXT | avatars.fileName | avatars.fileName | avatars |
| avatars__id | TEXT | avatars.id | avatars.id | avatars |
| avatars__isdeletable | BOOLEAN | avatars.isDeletable | avatars.isDeletable | avatars |
| avatars__isselected | BOOLEAN | avatars.isSelected | avatars.isSelected | avatars |
| avatars__issystemavatar | BOOLEAN | avatars.isSystemAvatar | avatars.isSystemAvatar | avatars |
| avatars__owner | TEXT | avatars.owner | avatars.owner | avatars |
| avatars__urls | OBJECT | avatars.urls | avatars.urls | avatars |
| board_issues__boardid | NUMERIC | board_issues.boardId | board_issues.boardId | board_issues |
| board_issues__created | TEXT | board_issues.created | board_issues.created | board_issues |
| board_issues__expand | TEXT | board_issues.expand | board_issues.expand | board_issues |
| board_issues__fields | OBJECT | board_issues.fields | board_issues.fields | board_issues |
| board_issues__id | TEXT | board_issues.id | board_issues.id | board_issues |
| board_issues__key | TEXT | board_issues.key | board_issues.key | board_issues |
| board_issues__self | TEXT | board_issues.self | board_issues.self | board_issues |
| board_issues__updated | TEXT | board_issues.updated | board_issues.updated | board_issues |
| boards__id | NUMERIC | boards.id | boards.id | boards |
| boards__location | OBJECT | boards.location | boards.location | boards |
| boards__name | TEXT | boards.name | boards.name | boards |
| boards__projectid | TEXT | boards.projectId | boards.projectId | boards |
| boards__projectkey | TEXT | boards.projectKey | boards.projectKey | boards |
| boards__self | TEXT | boards.self | boards.self | boards |
| boards__type | TEXT | boards.type | boards.type | boards |
| dashboards__description | TEXT | dashboards.description | dashboards.description | dashboards |
| dashboards__editpermission | OBJECT | dashboards.editpermission | dashboards.editpermission | dashboards |
| dashboards__editpermissions | OBJECT | dashboards.editPermissions | dashboards.editPermissions | dashboards |
| dashboards__id | TEXT | dashboards.id | dashboards.id | dashboards |
| dashboards__isfavourite | BOOLEAN | dashboards.isFavourite | dashboards.isFavourite | dashboards |
| dashboards__iswritable | BOOLEAN | dashboards.isWritable | dashboards.isWritable | dashboards |
| dashboards__name | TEXT | dashboards.name | dashboards.name | dashboards |
| dashboards__owner | OBJECT | dashboards.owner | dashboards.owner | dashboards |
| dashboards__popularity | NUMERIC | dashboards.popularity | dashboards.popularity | dashboards |
| dashboards__rank | NUMERIC | dashboards.rank | dashboards.rank | dashboards |
| dashboards__self | TEXT | dashboards.self | dashboards.self | dashboards |
| dashboards__sharepermissions | OBJECT | dashboards.sharePermissions | dashboards.sharePermissions | dashboards |
| dashboards__systemdashboard | BOOLEAN | dashboards.systemDashboard | dashboards.systemDashboard | dashboards |
| dashboards__view | TEXT | dashboards.view | dashboards.view | dashboards |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| filter_sharing__filterid | TEXT | filter_sharing.filterId | filter_sharing.filterId | filter_sharing |
| filter_sharing__group | OBJECT | filter_sharing.group | filter_sharing.group | filter_sharing |
| filter_sharing__id | NUMERIC | filter_sharing.id | filter_sharing.id | filter_sharing |
| filter_sharing__project | OBJECT | filter_sharing.project | filter_sharing.project | filter_sharing |
| filter_sharing__role | OBJECT | filter_sharing.role | filter_sharing.role | filter_sharing |
| filter_sharing__type | TEXT | filter_sharing.type | filter_sharing.type | filter_sharing |
| filters__approximatelastused | TEXT | filters.approximateLastUsed | filters.approximateLastUsed | filters |
| filters__description | TEXT | filters.description | filters.description | filters |
| filters__expand | TEXT | filters.expand | filters.expand | filters |
| filters__favourite | BOOLEAN | filters.favourite | filters.favourite | filters |
| filters__favouritedcount | NUMERIC | filters.favouritedCount | filters.favouritedCount | filters |
| filters__id | TEXT | filters.id | filters.id | filters |
| filters__iswritable | BOOLEAN | filters.isWritable | filters.isWritable | filters |
| filters__jql | TEXT | filters.jql | filters.jql | filters |
| filters__name | TEXT | filters.name | filters.name | filters |
| filters__owner | OBJECT | filters.owner | filters.owner | filters |
| filters__searchurl | TEXT | filters.searchUrl | filters.searchUrl | filters |
| filters__self | TEXT | filters.self | filters.self | filters |
| filters__sharepermissions | OBJECT | filters.sharePermissions | filters.sharePermissions | filters |
| filters__subscriptions | OBJECT | filters.subscriptions | filters.subscriptions | filters |
| filters__viewurl | TEXT | filters.viewUrl | filters.viewUrl | filters |
| groups__groupid | TEXT | groups.groupId | groups.groupId | groups |
| groups__name | TEXT | groups.name | groups.name | groups |
| issue_comments__author | TEXT | issue_comments.author | issue_comments.author | issue_comments |
| issue_comments__body | OBJECT | issue_comments.body | issue_comments.body | issue_comments |
| issue_comments__created | TEXT | issue_comments.created | issue_comments.created | issue_comments |
| issue_comments__id | TEXT | issue_comments.id | issue_comments.id | issue_comments |
| issue_comments__issueid | TEXT | issue_comments.issueId | issue_comments.issueId | issue_comments |
| issue_comments__jsdpublic | BOOLEAN | issue_comments.jsdPublic | issue_comments.jsdPublic | issue_comments |
| issue_comments__properties | OBJECT | issue_comments.properties | issue_comments.properties | issue_comments |
| issue_comments__renderedbody | TEXT | issue_comments.renderedBody | issue_comments.renderedBody | issue_comments |
| issue_comments__self | TEXT | issue_comments.self | issue_comments.self | issue_comments |
| issue_comments__updateauthor | OBJECT | issue_comments.updateAuthor | issue_comments.updateAuthor | issue_comments |
| issue_comments__updated | TEXT | issue_comments.updated | issue_comments.updated | issue_comments |
| issue_comments__visibility | OBJECT | issue_comments.visibility | issue_comments.visibility | issue_comments |
| issue_custom_field_contexts__description | TEXT | issue_custom_field_contexts.description | issue_custom_field_contexts.description | issue_custom_field_contexts |
| issue_custom_field_contexts__fieldid | TEXT | issue_custom_field_contexts.fieldId | issue_custom_field_contexts.fieldId | issue_custom_field_contexts |
| issue_custom_field_contexts__fieldtype | TEXT | issue_custom_field_contexts.fieldType | issue_custom_field_contexts.fieldType | issue_custom_field_contexts |
| issue_custom_field_contexts__id | TEXT | issue_custom_field_contexts.id | issue_custom_field_contexts.id | issue_custom_field_contexts |
| issue_custom_field_contexts__isanyissuetype | BOOLEAN | issue_custom_field_contexts.isAnyIssueType | issue_custom_field_contexts.isAnyIssueType | issue_custom_field_contexts |
| issue_custom_field_contexts__isglobalcontext | BOOLEAN | issue_custom_field_contexts.isGlobalContext | issue_custom_field_contexts.isGlobalContext | issue_custom_field_contexts |
| issue_custom_field_contexts__name | TEXT | issue_custom_field_contexts.name | issue_custom_field_contexts.name | issue_custom_field_contexts |
| issue_custom_field_options__contextid | TEXT | issue_custom_field_options.contextId | issue_custom_field_options.contextId | issue_custom_field_options |
| issue_custom_field_options__disabled | BOOLEAN | issue_custom_field_options.disabled | issue_custom_field_options.disabled | issue_custom_field_options |
| issue_custom_field_options__fieldid | TEXT | issue_custom_field_options.fieldId | issue_custom_field_options.fieldId | issue_custom_field_options |
| issue_custom_field_options__id | TEXT | issue_custom_field_options.id | issue_custom_field_options.id | issue_custom_field_options |
| issue_custom_field_options__optionid | TEXT | issue_custom_field_options.optionId | issue_custom_field_options.optionId | issue_custom_field_options |
| issue_custom_field_options__value | TEXT | issue_custom_field_options.value | issue_custom_field_options.value | issue_custom_field_options |
| issue_field_configurations__description | TEXT | issue_field_configurations.description | issue_field_configurations.description | issue_field_configurations |
| issue_field_configurations__id | NUMERIC | issue_field_configurations.id | issue_field_configurations.id | issue_field_configurations |
| issue_field_configurations__isdefault | BOOLEAN | issue_field_configurations.isDefault | issue_field_configurations.isDefault | issue_field_configurations |
| issue_field_configurations__name | TEXT | issue_field_configurations.name | issue_field_configurations.name | issue_field_configurations |
| issue_fields__clausenames | OBJECT | issue_fields.clauseNames | issue_fields.clauseNames | issue_fields |
| issue_fields__custom | BOOLEAN | issue_fields.custom | issue_fields.custom | issue_fields |
| issue_fields__id | TEXT | issue_fields.id | issue_fields.id | issue_fields |
| issue_fields__key | TEXT | issue_fields.key | issue_fields.key | issue_fields |
| issue_fields__name | TEXT | issue_fields.name | issue_fields.name | issue_fields |
| issue_fields__navigable | BOOLEAN | issue_fields.navigable | issue_fields.navigable | issue_fields |
| issue_fields__orderable | BOOLEAN | issue_fields.orderable | issue_fields.orderable | issue_fields |
| issue_fields__schema | OBJECT | issue_fields.schema | issue_fields.schema | issue_fields |
| issue_fields__scope | OBJECT | issue_fields.scope | issue_fields.scope | issue_fields |
| issue_fields__searchable | BOOLEAN | issue_fields.searchable | issue_fields.searchable | issue_fields |
| issue_fields__untranslatedname | TEXT | issue_fields.untranslatedName | issue_fields.untranslatedName | issue_fields |
| issue_link_types__id | TEXT | issue_link_types.id | issue_link_types.id | issue_link_types |
| issue_link_types__inward | TEXT | issue_link_types.inward | issue_link_types.inward | issue_link_types |
| issue_link_types__name | TEXT | issue_link_types.name | issue_link_types.name | issue_link_types |
| issue_link_types__outward | TEXT | issue_link_types.outward | issue_link_types.outward | issue_link_types |
| issue_link_types__self | TEXT | issue_link_types.self | issue_link_types.self | issue_link_types |
| issue_navigator_settings__label | TEXT | issue_navigator_settings.label | issue_navigator_settings.label | issue_navigator_settings |
| issue_navigator_settings__value | TEXT | issue_navigator_settings.value | issue_navigator_settings.value | issue_navigator_settings |
| issue_notification_schemes__description | TEXT | issue_notification_schemes.description | issue_notification_schemes.description | issue_notification_schemes |
| issue_notification_schemes__expand | TEXT | issue_notification_schemes.expand | issue_notification_schemes.expand | issue_notification_schemes |
| issue_notification_schemes__id | NUMERIC | issue_notification_schemes.id | issue_notification_schemes.id | issue_notification_schemes |
| issue_notification_schemes__name | TEXT | issue_notification_schemes.name | issue_notification_schemes.name | issue_notification_schemes |
| issue_notification_schemes__notificationschemeevents | OBJECT | issue_notification_schemes.notificationSchemeEvents | issue_notification_schemes.notificationSchemeEvents | issue_notification_schemes |
| issue_notification_schemes__scope | OBJECT | issue_notification_schemes.scope | issue_notification_schemes.scope | issue_notification_schemes |
| issue_notification_schemes__self | TEXT | issue_notification_schemes.self | issue_notification_schemes.self | issue_notification_schemes |
| issue_priorities__description | TEXT | issue_priorities.description | issue_priorities.description | issue_priorities |
| issue_priorities__iconurl | TEXT | issue_priorities.iconUrl | issue_priorities.iconUrl | issue_priorities |
| issue_priorities__id | TEXT | issue_priorities.id | issue_priorities.id | issue_priorities |
| issue_priorities__isdefault | BOOLEAN | issue_priorities.isDefault | issue_priorities.isDefault | issue_priorities |
| issue_priorities__name | TEXT | issue_priorities.name | issue_priorities.name | issue_priorities |
| issue_priorities__self | TEXT | issue_priorities.self | issue_priorities.self | issue_priorities |
| issue_priorities__statuscolor | TEXT | issue_priorities.statusColor | issue_priorities.statusColor | issue_priorities |
| issue_properties__isdefault | BOOLEAN | issue_properties.isdefault | issue_properties.isdefault | issue_properties |
| issue_properties__issueid | TEXT | issue_properties.issueId | issue_properties.issueId | issue_properties |
| issue_properties__key | TEXT | issue_properties.key | issue_properties.key | issue_properties |
| issue_properties__value | TEXT | issue_properties.value | issue_properties.value | issue_properties |
| issue_remote_links__application | OBJECT | issue_remote_links.application | issue_remote_links.application | issue_remote_links |
| issue_remote_links__globalid | TEXT | issue_remote_links.globalId | issue_remote_links.globalId | issue_remote_links |
| issue_remote_links__id | NUMERIC | issue_remote_links.id | issue_remote_links.id | issue_remote_links |
| issue_remote_links__issueid | TEXT | issue_remote_links.issueId | issue_remote_links.issueId | issue_remote_links |
| issue_remote_links__object | OBJECT | issue_remote_links.object | issue_remote_links.object | issue_remote_links |
| issue_remote_links__relationship | TEXT | issue_remote_links.relationship | issue_remote_links.relationship | issue_remote_links |
| issue_remote_links__self | TEXT | issue_remote_links.self | issue_remote_links.self | issue_remote_links |
| issue_resolutions__description | TEXT | issue_resolutions.description | issue_resolutions.description | issue_resolutions |
| issue_resolutions__id | TEXT | issue_resolutions.id | issue_resolutions.id | issue_resolutions |
| issue_resolutions__isdefault | BOOLEAN | issue_resolutions.isDefault | issue_resolutions.isDefault | issue_resolutions |
| issue_resolutions__name | TEXT | issue_resolutions.name | issue_resolutions.name | issue_resolutions |
| issue_resolutions__self | TEXT | issue_resolutions.self | issue_resolutions.self | issue_resolutions |
| issue_security_schemes__defaultsecuritylevelid | NUMERIC | issue_security_schemes.defaultSecurityLevelId | issue_security_schemes.defaultSecurityLevelId | issue_security_schemes |
| issue_security_schemes__description | TEXT | issue_security_schemes.description | issue_security_schemes.description | issue_security_schemes |
| issue_security_schemes__id | NUMERIC | issue_security_schemes.id | issue_security_schemes.id | issue_security_schemes |
| issue_security_schemes__levels | OBJECT | issue_security_schemes.levels | issue_security_schemes.levels | issue_security_schemes |
| issue_security_schemes__name | TEXT | issue_security_schemes.name | issue_security_schemes.name | issue_security_schemes |
| issue_security_schemes__self | TEXT | issue_security_schemes.self | issue_security_schemes.self | issue_security_schemes |
| issue_transitions__fields | TEXT | issue_transitions.fields | issue_transitions.fields | issue_transitions |
| issue_transitions__hasscreen | BOOLEAN | issue_transitions.hasScreen | issue_transitions.hasScreen | issue_transitions |
| issue_transitions__id | TEXT | issue_transitions.id | issue_transitions.id | issue_transitions |
| issue_transitions__isavailable | BOOLEAN | issue_transitions.isAvailable | issue_transitions.isAvailable | issue_transitions |
| issue_transitions__isconditional | BOOLEAN | issue_transitions.isConditional | issue_transitions.isConditional | issue_transitions |
| issue_transitions__isglobal | BOOLEAN | issue_transitions.isGlobal | issue_transitions.isGlobal | issue_transitions |
| issue_transitions__isinitial | BOOLEAN | issue_transitions.isInitial | issue_transitions.isInitial | issue_transitions |
| issue_transitions__islooped | BOOLEAN | issue_transitions.isLooped | issue_transitions.isLooped | issue_transitions |
| issue_transitions__issueid | TEXT | issue_transitions.issueId | issue_transitions.issueId | issue_transitions |
| issue_transitions__name | TEXT | issue_transitions.name | issue_transitions.name | issue_transitions |
| issue_transitions__to | OBJECT | issue_transitions.to | issue_transitions.to | issue_transitions |
| issue_type_schemes__defaultissuetypeid | TEXT | issue_type_schemes.defaultIssueTypeId | issue_type_schemes.defaultIssueTypeId | issue_type_schemes |
| issue_type_schemes__description | TEXT | issue_type_schemes.description | issue_type_schemes.description | issue_type_schemes |
| issue_type_schemes__id | TEXT | issue_type_schemes.id | issue_type_schemes.id | issue_type_schemes |
| issue_type_schemes__isdefault | BOOLEAN | issue_type_schemes.isDefault | issue_type_schemes.isDefault | issue_type_schemes |
| issue_type_schemes__name | TEXT | issue_type_schemes.name | issue_type_schemes.name | issue_type_schemes |
| issue_type_screen_schemes__description | TEXT | issue_type_screen_schemes.description | issue_type_screen_schemes.description | issue_type_screen_schemes |
| issue_type_screen_schemes__id | TEXT | issue_type_screen_schemes.id | issue_type_screen_schemes.id | issue_type_screen_schemes |
| issue_type_screen_schemes__name | TEXT | issue_type_screen_schemes.name | issue_type_screen_schemes.name | issue_type_screen_schemes |
| issue_types__avatarid | NUMERIC | issue_types.avatarId | issue_types.avatarId | issue_types |
| issue_types__description | TEXT | issue_types.description | issue_types.description | issue_types |
| issue_types__entityid | TEXT | issue_types.entityId | issue_types.entityId | issue_types |
| issue_types__hierarchylevel | NUMERIC | issue_types.hierarchyLevel | issue_types.hierarchyLevel | issue_types |
| issue_types__iconurl | TEXT | issue_types.iconUrl | issue_types.iconUrl | issue_types |
| issue_types__id | TEXT | issue_types.id | issue_types.id | issue_types |
| issue_types__name | TEXT | issue_types.name | issue_types.name | issue_types |
| issue_types__scope | OBJECT | issue_types.scope | issue_types.scope | issue_types |
| issue_types__self | TEXT | issue_types.self | issue_types.self | issue_types |
| issue_types__subtask | BOOLEAN | issue_types.subtask | issue_types.subtask | issue_types |
| issue_types__untranslatedname | TEXT | issue_types.untranslatedName | issue_types.untranslatedName | issue_types |
| issue_votes__hasvoted | BOOLEAN | issue_votes.hasVoted | issue_votes.hasVoted | issue_votes |
| issue_votes__issueid | TEXT | issue_votes.issueId | issue_votes.issueId | issue_votes |
| issue_votes__self | TEXT | issue_votes.self | issue_votes.self | issue_votes |
| issue_votes__voters | OBJECT | issue_votes.voters | issue_votes.voters | issue_votes |
| issue_votes__votes | NUMERIC | issue_votes.votes | issue_votes.votes | issue_votes |
| issue_watchers__issueid | TEXT | issue_watchers.issueId | issue_watchers.issueId | issue_watchers |
| issue_watchers__iswatching | BOOLEAN | issue_watchers.isWatching | issue_watchers.isWatching | issue_watchers |
| issue_watchers__self | TEXT | issue_watchers.self | issue_watchers.self | issue_watchers |
| issue_watchers__watchcount | NUMERIC | issue_watchers.watchCount | issue_watchers.watchCount | issue_watchers |
| issue_watchers__watchers | OBJECT | issue_watchers.watchers | issue_watchers.watchers | issue_watchers |
| issue_worklogs__author | OBJECT | issue_worklogs.author | issue_worklogs.author | issue_worklogs |
| issue_worklogs__comment | OBJECT | issue_worklogs.comment | issue_worklogs.comment | issue_worklogs |
| issue_worklogs__created | TEXT | issue_worklogs.created | issue_worklogs.created | issue_worklogs |
| issue_worklogs__id | TEXT | issue_worklogs.id | issue_worklogs.id | issue_worklogs |
| issue_worklogs__issueid | TEXT | issue_worklogs.issueId | issue_worklogs.issueId | issue_worklogs |
| issue_worklogs__properties | OBJECT | issue_worklogs.properties | issue_worklogs.properties | issue_worklogs |
| issue_worklogs__self | TEXT | issue_worklogs.self | issue_worklogs.self | issue_worklogs |
| issue_worklogs__started | TEXT | issue_worklogs.started | issue_worklogs.started | issue_worklogs |
| issue_worklogs__timespent | TEXT | issue_worklogs.timeSpent | issue_worklogs.timeSpent | issue_worklogs |
| issue_worklogs__timespentseconds | NUMERIC | issue_worklogs.timeSpentSeconds | issue_worklogs.timeSpentSeconds | issue_worklogs |
| issue_worklogs__updateauthor | OBJECT | issue_worklogs.updateAuthor | issue_worklogs.updateAuthor | issue_worklogs |
| issue_worklogs__updated | TEXT | issue_worklogs.updated | issue_worklogs.updated | issue_worklogs |
| issue_worklogs__visibility | OBJECT | issue_worklogs.visibility | issue_worklogs.visibility | issue_worklogs |
| issues__changelog | OBJECT | issues.changelog | issues.changelog | issues |
| issues__created | TEXT | issues.created | issues.created | issues |
| issues__editmeta | OBJECT | issues.editmeta | issues.editmeta | issues |
| issues__expand | TEXT | issues.expand | issues.expand | issues |
| issues__fields | OBJECT | issues.fields | issues.fields | issues |
| issues__fieldstoinclude | OBJECT | issues.fieldsToInclude | issues.fieldsToInclude | issues |
| issues__id | TEXT | issues.id | issues.id | issues |
| issues__key | TEXT | issues.key | issues.key | issues |
| issues__names | OBJECT | issues.names | issues.names | issues |
| issues__operations | OBJECT | issues.operations | issues.operations | issues |
| issues__projectid | TEXT | issues.projectId | issues.projectId | issues |
| issues__projectkey | TEXT | issues.projectKey | issues.projectKey | issues |
| issues__properties | OBJECT | issues.properties | issues.properties | issues |
| issues__renderedfields | OBJECT | issues.renderedFields | issues.renderedFields | issues |
| issues__schema | OBJECT | issues.schema | issues.schema | issues |
| issues__self | TEXT | issues.self | issues.self | issues |
| issues__transitions | OBJECT | issues.transitions | issues.transitions | issues |
| issues__updated | TEXT | issues.updated | issues.updated | issues |
| issues__versionedrepresentations | OBJECT | issues.versionedRepresentations | issues.versionedRepresentations | issues |
| jira_settings__allowedvalues | OBJECT | jira_settings.allowedValues | jira_settings.allowedValues | jira_settings |
| jira_settings__defaultvalue | TEXT | jira_settings.defaultValue | jira_settings.defaultValue | jira_settings |
| jira_settings__desc | TEXT | jira_settings.desc | jira_settings.desc | jira_settings |
| jira_settings__example | TEXT | jira_settings.example | jira_settings.example | jira_settings |
| jira_settings__id | TEXT | jira_settings.id | jira_settings.id | jira_settings |
| jira_settings__key | TEXT | jira_settings.key | jira_settings.key | jira_settings |
| jira_settings__name | TEXT | jira_settings.name | jira_settings.name | jira_settings |
| jira_settings__type | TEXT | jira_settings.type | jira_settings.type | jira_settings |
| jira_settings__value | TEXT | jira_settings.value | jira_settings.value | jira_settings |
| labels__label | TEXT | labels.label | labels.label | labels |
| permission_schemes__description | TEXT | permission_schemes.description | permission_schemes.description | permission_schemes |
| permission_schemes__expand | TEXT | permission_schemes.expand | permission_schemes.expand | permission_schemes |
| permission_schemes__id | NUMERIC | permission_schemes.id | permission_schemes.id | permission_schemes |
| permission_schemes__name | TEXT | permission_schemes.name | permission_schemes.name | permission_schemes |
| permission_schemes__permissions | OBJECT | permission_schemes.permissions | permission_schemes.permissions | permission_schemes |
| permission_schemes__scope | OBJECT | permission_schemes.scope | permission_schemes.scope | permission_schemes |
| permission_schemes__self | TEXT | permission_schemes.self | permission_schemes.self | permission_schemes |
| permissions__description | TEXT | permissions.description | permissions.description | permissions |
| permissions__key | TEXT | permissions.key | permissions.key | permissions |
| permissions__name | TEXT | permissions.name | permissions.name | permissions |
| permissions__type | TEXT | permissions.type | permissions.type | permissions |
| project_avatars__filename | TEXT | project_avatars.fileName | project_avatars.fileName | project_avatars |
| project_avatars__id | TEXT | project_avatars.id | project_avatars.id | project_avatars |
| project_avatars__isdeletable | BOOLEAN | project_avatars.isDeletable | project_avatars.isDeletable | project_avatars |
| project_avatars__isselected | BOOLEAN | project_avatars.isSelected | project_avatars.isSelected | project_avatars |
| project_avatars__issystemavatar | BOOLEAN | project_avatars.isSystemAvatar | project_avatars.isSystemAvatar | project_avatars |
| project_avatars__owner | TEXT | project_avatars.owner | project_avatars.owner | project_avatars |
| project_avatars__projectid | TEXT | project_avatars.projectId | project_avatars.projectId | project_avatars |
| project_avatars__urls | OBJECT | project_avatars.urls | project_avatars.urls | project_avatars |
| project_categories__description | TEXT | project_categories.description | project_categories.description | project_categories |
| project_categories__id | TEXT | project_categories.id | project_categories.id | project_categories |
| project_categories__name | TEXT | project_categories.name | project_categories.name | project_categories |
| project_categories__self | TEXT | project_categories.self | project_categories.self | project_categories |
| project_components__assignee | OBJECT | project_components.assignee | project_components.assignee | project_components |
| project_components__assigneetype | TEXT | project_components.assigneeType | project_components.assigneeType | project_components |
| project_components__componentbean | OBJECT | project_components.componentBean | project_components.componentBean | project_components |
| project_components__description | TEXT | project_components.description | project_components.description | project_components |
| project_components__id | TEXT | project_components.id | project_components.id | project_components |
| project_components__isassigneetypevalid | BOOLEAN | project_components.isAssigneeTypeValid | project_components.isAssigneeTypeValid | project_components |
| project_components__issuecount | NUMERIC | project_components.issueCount | project_components.issueCount | project_components |
| project_components__lead | OBJECT | project_components.lead | project_components.lead | project_components |
| project_components__leadaccountid | TEXT | project_components.leadAccountId | project_components.leadAccountId | project_components |
| project_components__leadusername | TEXT | project_components.leadUserName | project_components.leadUserName | project_components |
| project_components__name | TEXT | project_components.name | project_components.name | project_components |
| project_components__project | TEXT | project_components.project | project_components.project | project_components |
| project_components__projectid | NUMERIC | project_components.projectId | project_components.projectId | project_components |
| project_components__realassignee | OBJECT | project_components.realAssignee | project_components.realAssignee | project_components |
| project_components__realassigneetype | TEXT | project_components.realAssigneeType | project_components.realAssigneeType | project_components |
| project_components__self | TEXT | project_components.self | project_components.self | project_components |
| project_email__emailaddress | TEXT | project_email.emailAddress | project_email.emailAddress | project_email |
| project_email__projectid | TEXT | project_email.projectId | project_email.projectId | project_email |
| project_permission_schemes__description | TEXT | project_permission_schemes.description | project_permission_schemes.description | project_permission_schemes |
| project_permission_schemes__id | TEXT | project_permission_schemes.id | project_permission_schemes.id | project_permission_schemes |
| project_permission_schemes__name | TEXT | project_permission_schemes.name | project_permission_schemes.name | project_permission_schemes |
| project_permission_schemes__projectid | TEXT | project_permission_schemes.projectId | project_permission_schemes.projectId | project_permission_schemes |
| project_permission_schemes__self | TEXT | project_permission_schemes.self | project_permission_schemes.self | project_permission_schemes |
| project_roles__actors | OBJECT | project_roles.actors | project_roles.actors | project_roles |
| project_roles__admin | BOOLEAN | project_roles.admin | project_roles.admin | project_roles |
| project_roles__currentuserrole | BOOLEAN | project_roles.currentUserRole | project_roles.currentUserRole | project_roles |
| project_roles__default | BOOLEAN | project_roles.default | project_roles.default | project_roles |
| project_roles__description | TEXT | project_roles.description | project_roles.description | project_roles |
| project_roles__id | NUMERIC | project_roles.id | project_roles.id | project_roles |
| project_roles__name | TEXT | project_roles.name | project_roles.name | project_roles |
| project_roles__roleconfigurable | BOOLEAN | project_roles.roleConfigurable | project_roles.roleConfigurable | project_roles |
| project_roles__scope | OBJECT | project_roles.scope | project_roles.scope | project_roles |
| project_roles__self | TEXT | project_roles.self | project_roles.self | project_roles |
| project_roles__translatedname | TEXT | project_roles.translatedName | project_roles.translatedName | project_roles |
| project_types__color | TEXT | project_types.color | project_types.color | project_types |
| project_types__descriptioni18nkey | TEXT | project_types.descriptionI18nKey | project_types.descriptionI18nKey | project_types |
| project_types__formattedkey | TEXT | project_types.formattedKey | project_types.formattedKey | project_types |
| project_types__icon | TEXT | project_types.icon | project_types.icon | project_types |
| project_types__key | TEXT | project_types.key | project_types.key | project_types |
| project_versions__archived | BOOLEAN | project_versions.archived | project_versions.archived | project_versions |
| project_versions__description | TEXT | project_versions.description | project_versions.description | project_versions |
| project_versions__expand | TEXT | project_versions.expand | project_versions.expand | project_versions |
| project_versions__id | TEXT | project_versions.id | project_versions.id | project_versions |
| project_versions__issuesstatusforfixversion | OBJECT | project_versions.issuesStatusForFixVersion | project_versions.issuesStatusForFixVersion | project_versions |
| project_versions__moveunfixedissuesto | TEXT | project_versions.moveUnfixedIssuesTo | project_versions.moveUnfixedIssuesTo | project_versions |
| project_versions__name | TEXT | project_versions.name | project_versions.name | project_versions |
| project_versions__operations | OBJECT | project_versions.operations | project_versions.operations | project_versions |
| project_versions__overdue | BOOLEAN | project_versions.overdue | project_versions.overdue | project_versions |
| project_versions__project | TEXT | project_versions.project | project_versions.project | project_versions |
| project_versions__projectid | NUMERIC | project_versions.projectId | project_versions.projectId | project_versions |
| project_versions__released | BOOLEAN | project_versions.released | project_versions.released | project_versions |
| project_versions__releasedate | TEXT | project_versions.releaseDate | project_versions.releaseDate | project_versions |
| project_versions__self | TEXT | project_versions.self | project_versions.self | project_versions |
| project_versions__startdate | TEXT | project_versions.startDate | project_versions.startDate | project_versions |
| project_versions__userreleasedate | TEXT | project_versions.userReleaseDate | project_versions.userReleaseDate | project_versions |
| project_versions__userstartdate | TEXT | project_versions.userStartDate | project_versions.userStartDate | project_versions |
| projects__archived | BOOLEAN | projects.archived | projects.archived | projects |
| projects__archivedby | TEXT | projects.archivedBy | projects.archivedBy | projects |
| projects__archiveddate | TEXT | projects.archivedDate | projects.archivedDate | projects |
| projects__assigneetype | TEXT | projects.assigneeType | projects.assigneeType | projects |
| projects__avatarurls | TEXT | projects.avatarUrls | projects.avatarUrls | projects |
| projects__components | OBJECT | projects.components | projects.components | projects |
| projects__deleted | BOOLEAN | projects.deleted | projects.deleted | projects |
| projects__deletedby | TEXT | projects.deletedBy | projects.deletedBy | projects |
| projects__deleteddate | TEXT | projects.deletedDate | projects.deletedDate | projects |
| projects__description | TEXT | projects.description | projects.description | projects |
| projects__email | TEXT | projects.email | projects.email | projects |
| projects__entityid | TEXT | projects.entityId | projects.entityId | projects |
| projects__expand | TEXT | projects.expand | projects.expand | projects |
| projects__favourite | BOOLEAN | projects.favourite | projects.favourite | projects |
| projects__id | TEXT | projects.id | projects.id | projects |
| projects__insight | TEXT | projects.insight | projects.insight | projects |
| projects__isprivate | BOOLEAN | projects.isPrivate | projects.isPrivate | projects |
| projects__issuetypehierarchy | TEXT | projects.issueTypeHierarchy | projects.issueTypeHierarchy | projects |
| projects__issuetypes | OBJECT | projects.issueTypes | projects.issueTypes | projects |
| projects__key | TEXT | projects.key | projects.key | projects |
| projects__lead | TEXT | projects.lead | projects.lead | projects |
| projects__name | TEXT | projects.name | projects.name | projects |
| projects__permissions | TEXT | projects.permissions | projects.permissions | projects |
| projects__projectcategory | TEXT | projects.projectCategory | projects.projectCategory | projects |
| projects__projecttypekey | TEXT | projects.projectTypeKey | projects.projectTypeKey | projects |
| projects__properties | OBJECT | projects.properties | projects.properties | projects |
| projects__retentiontilldate | TEXT | projects.retentionTillDate | projects.retentionTillDate | projects |
| projects__roles | OBJECT | projects.roles | projects.roles | projects |
| projects__self | TEXT | projects.self | projects.self | projects |
| projects__simplified | BOOLEAN | projects.simplified | projects.simplified | projects |
| projects__style | TEXT | projects.style | projects.style | projects |
| projects__url | TEXT | projects.url | projects.url | projects |
| projects__uuid | TEXT | projects.uuid | projects.uuid | projects |
| projects__versions | OBJECT | projects.versions | projects.versions | projects |
| screen_schemes__description | TEXT | screen_schemes.description | screen_schemes.description | screen_schemes |
| screen_schemes__id | NUMERIC | screen_schemes.id | screen_schemes.id | screen_schemes |
| screen_schemes__issuetypescreenschemes | OBJECT | screen_schemes.issueTypeScreenSchemes | screen_schemes.issueTypeScreenSchemes | screen_schemes |
| screen_schemes__name | TEXT | screen_schemes.name | screen_schemes.name | screen_schemes |
| screen_schemes__screens | OBJECT | screen_schemes.screens | screen_schemes.screens | screen_schemes |
| screen_tab_fields__id | TEXT | screen_tab_fields.id | screen_tab_fields.id | screen_tab_fields |
| screen_tab_fields__name | TEXT | screen_tab_fields.name | screen_tab_fields.name | screen_tab_fields |
| screen_tab_fields__screenid | NUMERIC | screen_tab_fields.screenId | screen_tab_fields.screenId | screen_tab_fields |
| screen_tab_fields__tabid | NUMERIC | screen_tab_fields.tabId | screen_tab_fields.tabId | screen_tab_fields |
| screen_tabs__id | NUMERIC | screen_tabs.id | screen_tabs.id | screen_tabs |
| screen_tabs__name | TEXT | screen_tabs.name | screen_tabs.name | screen_tabs |
| screen_tabs__screenid | NUMERIC | screen_tabs.screenId | screen_tabs.screenId | screen_tabs |
| screens__description | TEXT | screens.description | screens.description | screens |
| screens__id | NUMERIC | screens.id | screens.id | screens |
| screens__name | TEXT | screens.name | screens.name | screens |
| screens__scope | OBJECT | screens.scope | screens.scope | screens |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| sprint_issues__created | TEXT | sprint_issues.created | sprint_issues.created | sprint_issues |
| sprint_issues__expand | TEXT | sprint_issues.expand | sprint_issues.expand | sprint_issues |
| sprint_issues__fields | OBJECT | sprint_issues.fields | sprint_issues.fields | sprint_issues |
| sprint_issues__id | TEXT | sprint_issues.id | sprint_issues.id | sprint_issues |
| sprint_issues__issueid | TEXT | sprint_issues.issueId | sprint_issues.issueId | sprint_issues |
| sprint_issues__key | TEXT | sprint_issues.key | sprint_issues.key | sprint_issues |
| sprint_issues__self | TEXT | sprint_issues.self | sprint_issues.self | sprint_issues |
| sprint_issues__sprintid | NUMERIC | sprint_issues.sprintId | sprint_issues.sprintId | sprint_issues |
| sprint_issues__updated | TEXT | sprint_issues.updated | sprint_issues.updated | sprint_issues |
| sprints__boardid | NUMERIC | sprints.boardId | sprints.boardId | sprints |
| sprints__completedate | TEXT | sprints.completeDate | sprints.completeDate | sprints |
| sprints__createddate | TEXT | sprints.createdDate | sprints.createdDate | sprints |
| sprints__enddate | TEXT | sprints.endDate | sprints.endDate | sprints |
| sprints__goal | TEXT | sprints.goal | sprints.goal | sprints |
| sprints__id | NUMERIC | sprints.id | sprints.id | sprints |
| sprints__name | TEXT | sprints.name | sprints.name | sprints |
| sprints__originboardid | NUMERIC | sprints.originBoardId | sprints.originBoardId | sprints |
| sprints__self | TEXT | sprints.self | sprints.self | sprints |
| sprints__startdate | TEXT | sprints.startDate | sprints.startDate | sprints |
| sprints__state | TEXT | sprints.state | sprints.state | sprints |
| time_tracking__key | TEXT | time_tracking.key | time_tracking.key | time_tracking |
| time_tracking__name | TEXT | time_tracking.name | time_tracking.name | time_tracking |
| time_tracking__url | TEXT | time_tracking.url | time_tracking.url | time_tracking |
| today | DATE | Today | Today's date | |
| users__accountid | TEXT | users.accountId | users.accountId | users |
| users__accounttype | TEXT | users.accountType | users.accountType | users |
| users__active | BOOLEAN | users.active | users.active | users |
| users__applicationroles | OBJECT | users.applicationRoles | users.applicationRoles | users |
| users__avatarurls | OBJECT | users.avatarUrls | users.avatarUrls | users |
| users__displayname | TEXT | users.displayName | users.displayName | users |
| users__emailaddress | TEXT | users.emailAddress | users.emailAddress | users |
| users__expand | TEXT | users.expand | users.expand | users |
| users__groups | OBJECT | users.groups | users.groups | users |
| users__key | TEXT | users.key | users.key | users |
| users__locale | TEXT | users.locale | users.locale | users |
| users__name | TEXT | users.name | users.name | users |
| users__self | TEXT | users.self | users.self | users |
| users__timezone | TEXT | users.timeZone | users.timeZone | users |
| users_groups_detailed__accountid | TEXT | users_groups_detailed.accountId | users_groups_detailed.accountId | users_groups_detailed |
| users_groups_detailed__accounttype | TEXT | users_groups_detailed.accountType | users_groups_detailed.accountType | users_groups_detailed |
| users_groups_detailed__active | BOOLEAN | users_groups_detailed.active | users_groups_detailed.active | users_groups_detailed |
| users_groups_detailed__applicationroles | OBJECT | users_groups_detailed.applicationRoles | users_groups_detailed.applicationRoles | users_groups_detailed |
| users_groups_detailed__avatarurls | OBJECT | users_groups_detailed.avatarUrls | users_groups_detailed.avatarUrls | users_groups_detailed |
| users_groups_detailed__displayname | TEXT | users_groups_detailed.displayName | users_groups_detailed.displayName | users_groups_detailed |
| users_groups_detailed__emailaddress | TEXT | users_groups_detailed.emailAddress | users_groups_detailed.emailAddress | users_groups_detailed |
| users_groups_detailed__expand | TEXT | users_groups_detailed.expand | users_groups_detailed.expand | users_groups_detailed |
| users_groups_detailed__groups | OBJECT | users_groups_detailed.groups | users_groups_detailed.groups | users_groups_detailed |
| users_groups_detailed__key | TEXT | users_groups_detailed.key | users_groups_detailed.key | users_groups_detailed |
| users_groups_detailed__locale | TEXT | users_groups_detailed.locale | users_groups_detailed.locale | users_groups_detailed |
| users_groups_detailed__name | TEXT | users_groups_detailed.name | users_groups_detailed.name | users_groups_detailed |
| users_groups_detailed__self | TEXT | users_groups_detailed.self | users_groups_detailed.self | users_groups_detailed |
| users_groups_detailed__timezone | TEXT | users_groups_detailed.timeZone | users_groups_detailed.timeZone | users_groups_detailed |
| workflow_schemes__defaultworkflow | TEXT | workflow_schemes.defaultWorkflow | workflow_schemes.defaultWorkflow | workflow_schemes |
| workflow_schemes__description | TEXT | workflow_schemes.description | workflow_schemes.description | workflow_schemes |
| workflow_schemes__draft | BOOLEAN | workflow_schemes.draft | workflow_schemes.draft | workflow_schemes |
| workflow_schemes__id | NUMERIC | workflow_schemes.id | workflow_schemes.id | workflow_schemes |
| workflow_schemes__issuetypemappings | OBJECT | workflow_schemes.issueTypeMappings | workflow_schemes.issueTypeMappings | workflow_schemes |
| workflow_schemes__issuetypes | OBJECT | workflow_schemes.issueTypes | workflow_schemes.issueTypes | workflow_schemes |
| workflow_schemes__lastmodified | TEXT | workflow_schemes.lastModified | workflow_schemes.lastModified | workflow_schemes |
| workflow_schemes__lastmodifieduser | OBJECT | workflow_schemes.lastModifiedUser | workflow_schemes.lastModifiedUser | workflow_schemes |
| workflow_schemes__name | TEXT | workflow_schemes.name | workflow_schemes.name | workflow_schemes |
| workflow_schemes__originaldefaultworkflow | TEXT | workflow_schemes.originalDefaultWorkflow | workflow_schemes.originalDefaultWorkflow | workflow_schemes |
| workflow_schemes__originalissuetypemappings | OBJECT | workflow_schemes.originalIssueTypeMappings | workflow_schemes.originalIssueTypeMappings | workflow_schemes |
| workflow_schemes__self | TEXT | workflow_schemes.self | workflow_schemes.self | workflow_schemes |
| workflow_schemes__updatedraftifneeded | BOOLEAN | workflow_schemes.updateDraftIfNeeded | workflow_schemes.updateDraftIfNeeded | workflow_schemes |
| workflow_status_categories__colorname | TEXT | workflow_status_categories.colorName | workflow_status_categories.colorName | workflow_status_categories |
| workflow_status_categories__id | NUMERIC | workflow_status_categories.id | workflow_status_categories.id | workflow_status_categories |
| workflow_status_categories__key | TEXT | workflow_status_categories.key | workflow_status_categories.key | workflow_status_categories |
| workflow_status_categories__name | TEXT | workflow_status_categories.name | workflow_status_categories.name | workflow_status_categories |
| workflow_status_categories__self | TEXT | workflow_status_categories.self | workflow_status_categories.self | workflow_status_categories |
| workflow_statuses__description | TEXT | workflow_statuses.description | workflow_statuses.description | workflow_statuses |
| workflow_statuses__iconurl | TEXT | workflow_statuses.iconUrl | workflow_statuses.iconUrl | workflow_statuses |
| workflow_statuses__id | TEXT | workflow_statuses.id | workflow_statuses.id | workflow_statuses |
| workflow_statuses__name | TEXT | workflow_statuses.name | workflow_statuses.name | workflow_statuses |
| workflow_statuses__scope | OBJECT | workflow_statuses.scope | workflow_statuses.scope | workflow_statuses |
| workflow_statuses__self | TEXT | workflow_statuses.self | workflow_statuses.self | workflow_statuses |
| workflow_statuses__statuscategory | OBJECT | workflow_statuses.statusCategory | workflow_statuses.statusCategory | workflow_statuses |
| workflow_statuses__untranslatedname | TEXT | workflow_statuses.untranslatedName | workflow_statuses.untranslatedName | workflow_statuses |
| workflows__created | TEXT | workflows.created | workflows.created | workflows |
| workflows__description | TEXT | workflows.description | workflows.description | workflows |
| workflows__id | OBJECT | workflows.id | workflows.id | workflows |
| workflows__statuses | OBJECT | workflows.statuses | workflows.statuses | workflows |
| workflows__transitions | OBJECT | workflows.transitions | workflows.transitions | workflows |
| workflows__updated | TEXT | workflows.updated | workflows.updated | workflows |