# SprintById2 - 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 - 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 `SprintById2` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `$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 | ☐ | | | `finish` | `int64` | Finish | ☐ | | | `goal` | `string` | Goal | ☐ | | | `id` | `string` | ID | ☐ | | | `isDefault` | `boolean` | Is Default | ☐ | | | `name` | `string` | Name | ☐ | | | `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` | | ☐ | | | `start` | `int64` | Start | ☐ | | | `unresolvedIssuesCount` | `int32` | Unresolved Issue Count | ☐ | |