invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

HelpdeskArticles: Crisp Helpdesk Articles

read only

  • Catalogue : Crisp
  • Schéma : Views
  • Label: Helpdesk Articles

Permet uniquement de récupérer des données.

Colonnes de table

Les colonnes de la table HelpdeskArticles sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
article_id varchar2 itgen_crp_article_id filters on the platform, writable Article identifier.
category_color varchar2 itgen_crp_category_color filters on the platform, writable Colour of the category as a hexadecimal colour code (if any).
category_id varchar2 itgen_crp_category_id filters on the platform, writable Identifier of the category of the article (if any).
category_name varchar2 itgen_crp_category_name filters on the platform, writable Name of the category of the article (if any).
created_at datetime itgen_crp_created_at filters on the platform, writable Article creation timestamp.
featured char itgen_crp_featured filters on the platform, writable Whether the article is featured or not.
locale varchar2 itgen_crp_locale filters on the platform, writable Locale code of the helpdesk (ISO 639-1).
order int32 itgen_crp_order filters on the platform, writable Article ordering weight.
published_at datetime itgen_crp_published_at filters on the platform, writable Article publication timestamp.
section_id varchar2 itgen_crp_section_id filters on the platform, writable Identifier of the section within the category (if any).
section_name varchar2 itgen_crp_section_name filters on the platform, writable Name of the section within the category (if any).
status varchar2 itgen_crp_status filters on the platform, writable Status of the article; one of published and draft.
title varchar2 itgen_crp_title filters on the platform, writable Title of the article.
updated_at datetime itgen_crp_updated_at filters on the platform, writable Article update timestamp.
url varchar2 itgen_crp_url filters on the platform, writable Public URL of the article when published.
visibility varchar2 itgen_crp_visibility filters on the platform, writable Visibility of the article when published; one of visible and hidden.
visits int64 itgen_crp_visits filters on the platform, writable Number of times the article has been visited.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :