invantive documentation
Invantive Support ForumsLog In / Sign Up

SolutionFolderArticles: Freshdesk

read only

  • Catalog: Freshdesk
  • Schema: Views

Can only retrieve data.

Table Columns

The columns of the table SolutionFolderArticles 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.

Release Notes

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