# SprintIssuesBySprintId1 - Catalog: `YouTrack` - Schema: `Agile` - Select YouTrack API URL: `/agiles/{id}/sprints` - Insert YouTrack API URL: `/agiles/{id}/sprints` - Update YouTrack API URL: `/agiles/{id}/sprints` - Delete YouTrack API URL: `/agiles/{id}/sprints` - Field Selection Method: NotRequired - Base Path: `issues[*]` - Select YouTrack API Operation: `get /agiles/{id}/sprints` 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. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☑ | | | ## Columns of Table Function The columns of the table function `SprintIssuesBySprintId1` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `$type_1` | `string` | | ☐ | | | `$type` | `string` | | ☐ | | | `agile_$type` | `string` | | ☐ | | | `agile_colorCoding_$type` | `string` | | ☐ | | | `agile_colorCoding_id` | `string` | | ☐ | | | `agile_columnSettings_$type` | `string` | | ☐ | | | `agile_columnSettings_id` | `string` | | ☐ | | | `agile_currentSprint_$type` | `string` | | ☐ | | | `agile_currentSprint_archived` | `boolean` | | ☐ | | | `agile_currentSprint_finish` | `int64` | | ☐ | | | `agile_currentSprint_goal` | `string` | | ☐ | | | `agile_currentSprint_id` | `string` | | ☐ | | | `agile_currentSprint_isDefault` | `boolean` | | ☐ | | | `agile_currentSprint_name` | `string` | | ☐ | | | `agile_currentSprint_start` | `int64` | | ☐ | | | `agile_currentSprint_unresolvedIssuesCount` | `int32` | | ☐ | | | `agile_estimationField_$type` | `string` | | ☐ | | | `agile_estimationField_aliases` | `string` | | ☐ | | | `agile_estimationField_hasRunningJob` | `boolean` | | ☐ | | | `agile_estimationField_id` | `string` | | ☐ | | | `agile_estimationField_isAutoAttached` | `boolean` | | ☐ | | | `agile_estimationField_isDisplayedInIssueList` | `boolean` | | ☐ | | | `agile_estimationField_isUpdateable` | `boolean` | | ☐ | | | `agile_estimationField_localizedName` | `string` | | ☐ | | | `agile_estimationField_name` | `string` | | ☐ | | | `agile_estimationField_ordinal` | `int32` | | ☐ | | | `agile_hideOrphansSwimlane` | `boolean` | | ☐ | | | `agile_id` | `string` | | ☐ | | | `agile_name` | `string` | | ☐ | | | `agile_originalEstimationField_$type` | `string` | | ☐ | | | `agile_originalEstimationField_aliases` | `string` | | ☐ | | | `agile_originalEstimationField_hasRunningJob` | `boolean` | | ☐ | | | `agile_originalEstimationField_id` | `string` | | ☐ | | | `agile_originalEstimationField_isAutoAttached` | `boolean` | | ☐ | | | `agile_originalEstimationField_isDisplayedInIssueList` | `boolean` | | ☐ | | | `agile_originalEstimationField_isUpdateable` | `boolean` | | ☐ | | | `agile_originalEstimationField_localizedName` | `string` | | ☐ | | | `agile_originalEstimationField_name` | `string` | | ☐ | | | `agile_originalEstimationField_ordinal` | `int32` | | ☐ | | | `agile_orphansAtTheTop` | `boolean` | | ☐ | | | `agile_owner_$type` | `string` | | ☐ | | | `agile_owner_avatarUrl` | `string` | | ☐ | | | `agile_owner_banned` | `boolean` | | ☐ | | | `agile_owner_email` | `string` | | ☐ | | | `agile_owner_fullName` | `string` | | ☐ | | | `agile_owner_guest` | `boolean` | | ☐ | | | `agile_owner_id` | `string` | | ☐ | | | `agile_owner_jabberAccountName` | `string` | | ☐ | | | `agile_owner_login` | `string` | | ☐ | | | `agile_owner_online` | `boolean` | | ☐ | | | `agile_owner_ringId` | `string` | | ☐ | | | `agile_sprintsSettings_$type` | `string` | | ☐ | | | `agile_sprintsSettings_cardOnSeveralSprints` | `boolean` | | ☐ | | | `agile_sprintsSettings_disableSprints` | `boolean` | | ☐ | | | `agile_sprintsSettings_explicitQuery` | `string` | | ☐ | | | `agile_sprintsSettings_hideSubtasksOfCards` | `boolean` | | ☐ | | | `agile_sprintsSettings_id` | `string` | | ☐ | | | `agile_sprintsSettings_isExplicit` | `boolean` | | ☐ | | | `agile_status_$type` | `string` | | ☐ | | | `agile_status_hasJobs` | `boolean` | | ☐ | | | `agile_status_id` | `string` | | ☐ | | | `agile_status_valid` | `boolean` | | ☐ | | | `agile_swimlaneSettings_$type` | `string` | | ☐ | | | `agile_swimlaneSettings_enabled` | `boolean` | | ☐ | | | `agile_swimlaneSettings_id` | `string` | | ☐ | | | `agile_updateableBy_$type` | `string` | | ☐ | | | `agile_updateableBy_allUsersGroup` | `boolean` | | ☐ | | | `agile_updateableBy_icon` | `string` | | ☐ | | | `agile_updateableBy_id` | `string` | | ☐ | | | `agile_updateableBy_name` | `string` | | ☐ | | | `agile_updateableBy_ringId` | `string` | | ☐ | | | `agile_updateableBy_usersCount` | `int64` | | ☐ | | | `agile_updateableByProjectBased` | `boolean` | | ☐ | | | `agile_visibleFor_$type` | `string` | | ☐ | | | `agile_visibleFor_allUsersGroup` | `boolean` | | ☐ | | | `agile_visibleFor_icon` | `string` | | ☐ | | | `agile_visibleFor_id` | `string` | | ☐ | | | `agile_visibleFor_name` | `string` | | ☐ | | | `agile_visibleFor_ringId` | `string` | | ☐ | | | `agile_visibleFor_usersCount` | `int64` | | ☐ | | | `agile_visibleForProjectBased` | `boolean` | | ☐ | | | `archived` | `boolean` | Archived | ☐ | | | `commentsCount` | `int32` | Comments Count | ☐ | | | `created` | `int64` | Created | ☐ | | | `description` | `string` | Description | ☐ | | | `draftOwner_$type` | `string` | | ☐ | | | `draftOwner_avatarUrl` | `string` | | ☐ | | | `draftOwner_banned` | `boolean` | | ☐ | | | `draftOwner_email` | `string` | | ☐ | | | `draftOwner_fullName` | `string` | | ☐ | | | `draftOwner_guest` | `boolean` | | ☐ | | | `draftOwner_id` | `string` | | ☐ | | | `draftOwner_jabberAccountName` | `string` | | ☐ | | | `draftOwner_login` | `string` | | ☐ | | | `draftOwner_online` | `boolean` | | ☐ | | | `draftOwner_ringId` | `string` | | ☐ | | | `externalIssue_$type` | `string` | | ☐ | | | `externalIssue_id` | `string` | | ☐ | | | `externalIssue_key` | `string` | | ☐ | | | `externalIssue_name` | `string` | | ☐ | | | `externalIssue_url` | `string` | | ☐ | | | `finish` | `int64` | Finish | ☐ | | | `goal` | `string` | Goal | ☐ | | | `id_1` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `idReadable` | `string` | Readable ID | ☐ | | | `isDefault` | `boolean` | Is Default | ☐ | | | `isDraft` | `boolean` | Is Draft | ☐ | | | `name` | `string` | Name | ☐ | | | `numberInProject` | `int64` | Number in Project | ☐ | | | `parent_$type` | `string` | | ☐ | | | `parent_direction` | `string` | | ☐ | | | `parent_id` | `string` | | ☐ | | | `previousSprint_$type` | `string` | | ☐ | | | `previousSprint_agile_$type` | `string` | | ☐ | | | `previousSprint_agile_hideOrphansSwimlane` | `boolean` | | ☐ | | | `previousSprint_agile_id` | `string` | | ☐ | | | `previousSprint_agile_name` | `string` | | ☐ | | | `previousSprint_agile_orphansAtTheTop` | `boolean` | | ☐ | | | `previousSprint_agile_updateableByProjectBased` | `boolean` | | ☐ | | | `previousSprint_agile_visibleForProjectBased` | `boolean` | | ☐ | | | `previousSprint_archived` | `boolean` | | ☐ | | | `previousSprint_finish` | `int64` | | ☐ | | | `previousSprint_goal` | `string` | | ☐ | | | `previousSprint_id` | `string` | | ☐ | | | `previousSprint_isDefault` | `boolean` | | ☐ | | | `previousSprint_name` | `string` | | ☐ | | | `previousSprint_previousSprint_$type` | `string` | | ☐ | | | `previousSprint_previousSprint_archived` | `boolean` | | ☐ | | | `previousSprint_previousSprint_finish` | `int64` | | ☐ | | | `previousSprint_previousSprint_goal` | `string` | | ☐ | | | `previousSprint_previousSprint_id` | `string` | | ☐ | | | `previousSprint_previousSprint_isDefault` | `boolean` | | ☐ | | | `previousSprint_previousSprint_name` | `string` | | ☐ | | | `previousSprint_previousSprint_start` | `int64` | | ☐ | | | `previousSprint_previousSprint_unresolvedIssuesCount` | `int32` | | ☐ | | | `previousSprint_start` | `int64` | | ☐ | | | `previousSprint_unresolvedIssuesCount` | `int32` | | ☐ | | | `project_archived` | `boolean` | | ☐ | | | `project_description` | `string` | | ☐ | | | `project_fromEmail` | `string` | | ☐ | | | `project_iconUrl` | `string` | | ☐ | | | `project_replyToEmail` | `string` | | ☐ | | | `project_shortName` | `string` | | ☐ | | | `project_startingNumber` | `int64` | | ☐ | | | `project_template` | `boolean` | | ☐ | | | `reporter_$type` | `string` | | ☐ | | | `reporter_avatarUrl` | `string` | | ☐ | | | `reporter_banned` | `boolean` | | ☐ | | | `reporter_email` | `string` | | ☐ | | | `reporter_fullName` | `string` | | ☐ | | | `reporter_guest` | `boolean` | | ☐ | | | `reporter_id` | `string` | | ☐ | | | `reporter_jabberAccountName` | `string` | | ☐ | | | `reporter_login` | `string` | | ☐ | | | `reporter_online` | `boolean` | | ☐ | | | `reporter_ringId` | `string` | | ☐ | | | `resolved` | `int64` | Resolved | ☐ | | | `start` | `int64` | Start | ☐ | | | `subtasks_$type` | `string` | | ☐ | | | `subtasks_direction` | `string` | | ☐ | | | `subtasks_id` | `string` | | ☐ | | | `summary` | `string` | Summary | ☐ | | | `unresolvedIssuesCount` | `int32` | Unresolved Issue Count | ☐ | | | `updated` | `int64` | Updated | ☐ | | | `updater_$type` | `string` | | ☐ | | | `updater_avatarUrl` | `string` | | ☐ | | | `updater_banned` | `boolean` | | ☐ | | | `updater_email` | `string` | | ☐ | | | `updater_fullName` | `string` | | ☐ | | | `updater_guest` | `boolean` | | ☐ | | | `updater_id` | `string` | | ☐ | | | `updater_jabberAccountName` | `string` | | ☐ | | | `updater_login` | `string` | | ☐ | | | `updater_online` | `boolean` | | ☐ | | | `updater_ringId` | `string` | | ☐ | | | `usesMarkdown` | `boolean` | Uses Mark Down | ☐ | | | `visibility_$type` | `string` | | ☐ | | | `visibility_id` | `string` | | ☐ | | | `voters_$type` | `string` | | ☐ | | | `voters_hasVote` | `boolean` | | ☐ | | | `voters_id` | `string` | | ☐ | | | `votes` | `int32` | Votes | ☐ | | | `watchers_$type` | `string` | | ☐ | | | `watchers_hasStar` | `boolean` | | ☐ | | | `watchers_id` | `string` | | ☐ | | | `wikifiedDescription` | `string` | Wikified Description | ☐ | |