# UserIssueTagSavedQueriesByUserId - Catalog: `YouTrack` - Schema: `Users` - Select YouTrack API URL: `/users/{id}/savedQueries` - Insert YouTrack API URL: `/users/{id}/savedQueries` - Update YouTrack API URL: `/users/{id}/savedQueries` - Delete YouTrack API URL: `/users/{id}/savedQueries` - Field Selection Method: NotRequired - Base Path: `issues[*].tags[*]` - Select YouTrack API Operation: `get /users/{id}/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. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☑ | | | ## Columns of Table Function The columns of the table function `UserIssueTagSavedQueriesByUserId` 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_1` | `string` | | ☐ | | | `owner_$type` | `string` | | ☐ | | | `owner_avatarUrl` | `string` | | ☐ | | | `owner_banned` | `boolean` | | ☐ | | | `owner_email` | `string` | | ☐ | | | `owner_fullName` | `string` | | ☐ | | | `owner_guest` | `boolean` | | ☐ | | | `owner_id_1` | `string` | | ☐ | | | `owner_id` | `string` | | ☐ | | | `owner_jabberAccountName` | `string` | | ☐ | | | `owner_login` | `string` | | ☐ | | | `owner_name` | `string` | | ☐ | | | `owner_online` | `boolean` | | ☐ | | | `owner_profiles_$type` | `string` | | ☐ | | | `owner_profiles_id` | `string` | | ☐ | | | `owner_ringId` | `string` | | ☐ | | | `owner_untagOnResolve` | `boolean` | | ☐ | | | `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 | ☐ | | | `untagOnResolve` | `boolean` | | ☐ | | | `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 | ☐ | |