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_ |
varchar2 |
itgen_crp_article_id | filters on the platform, writable | Article identifier. | |
category_ |
varchar2 |
itgen_crp_category_color | filters on the platform, writable | Colour of the category as a hexadecimal colour code (if any). | |
category_ |
varchar2 |
itgen_crp_category_id | filters on the platform, writable | Identifier of the category of the article (if any). | |
category_ |
varchar2 |
itgen_crp_category_name | filters on the platform, writable | Name of the category of the article (if any). | |
created_ |
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_ |
datetime |
itgen_crp_published_at | filters on the platform, writable | Article publication timestamp. | |
section_ |
varchar2 |
itgen_crp_section_id | filters on the platform, writable | Identifier of the section within the category (if any). | |
section_ |
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_ |
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: