invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SolutionFolderArticles: Freshdesk

read only

  • Catalogus: Freshdesk
  • Schema: Views

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel SolutionFolderArticles worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
scr_created_at datetime Aangemaakt op Date/time at which the record was created.
scr_description varchar2 Description
scr_id int64 ID
scr_name varchar2 Name
scr_updated_at datetime Bijgewerkt op Date/time at which the record was last updated.
scr_visibility int64 Visibility
scy_created_at datetime Aangemaakt op 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 Standaard 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 Bijgewerkt op Date/time at which the record was last updated.
sfe_agent_id int64 Agent ID
sfe_art_type int64 Typesoort Type of the article.Zie SolutionArticleTypes.
sfe_category_id int64 Categorie ID
sfe_created_at datetime Aangemaakt op Date/time at which the record was created.
sfe_description varchar2 Description Description.
sfe_description_text varchar2 Description
sfe_folder_id int64 Map 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 Omschrijving
sfe_seo_data_meta_keywords varchar2 SEO Trefwoorden
sfe_seo_data_meta_title varchar2 SEO Titel
sfe_status int64 Status Status of the article.Zie SolutionArticleStatuses.
sfe_thumbs_down int64 Duimen Omlaag Number of down votes for the solution article.
sfe_thumbs_up int64 Duimen Omhoog Number of upvotes for the solution article.
sfe_title varchar2 Title Title of the solution article.
sfe_type int64 Type
sfe_updated_at datetime Bijgewerkt op Date/time at which the record was last updated.
sfe_user_id int64 Gebruikers-ID ID of the user who created the solution article.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: