# WorkItems: YouTrack Work Items - Catalog: `YouTrack` - Schema: `Users` - Label: Work Items - Select YouTrack API URL: `/workItems` - Insert YouTrack API URL: `/workItems` - Update YouTrack API URL: `/workItems` - Delete YouTrack API URL: `/workItems` - Field Selection Method: NotRequired - Select YouTrack API Operation: `get /workItems` 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 | |---|:---:|:---:|:---:|---| | `author` | `string` | ☐ | | Parameter to filter work items by there author. Could specify few values of database id or login or Hub id or 'me' for current logged in user | | `createdEnd` | `int32` | ☐ | | The end timestamp of the interval for work items created date. | | `createdStart` | `int32` | ☐ | | The start timestamp of the interval for work items created date. | | `creator` | `string` | ☐ | | Parameter to filter work items by there creator. Could specify few values of database id or login or Hub id or 'me' for current logged in user | | `end` | `int32` | ☐ | | The end timestamp of the interval for work items date. | | `endDate` | `datetime` | ☐ | | The end date of the interval for work items date. | | `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> | | `start` | `int32` | ☐ | | The start timestamp of the interval for work items date. | | `startDate` | `datetime` | ☐ | | The start date of the interval for work items date. | | `updatedEnd` | `int32` | ☐ | | The end timestamp of the interval for work items updated date. | | `updatedStart` | `int32` | ☐ | | The start timestamp of the interval for work items updated date. | ## Columns of Table Function The columns of the table function `WorkItems` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `$type` | `string` | | ☐ | | | `author_$type` | `string` | | ☐ | | | `author_avatarUrl` | `string` | | ☐ | | | `author_banned` | `boolean` | | ☐ | | | `author_email` | `string` | | ☐ | | | `author_fullName` | `string` | | ☐ | | | `author_guest` | `boolean` | | ☐ | | | `author_id` | `string` | | ☐ | | | `author_jabberAccountName` | `string` | | ☐ | | | `author_login` | `string` | | ☐ | | | `author_online` | `boolean` | | ☐ | | | `author_profiles_$type` | `string` | | ☐ | | | `author_profiles_id` | `string` | | ☐ | | | `author_ringId` | `string` | | ☐ | | | `created` | `int64` | Created | ☐ | | | `creator_$type` | `string` | | ☐ | | | `creator_avatarUrl` | `string` | | ☐ | | | `creator_banned` | `boolean` | | ☐ | | | `creator_email` | `string` | | ☐ | | | `creator_fullName` | `string` | | ☐ | | | `creator_guest` | `boolean` | | ☐ | | | `creator_id` | `string` | | ☐ | | | `creator_jabberAccountName` | `string` | | ☐ | | | `creator_login` | `string` | | ☐ | | | `creator_online` | `boolean` | | ☐ | | | `creator_profiles_$type` | `string` | | ☐ | | | `creator_profiles_id` | `string` | | ☐ | | | `creator_ringId` | `string` | | ☐ | | | `date` | `int64` | Date | ☐ | | | `duration_$type` | `string` | | ☐ | | | `duration_id` | `string` | | ☐ | | | `duration_minutes` | `int32` | | ☐ | | | `duration_presentation` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `issue_$type` | `string` | | ☐ | | | `issue_commentsCount` | `int32` | | ☐ | | | `issue_created` | `int64` | | ☐ | | | `issue_description` | `string` | | ☐ | | | `issue_draftOwner_$type` | `string` | | ☐ | | | `issue_draftOwner_avatarUrl` | `string` | | ☐ | | | `issue_draftOwner_banned` | `boolean` | | ☐ | | | `issue_draftOwner_email` | `string` | | ☐ | | | `issue_draftOwner_fullName` | `string` | | ☐ | | | `issue_draftOwner_guest` | `boolean` | | ☐ | | | `issue_draftOwner_id` | `string` | | ☐ | | | `issue_draftOwner_jabberAccountName` | `string` | | ☐ | | | `issue_draftOwner_login` | `string` | | ☐ | | | `issue_draftOwner_online` | `boolean` | | ☐ | | | `issue_draftOwner_ringId` | `string` | | ☐ | | | `issue_externalIssue_$type` | `string` | | ☐ | | | `issue_externalIssue_id` | `string` | | ☐ | | | `issue_externalIssue_key` | `string` | | ☐ | | | `issue_externalIssue_name` | `string` | | ☐ | | | `issue_externalIssue_url` | `string` | | ☐ | | | `issue_id` | `string` | | ☐ | | | `issue_idReadable` | `string` | | ☐ | | | `issue_isDraft` | `boolean` | | ☐ | | | `issue_numberInProject` | `int64` | | ☐ | | | `issue_parent_$type` | `string` | | ☐ | | | `issue_parent_direction` | `string` | | ☐ | | | `issue_parent_id` | `string` | | ☐ | | | `issue_project_archived` | `boolean` | | ☐ | | | `issue_project_description` | `string` | | ☐ | | | `issue_project_fromEmail` | `string` | | ☐ | | | `issue_project_iconUrl` | `string` | | ☐ | | | `issue_project_replyToEmail` | `string` | | ☐ | | | `issue_project_shortName` | `string` | | ☐ | | | `issue_project_startingNumber` | `int64` | | ☐ | | | `issue_project_template` | `boolean` | | ☐ | | | `issue_reporter_$type` | `string` | | ☐ | | | `issue_reporter_avatarUrl` | `string` | | ☐ | | | `issue_reporter_banned` | `boolean` | | ☐ | | | `issue_reporter_email` | `string` | | ☐ | | | `issue_reporter_fullName` | `string` | | ☐ | | | `issue_reporter_guest` | `boolean` | | ☐ | | | `issue_reporter_id` | `string` | | ☐ | | | `issue_reporter_jabberAccountName` | `string` | | ☐ | | | `issue_reporter_login` | `string` | | ☐ | | | `issue_reporter_online` | `boolean` | | ☐ | | | `issue_reporter_ringId` | `string` | | ☐ | | | `issue_resolved` | `int64` | | ☐ | | | `issue_subtasks_$type` | `string` | | ☐ | | | `issue_subtasks_direction` | `string` | | ☐ | | | `issue_subtasks_id` | `string` | | ☐ | | | `issue_summary` | `string` | | ☐ | | | `issue_updated` | `int64` | | ☐ | | | `issue_updater_$type` | `string` | | ☐ | | | `issue_updater_avatarUrl` | `string` | | ☐ | | | `issue_updater_banned` | `boolean` | | ☐ | | | `issue_updater_email` | `string` | | ☐ | | | `issue_updater_fullName` | `string` | | ☐ | | | `issue_updater_guest` | `boolean` | | ☐ | | | `issue_updater_id` | `string` | | ☐ | | | `issue_updater_jabberAccountName` | `string` | | ☐ | | | `issue_updater_login` | `string` | | ☐ | | | `issue_updater_online` | `boolean` | | ☐ | | | `issue_updater_ringId` | `string` | | ☐ | | | `issue_usesMarkdown` | `boolean` | | ☐ | | | `issue_visibility_$type` | `string` | | ☐ | | | `issue_visibility_id` | `string` | | ☐ | | | `issue_voters_$type` | `string` | | ☐ | | | `issue_voters_hasVote` | `boolean` | | ☐ | | | `issue_voters_id` | `string` | | ☐ | | | `issue_votes` | `int32` | | ☐ | | | `issue_watchers_$type` | `string` | | ☐ | | | `issue_watchers_hasStar` | `boolean` | | ☐ | | | `issue_watchers_id` | `string` | | ☐ | | | `issue_wikifiedDescription` | `string` | | ☐ | | | `text` | `string` | Text | ☐ | | | `textPreview` | `string` | Text Preview | ☐ | | | `type_$type` | `string` | | ☐ | | | `type_autoAttached` | `boolean` | | ☐ | | | `type_id` | `string` | | ☐ | | | `type_name` | `string` | | ☐ | | | `updated` | `int64` | Updated | ☐ | | | `usesMarkdown` | `boolean` | Uses Mark Down | ☐ | |