invantive documentation
Invantive SupportforenAnmelden / Eintragen

HelpdeskArticles: Crisp Helpdesk Articles

read only

  • Katalog: Crisp
  • Schema: Views
  • Label: Helpdesk Articles

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle HelpdeskArticles sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp 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.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: