SolutionFolderArticleAttachments |
Catalogus: Freshdesk
Schema: Views
Dit is een alleen-lezen view. De Freshdesk API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive SQL-stuurprogramma voor Freshdesk ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Freshdesk-API.
View Kolommen
De kolommen van de view SolutionFolderArticleAttachments worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
scr_created_at |
datetime |
Created at |
☐ |
Date/time at which the record was created. |
scr_description |
string |
Description |
☐ |
|
scr_id |
int64 |
ID |
☐ |
|
scr_name |
string |
Name |
☐ |
|
scr_updated_at |
datetime |
Updated at |
☐ |
Date/time at which the record was last updated. |
scr_visibility |
int64 |
Visibility |
☐ |
|
scy_created_at |
datetime |
Created at |
☐ |
Date/time at which the record was created. |
scy_description |
string |
Description |
☐ |
Description. |
scy_id |
int64 |
ID |
☐ |
Unique ID of the solution category. |
scy_is_default |
boolean |
Is Default |
☐ |
Whether the category is a default category. |
scy_name |
string |
Name |
☐ |
Name of the solution category. |
scy_position |
int64 |
Position |
☐ |
Rank of the solution category in the category listing. |
scy_updated_at |
datetime |
Updated at |
☐ |
Date/time at which the record was last updated. |
sfe_agent_id |
int64 |
Agent ID |
☐ |
|
sfe_art_type |
int64 |
Art Type |
☐ |
Type of the article. See SolutionArticleTypes. |
sfe_category_id |
int64 |
Category ID |
☐ |
|
sfe_created_at |
datetime |
Created at |
☐ |
Date/time at which the record was created. |
sfe_description_text |
string |
Description |
☐ |
|
sfe_description |
string |
Description |
☐ |
Description. |
sfe_folder_id |
int64 |
Folder ID |
☐ |
ID of the folder under which the article is listed. |
sfe_hits |
int64 |
Hits |
☐ |
|
sfe_id |
int64 |
ID |
☐ |
Unique ID of the solution article. |
sfe_position |
int64 |
Position |
☐ |
The rank of the solution article in the article listing. |
sfe_seo_data_meta_description |
string |
SEO Description |
☐ |
|
sfe_seo_data_meta_keywords |
string |
SEO Keywords |
☐ |
|
sfe_seo_data_meta_title |
string |
SEO Title |
☐ |
|
sfe_status |
int64 |
Status |
☐ |
Status of the article. See SolutionArticleStatuses. |
sfe_thumbs_down |
int64 |
Thumbs Down |
☐ |
Number of down votes for the solution article. |
sfe_thumbs_up |
int64 |
Thumbs Up |
☐ |
Number of upvotes for the solution article. |
sfe_title |
string |
Title |
☐ |
Title of the solution article. |
sfe_type |
int64 |
Type |
☐ |
|
sfe_updated_at |
datetime |
Updated at |
☐ |
Date/time at which the record was last updated. |
sfe_user_id |
int64 |
User ID |
☐ |
ID of the user who created the solution article. |
sft_agent_id |
int64 |
Agent ID |
☐ |
|
sft_attachments_attachment_url |
string |
Attachments URL |
☐ |
|
sft_attachments_content_type |
string |
Attachments Content Type |
☐ |
|
sft_attachments_created_at |
datetime |
Attachments Created at |
☐ |
|
sft_attachments_id |
int64 |
Attachments ID |
☐ |
|
sft_attachments_name |
string |
Attachments Name |
☐ |
|
sft_attachments_size |
int64 |
Attachments Size |
☐ |
|
sft_attachments_updated_at |
datetime |
Attachments Updated at |
☐ |
|
sft_category_id |
int64 |
Category ID |
☐ |
|
sft_created_at |
datetime |
Created at |
☐ |
Date/time at which the record was created. |
sft_description_text |
string |
Description |
☐ |
|
sft_description |
string |
Description |
☐ |
|
sft_folder_id |
int64 |
Folder ID |
☐ |
|
sft_hits |
int64 |
Hits |
☐ |
|
sft_id |
int64 |
ID |
☐ |
|
sft_seo_data_meta_description |
string |
SEO Description |
☐ |
|
sft_seo_data_meta_keywords |
string |
SEO Keywords |
☐ |
|
sft_seo_data_meta_title |
string |
SEO Title |
☐ |
|
sft_status |
int64 |
Status |
☐ |
|
sft_title |
string |
Title |
☐ |
|
sft_tumbs_down |
int64 |
Thumbs Down |
☐ |
|
sft_tumbs_up |
int64 |
Thumbs Up |
☐ |
|
sft_type |
int64 |
Type |
☐ |
|
sft_updated_at |
datetime |
Updated at |
☐ |
Date/time at which the record was last updated. |
10-12-2022 17:06 Versie 22.0.461-PROD+3719