ProjectIssues |
Catalog: YouTrack
Schema: Agile
This is a read-only table function. The YouTrack API may not support changing the data or the Invantive SQL driver for YouTrack does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the YouTrack API.
Select YouTrack API URL: /agiles
Insert YouTrack API URL: /agiles
Update YouTrack API URL: /agiles
Delete YouTrack API URL: /agiles
Field Selection Method: NotRequired
Base Path: projects[*].issues[*]
Select YouTrack API Operation: get /agiles
Table Function Columns
The columns of the table function ProjectIssues are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
$type_1 |
string |
|
☐ |
|
$type_2 |
string |
|
☐ |
|
$type |
string |
|
☐ |
|
archived |
boolean |
Archived |
☐ |
|
colorCoding_$type |
string |
|
☐ |
|
colorCoding_id |
string |
|
☐ |
|
columnSettings_$type |
string |
|
☐ |
|
columnSettings_field_$type |
string |
|
☐ |
|
columnSettings_field_aliases |
string |
|
☐ |
|
columnSettings_field_hasRunningJob |
boolean |
|
☐ |
|
columnSettings_field_id |
string |
|
☐ |
|
columnSettings_field_isAutoAttached |
boolean |
|
☐ |
|
columnSettings_field_isDisplayedInIssueList |
boolean |
|
☐ |
|
columnSettings_field_isUpdateable |
boolean |
|
☐ |
|
columnSettings_field_localizedName |
string |
|
☐ |
|
columnSettings_field_name |
string |
|
☐ |
|
columnSettings_field_ordinal |
int32 |
|
☐ |
|
columnSettings_id |
string |
|
☐ |
|
commentsCount |
int32 |
Comments Count |
☐ |
|
created |
int64 |
Created |
☐ |
|
createdBy_$type |
string |
|
☐ |
|
createdBy_avatarUrl |
string |
|
☐ |
|
createdBy_banned |
boolean |
|
☐ |
|
createdBy_email |
string |
|
☐ |
|
createdBy_fullName |
string |
|
☐ |
|
createdBy_guest |
boolean |
|
☐ |
|
createdBy_id |
string |
|
☐ |
|
createdBy_jabberAccountName |
string |
|
☐ |
|
createdBy_login |
string |
|
☐ |
|
createdBy_online |
boolean |
|
☐ |
|
createdBy_ringId |
string |
|
☐ |
|
currentSprint_$type_1 |
string |
|
☐ |
|
currentSprint_$type |
string |
|
☐ |
|
currentSprint_agile_$type |
string |
|
☐ |
|
currentSprint_agile_hideOrphansSwimlane |
boolean |
|
☐ |
|
currentSprint_agile_id |
string |
|
☐ |
|
currentSprint_agile_name |
string |
|
☐ |
|
currentSprint_agile_orphansAtTheTop |
boolean |
|
☐ |
|
currentSprint_agile_updateableByProjectBased |
boolean |
|
☐ |
|
currentSprint_agile_visibleForProjectBased |
boolean |
|
☐ |
|
currentSprint_archived |
boolean |
|
☐ |
|
currentSprint_commentsCount |
int32 |
|
☐ |
|
currentSprint_created |
int64 |
|
☐ |
|
currentSprint_description |
string |
|
☐ |
|
currentSprint_finish |
int64 |
|
☐ |
|
currentSprint_goal |
string |
|
☐ |
|
currentSprint_id_1 |
string |
|
☐ |
|
currentSprint_id |
string |
|
☐ |
|
currentSprint_idReadable |
string |
|
☐ |
|
currentSprint_isDefault |
boolean |
|
☐ |
|
currentSprint_isDraft |
boolean |
|
☐ |
|
currentSprint_name |
string |
|
☐ |
|
currentSprint_numberInProject |
int64 |
|
☐ |
|
currentSprint_previousSprint_$type |
string |
|
☐ |
|
currentSprint_previousSprint_archived |
boolean |
|
☐ |
|
currentSprint_previousSprint_finish |
int64 |
|
☐ |
|
currentSprint_previousSprint_goal |
string |
|
☐ |
|
currentSprint_previousSprint_id |
string |
|
☐ |
|
currentSprint_previousSprint_isDefault |
boolean |
|
☐ |
|
currentSprint_previousSprint_name |
string |
|
☐ |
|
currentSprint_previousSprint_start |
int64 |
|
☐ |
|
currentSprint_previousSprint_unresolvedIssuesCount |
int32 |
|
☐ |
|
currentSprint_resolved |
int64 |
|
☐ |
|
currentSprint_start |
int64 |
|
☐ |
|
currentSprint_summary |
string |
|
☐ |
|
currentSprint_unresolvedIssuesCount |
int32 |
|
☐ |
|
currentSprint_updated |
int64 |
|
☐ |
|
currentSprint_usesMarkdown |
boolean |
|
☐ |
|
currentSprint_votes |
int32 |
|
☐ |
|
currentSprint_wikifiedDescription |
string |
|
☐ |
|
description_1 |
string |
|
☐ |
|
description |
string |
Description |
☐ |
|
estimationField_$type |
string |
|
☐ |
|
estimationField_aliases |
string |
|
☐ |
|
estimationField_fieldDefaults_$type |
string |
|
☐ |
|
estimationField_fieldDefaults_canBeEmpty |
boolean |
|
☐ |
|
estimationField_fieldDefaults_emptyFieldText |
string |
|
☐ |
|
estimationField_fieldDefaults_id |
string |
|
☐ |
|
estimationField_fieldDefaults_isPublic |
boolean |
|
☐ |
|
estimationField_fieldType_$type |
string |
|
☐ |
|
estimationField_fieldType_id |
string |
|
☐ |
|
estimationField_hasRunningJob |
boolean |
|
☐ |
|
estimationField_id |
string |
|
☐ |
|
estimationField_isAutoAttached |
boolean |
|
☐ |
|
estimationField_isDisplayedInIssueList |
boolean |
|
☐ |
|
estimationField_isUpdateable |
boolean |
|
☐ |
|
estimationField_localizedName |
string |
|
☐ |
|
estimationField_name |
string |
|
☐ |
|
estimationField_ordinal |
int32 |
|
☐ |
|
fromEmail |
string |
From Email |
☐ |
|
hideOrphansSwimlane |
boolean |
|
☐ |
|
iconUrl |
string |
Icon (URL) |
☐ |
|
id_1 |
string |
|
☐ |
|
id_2 |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
idReadable |
string |
Readable ID |
☐ |
|
isDraft |
boolean |
Is Draft |
☐ |
|
leader_$type |
string |
|
☐ |
|
leader_avatarUrl |
string |
|
☐ |
|
leader_banned |
boolean |
|
☐ |
|
leader_email |
string |
|
☐ |
|
leader_fullName |
string |
|
☐ |
|
leader_guest |
boolean |
|
☐ |
|
leader_id |
string |
|
☐ |
|
leader_jabberAccountName |
string |
|
☐ |
|
leader_login |
string |
|
☐ |
|
leader_online |
boolean |
|
☐ |
|
leader_ringId |
string |
|
☐ |
|
name_1 |
string |
|
☐ |
|
name |
string |
Name |
☐ |
|
numberInProject |
int64 |
Number in Project |
☐ |
|
originalEstimationField_$type |
string |
|
☐ |
|
originalEstimationField_aliases |
string |
|
☐ |
|
originalEstimationField_fieldDefaults_$type |
string |
|
☐ |
|
originalEstimationField_fieldDefaults_canBeEmpty |
boolean |
|
☐ |
|
originalEstimationField_fieldDefaults_emptyFieldText |
string |
|
☐ |
|
originalEstimationField_fieldDefaults_id |
string |
|
☐ |
|
originalEstimationField_fieldDefaults_isPublic |
boolean |
|
☐ |
|
originalEstimationField_fieldType_$type |
string |
|
☐ |
|
originalEstimationField_fieldType_id |
string |
|
☐ |
|
originalEstimationField_hasRunningJob |
boolean |
|
☐ |
|
originalEstimationField_id |
string |
|
☐ |
|
originalEstimationField_isAutoAttached |
boolean |
|
☐ |
|
originalEstimationField_isDisplayedInIssueList |
boolean |
|
☐ |
|
originalEstimationField_isUpdateable |
boolean |
|
☐ |
|
originalEstimationField_localizedName |
string |
|
☐ |
|
originalEstimationField_name |
string |
|
☐ |
|
originalEstimationField_ordinal |
int32 |
|
☐ |
|
orphansAtTheTop |
boolean |
|
☐ |
|
owner_$type |
string |
|
☐ |
|
owner_avatarUrl |
string |
|
☐ |
|
owner_banned |
boolean |
|
☐ |
|
owner_email |
string |
|
☐ |
|
owner_fullName |
string |
|
☐ |
|
owner_guest |
boolean |
|
☐ |
|
owner_id |
string |
|
☐ |
|
owner_jabberAccountName |
string |
|
☐ |
|
owner_login |
string |
|
☐ |
|
owner_online |
boolean |
|
☐ |
|
owner_profiles_$type |
string |
|
☐ |
|
owner_profiles_id |
string |
|
☐ |
|
owner_ringId |
string |
|
☐ |
|
replyToEmail |
string |
Reply-to Email |
☐ |
|
resolved |
int64 |
Resolved |
☐ |
|
shortName |
string |
Short Name |
☐ |
|
sprintsSettings_$type |
string |
|
☐ |
|
sprintsSettings_cardOnSeveralSprints |
boolean |
|
☐ |
|
sprintsSettings_defaultSprint_$type |
string |
|
☐ |
|
sprintsSettings_defaultSprint_archived |
boolean |
|
☐ |
|
sprintsSettings_defaultSprint_finish |
int64 |
|
☐ |
|
sprintsSettings_defaultSprint_goal |
string |
|
☐ |
|
sprintsSettings_defaultSprint_id |
string |
|
☐ |
|
sprintsSettings_defaultSprint_isDefault |
boolean |
|
☐ |
|
sprintsSettings_defaultSprint_name |
string |
|
☐ |
|
sprintsSettings_defaultSprint_start |
int64 |
|
☐ |
|
sprintsSettings_defaultSprint_unresolvedIssuesCount |
int32 |
|
☐ |
|
sprintsSettings_disableSprints |
boolean |
|
☐ |
|
sprintsSettings_explicitQuery |
string |
|
☐ |
|
sprintsSettings_hideSubtasksOfCards |
boolean |
|
☐ |
|
sprintsSettings_id |
string |
|
☐ |
|
sprintsSettings_isExplicit |
boolean |
|
☐ |
|
sprintsSettings_sprintSyncField_$type |
string |
|
☐ |
|
sprintsSettings_sprintSyncField_aliases |
string |
|
☐ |
|
sprintsSettings_sprintSyncField_hasRunningJob |
boolean |
|
☐ |
|
sprintsSettings_sprintSyncField_id |
string |
|
☐ |
|
sprintsSettings_sprintSyncField_isAutoAttached |
boolean |
|
☐ |
|
sprintsSettings_sprintSyncField_isDisplayedInIssueList |
boolean |
|
☐ |
|
sprintsSettings_sprintSyncField_isUpdateable |
boolean |
|
☐ |
|
sprintsSettings_sprintSyncField_localizedName |
string |
|
☐ |
|
sprintsSettings_sprintSyncField_name |
string |
|
☐ |
|
sprintsSettings_sprintSyncField_ordinal |
int32 |
|
☐ |
|
startingNumber |
int64 |
Starting Number |
☐ |
|
status_$type |
string |
|
☐ |
|
status_hasJobs |
boolean |
|
☐ |
|
status_id |
string |
|
☐ |
|
status_valid |
boolean |
|
☐ |
|
summary |
string |
Summary |
☐ |
|
swimlaneSettings_$type |
string |
|
☐ |
|
swimlaneSettings_enabled |
boolean |
|
☐ |
|
swimlaneSettings_id |
string |
|
☐ |
|
team_$type |
string |
|
☐ |
|
team_allUsersGroup |
boolean |
|
☐ |
|
team_icon |
string |
|
☐ |
|
team_id |
string |
|
☐ |
|
team_name |
string |
|
☐ |
|
team_ringId |
string |
|
☐ |
|
team_usersCount |
int64 |
|
☐ |
|
template |
boolean |
Template |
☐ |
|
updateableBy_$type |
string |
|
☐ |
|
updateableBy_allUsersGroup |
boolean |
|
☐ |
|
updateableBy_icon |
string |
|
☐ |
|
updateableBy_id |
string |
|
☐ |
|
updateableBy_name |
string |
|
☐ |
|
updateableBy_ringId |
string |
|
☐ |
|
updateableBy_teamForProject_archived |
boolean |
|
☐ |
|
updateableBy_teamForProject_description |
string |
|
☐ |
|
updateableBy_teamForProject_fromEmail |
string |
|
☐ |
|
updateableBy_teamForProject_iconUrl |
string |
|
☐ |
|
updateableBy_teamForProject_replyToEmail |
string |
|
☐ |
|
updateableBy_teamForProject_shortName |
string |
|
☐ |
|
updateableBy_teamForProject_startingNumber |
int64 |
|
☐ |
|
updateableBy_teamForProject_template |
boolean |
|
☐ |
|
updateableBy_usersCount |
int64 |
|
☐ |
|
updateableByProjectBased |
boolean |
|
☐ |
|
updated |
int64 |
Updated |
☐ |
|
usesMarkdown |
boolean |
Uses Mark Down |
☐ |
|
visibleFor_$type |
string |
|
☐ |
|
visibleFor_allUsersGroup |
boolean |
|
☐ |
|
visibleFor_icon |
string |
|
☐ |
|
visibleFor_id |
string |
|
☐ |
|
visibleFor_name |
string |
|
☐ |
|
visibleFor_ringId |
string |
|
☐ |
|
visibleFor_teamForProject_archived |
boolean |
|
☐ |
|
visibleFor_teamForProject_description |
string |
|
☐ |
|
visibleFor_teamForProject_fromEmail |
string |
|
☐ |
|
visibleFor_teamForProject_iconUrl |
string |
|
☐ |
|
visibleFor_teamForProject_replyToEmail |
string |
|
☐ |
|
visibleFor_teamForProject_shortName |
string |
|
☐ |
|
visibleFor_teamForProject_startingNumber |
int64 |
|
☐ |
|
visibleFor_teamForProject_template |
boolean |
|
☐ |
|
visibleFor_usersCount |
int64 |
|
☐ |
|
visibleForProjectBased |
boolean |
|
☐ |
|
votes |
int32 |
Votes |
☐ |
|
wikifiedDescription |
string |
Wikified Description |
☐ |
|
23-06-2022 19:43 Version 22.0.248-PROD+3461