# CustomFields - Catalog: `YouTrack` - Schema: `Issues` - Select YouTrack API URL: `/issues` - Insert YouTrack API URL: `/issues` - Update YouTrack API URL: `/issues` - Delete YouTrack API URL: `/issues` - Field Selection Method: NotRequired - Base Path: `customFields[*]` - Select YouTrack API Operation: `get /issues` 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 | |---|:---:|:---:|:---:|---| | `customFields` | `string` | ☐ | | <p>The name of the custom field to show in the response. When you use this parameter and request the custom field data in the request URL, the response only shows the requested custom fields instead of all of them.</p><p>To show more than one custom field, use this parameter several times.</p><p>See Sample 2 for reference.</p> | | `query` | `string` | ☐ | | Issues search query. Read more about search syntax here: <a href="https://www.jetbrains.com/help/youtrack/incloud/?Search-and-Command-Attributes">Search Query Reference</a> | ## Columns of Table Function The columns of the table function `CustomFields` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `$type_1` | `string` | | ☐ | | | `$type` | `string` | | ☐ | | | `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_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` | `string` | ID | ☐ | | | `idReadable` | `string` | Readable ID | ☐ | | | `isDraft` | `boolean` | Is Draft | ☐ | | | `name` | `string` | Name | ☐ | | | `numberInProject` | `int64` | Number in Project | ☐ | | | `parent_$type` | `string` | | ☐ | | | `parent_direction` | `string` | | ☐ | | | `parent_id` | `string` | | ☐ | | | `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` | | ☐ | | | `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` | | ☐ | | | `projectCustomField_$type` | `string` | | ☐ | | | `projectCustomField_canBeEmpty` | `boolean` | | ☐ | | | `projectCustomField_emptyFieldText` | `string` | | ☐ | | | `projectCustomField_hasRunningJob` | `boolean` | | ☐ | | | `projectCustomField_id` | `string` | | ☐ | | | `projectCustomField_isPublic` | `boolean` | | ☐ | | | `projectCustomField_ordinal` | `int32` | | ☐ | | | `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` | `int64` | Resolved | ☐ | | | `subtasks_$type` | `string` | | ☐ | | | `subtasks_direction` | `string` | | ☐ | | | `subtasks_id` | `string` | | ☐ | | | `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` | | ☐ | | | `summary` | `string` | Summary | ☐ | | | `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` | `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 | ☐ | |