IssuesAttachments |
Catalog: YouTrack
Schema: 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.
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[*].attachments[*]
Select YouTrack API Operation: get /savedQueries
Table Function Columns
The columns of the table function IssuesAttachments are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
$type_1 |
string |
|
☐ |
|
$type_2 |
string |
|
☐ |
|
$type |
string |
|
☐ |
|
base64Content |
string |
Base64 Content |
☐ |
|
charset |
string |
Charset |
☐ |
|
commentsCount |
int32 |
Comments Count |
☐ |
|
created_1 |
int64 |
|
☐ |
|
created |
int64 |
Created |
☐ |
|
description |
string |
Description |
☐ |
|
draft |
boolean |
Draft |
☐ |
|
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 |
|
☐ |
|
extension |
string |
Extension |
☐ |
|
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 |
☐ |
|
metaData |
string |
Metadata |
☐ |
|
mimeType |
string |
MIME-type |
☐ |
|
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 |
☐ |
|
removed |
boolean |
Removed |
☐ |
|
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 |
☐ |
|
size |
int64 |
Size |
☐ |
|
subtasks_$type |
string |
|
☐ |
|
subtasks_direction |
string |
|
☐ |
|
subtasks_id |
string |
|
☐ |
|
summary |
string |
Summary |
☐ |
|
thumbnailURL |
string |
Thumbnail (URL) |
☐ |
|
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_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_ringId |
string |
|
☐ |
|
url |
string |
URL |
☐ |
|
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 |
☐ |
|
23-06-2022 19:43 Version 22.0.248-PROD+3461