# ProjectIssues - Catalog: `YouTrack` - Schema: `Agile` - 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` 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. ## Columns of Table Function 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 | ☐ | |