invantive documentation
Invantive Support ForumsLog In / Sign Up

SolutionFolderArticleTags: Freshdesk

read only

  • Catalog: Freshdesk
  • Schema: Views

Can only retrieve data.

Table Columns

The columns of the table SolutionFolderArticleTags are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
scr_created_at datetime Created at Date/time at which the record was created.
scr_description varchar2 Description
scr_id int64 ID
scr_name varchar2 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 varchar2 Description Description.
scy_id int64 ID Unique ID of the solution category.
scy_is_default char Is Default Whether the category is a default category.
scy_name varchar2 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 varchar2 Description Description.
sfe_description_text varchar2 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 varchar2 SEO Description
sfe_seo_data_meta_keywords varchar2 SEO Keywords
sfe_seo_data_meta_title varchar2 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 varchar2 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.
sfg_agent_id int64 Agent ID
sfg_category_id int64 Category ID
sfg_created_at datetime Created at Date/time at which the record was created.
sfg_description varchar2 Description
sfg_description_text varchar2 Description
sfg_folder_id int64 Folder ID
sfg_hits int64 Hits
sfg_id int64 ID
sfg_seo_data_meta_description varchar2 SEO Description
sfg_seo_data_meta_keywords varchar2 SEO Keywords
sfg_seo_data_meta_title varchar2 SEO Title
sfg_status int64 Status
sfg_tags varchar2 Tags
sfg_title varchar2 Title
sfg_tumbs_down int64 Thumbs Down
sfg_tumbs_up int64 Thumbs Up
sfg_type int64 Type
sfg_updated_at datetime Updated at Date/time at which the record was last updated.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: