# LinkTrimmedIssuesByIssueId - Catalog: `YouTrack` - Schema: `Issues` - Select YouTrack API URL: `/issues/{id}` - Insert YouTrack API URL: `/issues/{id}` - Update YouTrack API URL: `/issues/{id}` - Delete YouTrack API URL: `/issues/{id}` - Field Selection Method: NotRequired - Base Path: `links[*].trimmedIssues[*]` - Select YouTrack API Operation: `get /issues/{id}` 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 `LinkTrimmedIssuesByIssueId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `$type_1` | `string` | | ☐ | | | `$type_2` | `string` | | ☐ | | | `$type` | `string` | | ☐ | | | `commentsCount_1` | `int32` | | ☐ | | | `commentsCount` | `int32` | Comments Count | ☐ | | | `created_1` | `int64` | | ☐ | | | `created` | `int64` | Created | ☐ | | | `description_1` | `string` | | ☐ | | | `description` | `string` | Description | ☐ | | | `direction` | `string` | Direction | ☐ | | | `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_profiles_$type` | `string` | | ☐ | | | `draftOwner_profiles_id` | `string` | | ☐ | | | `draftOwner_ringId` | `string` | | ☐ | | | `externalIssue_$type` | `string` | | ☐ | | | `externalIssue_id` | `string` | | ☐ | | | `externalIssue_key` | `string` | | ☐ | | | `externalIssue_name` | `string` | | ☐ | | | `externalIssue_url` | `string` | | ☐ | | | `id_1` | `string` | | ☐ | | | `id_2` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `idReadable_1` | `string` | | ☐ | | | `idReadable` | `string` | Readable ID | ☐ | | | `isDraft_1` | `boolean` | | ☐ | | | `isDraft` | `boolean` | Is Draft | ☐ | | | `linkType_$type` | `string` | | ☐ | | | `linkType_aggregation` | `boolean` | | ☐ | | | `linkType_directed` | `boolean` | | ☐ | | | `linkType_id` | `string` | | ☐ | | | `linkType_localizedName` | `string` | | ☐ | | | `linkType_localizedSourceToTarget` | `string` | | ☐ | | | `linkType_localizedTargetToSource` | `string` | | ☐ | | | `linkType_name` | `string` | | ☐ | | | `linkType_readOnly` | `boolean` | | ☐ | | | `linkType_sourceToTarget` | `string` | | ☐ | | | `linkType_targetToSource` | `string` | | ☐ | | | `numberInProject_1` | `int64` | | ☐ | | | `numberInProject` | `int64` | Number in Project | ☐ | | | `parent_$type_1` | `string` | | ☐ | | | `parent_$type` | `string` | | ☐ | | | `parent_commentsCount` | `int32` | | ☐ | | | `parent_created` | `int64` | | ☐ | | | `parent_description` | `string` | | ☐ | | | `parent_direction` | `string` | | ☐ | | | `parent_id_1` | `string` | | ☐ | | | `parent_id` | `string` | | ☐ | | | `parent_idReadable` | `string` | | ☐ | | | `parent_isDraft` | `boolean` | | ☐ | | | `parent_linkType_$type` | `string` | | ☐ | | | `parent_linkType_aggregation` | `boolean` | | ☐ | | | `parent_linkType_directed` | `boolean` | | ☐ | | | `parent_linkType_id` | `string` | | ☐ | | | `parent_linkType_localizedName` | `string` | | ☐ | | | `parent_linkType_localizedSourceToTarget` | `string` | | ☐ | | | `parent_linkType_localizedTargetToSource` | `string` | | ☐ | | | `parent_linkType_name` | `string` | | ☐ | | | `parent_linkType_readOnly` | `boolean` | | ☐ | | | `parent_linkType_sourceToTarget` | `string` | | ☐ | | | `parent_linkType_targetToSource` | `string` | | ☐ | | | `parent_numberInProject` | `int64` | | ☐ | | | `parent_resolved` | `int64` | | ☐ | | | `parent_summary` | `string` | | ☐ | | | `parent_updated` | `int64` | | ☐ | | | `parent_usesMarkdown` | `boolean` | | ☐ | | | `parent_votes` | `int32` | | ☐ | | | `parent_wikifiedDescription` | `string` | | ☐ | | | `project_archived` | `boolean` | | ☐ | | | `project_createdBy_$type` | `string` | | ☐ | | | `project_createdBy_avatarUrl` | `string` | | ☐ | | | `project_createdBy_banned` | `boolean` | | ☐ | | | `project_createdBy_email` | `string` | | ☐ | | | `project_createdBy_fullName` | `string` | | ☐ | | | `project_createdBy_guest` | `boolean` | | ☐ | | | `project_createdBy_id` | `string` | | ☐ | | | `project_createdBy_jabberAccountName` | `string` | | ☐ | | | `project_createdBy_login` | `string` | | ☐ | | | `project_createdBy_online` | `boolean` | | ☐ | | | `project_createdBy_ringId` | `string` | | ☐ | | | `project_description` | `string` | | ☐ | | | `project_fromEmail` | `string` | | ☐ | | | `project_iconUrl` | `string` | | ☐ | | | `project_leader_$type` | `string` | | ☐ | | | `project_leader_avatarUrl` | `string` | | ☐ | | | `project_leader_banned` | `boolean` | | ☐ | | | `project_leader_email` | `string` | | ☐ | | | `project_leader_fullName` | `string` | | ☐ | | | `project_leader_guest` | `boolean` | | ☐ | | | `project_leader_id` | `string` | | ☐ | | | `project_leader_jabberAccountName` | `string` | | ☐ | | | `project_leader_login` | `string` | | ☐ | | | `project_leader_online` | `boolean` | | ☐ | | | `project_leader_ringId` | `string` | | ☐ | | | `project_replyToEmail` | `string` | | ☐ | | | `project_shortName` | `string` | | ☐ | | | `project_startingNumber` | `int64` | | ☐ | | | `project_team_$type` | `string` | | ☐ | | | `project_team_allUsersGroup` | `boolean` | | ☐ | | | `project_team_icon` | `string` | | ☐ | | | `project_team_id` | `string` | | ☐ | | | `project_team_name` | `string` | | ☐ | | | `project_team_ringId` | `string` | | ☐ | | | `project_team_usersCount` | `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_profiles_$type` | `string` | | ☐ | | | `reporter_profiles_id` | `string` | | ☐ | | | `reporter_ringId` | `string` | | ☐ | | | `resolved_1` | `int64` | | ☐ | | | `resolved` | `int64` | Resolved | ☐ | | | `subtasks_$type_1` | `string` | | ☐ | | | `subtasks_$type` | `string` | | ☐ | | | `subtasks_commentsCount` | `int32` | | ☐ | | | `subtasks_created` | `int64` | | ☐ | | | `subtasks_description` | `string` | | ☐ | | | `subtasks_direction` | `string` | | ☐ | | | `subtasks_id_1` | `string` | | ☐ | | | `subtasks_id` | `string` | | ☐ | | | `subtasks_idReadable` | `string` | | ☐ | | | `subtasks_isDraft` | `boolean` | | ☐ | | | `subtasks_linkType_$type` | `string` | | ☐ | | | `subtasks_linkType_aggregation` | `boolean` | | ☐ | | | `subtasks_linkType_directed` | `boolean` | | ☐ | | | `subtasks_linkType_id` | `string` | | ☐ | | | `subtasks_linkType_localizedName` | `string` | | ☐ | | | `subtasks_linkType_localizedSourceToTarget` | `string` | | ☐ | | | `subtasks_linkType_localizedTargetToSource` | `string` | | ☐ | | | `subtasks_linkType_name` | `string` | | ☐ | | | `subtasks_linkType_readOnly` | `boolean` | | ☐ | | | `subtasks_linkType_sourceToTarget` | `string` | | ☐ | | | `subtasks_linkType_targetToSource` | `string` | | ☐ | | | `subtasks_numberInProject` | `int64` | | ☐ | | | `subtasks_resolved` | `int64` | | ☐ | | | `subtasks_summary` | `string` | | ☐ | | | `subtasks_updated` | `int64` | | ☐ | | | `subtasks_usesMarkdown` | `boolean` | | ☐ | | | `subtasks_votes` | `int32` | | ☐ | | | `subtasks_wikifiedDescription` | `string` | | ☐ | | | `summary_1` | `string` | | ☐ | | | `summary` | `string` | Summary | ☐ | | | `updated_1` | `int64` | | ☐ | | | `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_profiles_$type` | `string` | | ☐ | | | `updater_profiles_id` | `string` | | ☐ | | | `updater_ringId` | `string` | | ☐ | | | `usesMarkdown_1` | `boolean` | | ☐ | | | `usesMarkdown` | `boolean` | Uses Mark Down | ☐ | | | `visibility_$type` | `string` | | ☐ | | | `visibility_id` | `string` | | ☐ | | | `voters_$type` | `string` | | ☐ | | | `voters_hasVote` | `boolean` | | ☐ | | | `voters_id` | `string` | | ☐ | | | `votes_1` | `int32` | | ☐ | | | `votes` | `int32` | Votes | ☐ | | | `watchers_$type` | `string` | | ☐ | | | `watchers_hasStar` | `boolean` | | ☐ | | | `watchers_id` | `string` | | ☐ | | | `wikifiedDescription_1` | `string` | | ☐ | | | `wikifiedDescription` | `string` | Wikified Description | ☐ | |