# IssuesCustomFields
- Catalog: `YouTrack`
- Schema: `SavedQueries`
- Select YouTrack API URL: `/savedQueries`
- Insert YouTrack API URL: `/savedQueries`
- Update YouTrack API URL: `/savedQueries`
- Delete YouTrack API URL: `/savedQueries`
- Field Selection Method: NotRequired
- Base Path: `issues[*].customFields[*]`
- Select YouTrack API Operation: `get /savedQueries`
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 `IssuesCustomFields` 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` | `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` | | ☐ | |
| `id_1` | `string` | | ☐ | |
| `id_2` | `string` | | ☐ | |
| `id` | `string` | ID | ☐ | |
| `idReadable` | `string` | Readable ID | ☐ | |
| `isDraft` | `boolean` | Is Draft | ☐ | |
| `name_1` | `string` | | ☐ | |
| `name` | `string` | Name | ☐ | |
| `numberInProject` | `int64` | Number in Project | ☐ | |
| `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` | | ☐ | |
| `parent_$type` | `string` | | ☐ | |
| `parent_direction` | `string` | | ☐ | |
| `parent_id` | `string` | | ☐ | |
| `project_archived` | `boolean` | | ☐ | |
| `project_description` | `string` | | ☐ | |
| `project_fromEmail` | `string` | | ☐ | |
| `project_iconUrl` | `string` | | ☐ | |
| `project_replyToEmail` | `string` | | ☐ | |
| `project_shortName` | `string` | | ☐ | |
| `project_startingNumber` | `int64` | | ☐ | |
| `project_template` | `boolean` | | ☐ | |
| `query` | `string` | Query | ☐ | |
| `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 | ☐ | |
| `subtasks_$type` | `string` | | ☐ | |
| `subtasks_direction` | `string` | | ☐ | |
| `subtasks_id` | `string` | | ☐ | |
| `summary` | `string` | Summary | ☐ | |
| `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` | | ☐ | |
| `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` | | ☐ | |
| `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` | | ☐ | |
| `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 | ☐ | |