# HelpdeskArticleContents: Crisp Helpdesk Article Contents - Catalog: `Crisp` - Schema: `Views` - Label: Helpdesk Article Contents This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `HelpdeskArticleContents` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `article_id` | `varchar2` | | ☑ | Article identifier. | | `article_id` | `varchar2` | | ☑ | Article identifier. | | `content` | `varchar2` | | ☐ | Text content of the article. | | `content` | `varchar2` | | ☐ | Text content of the article. | | `created_at` | `datetime` | | ☑ | Article creation timestamp. | | `created_at` | `datetime` | | ☑ | Article creation timestamp. | | `description` | `varchar2` | | ☐ | Description of the article (if any). | | `description` | `varchar2` | | ☐ | Description of the article (if any). | | `featured` | `char` | | ☐ | Whether the article is featured or not. | | `featured` | `char` | | ☐ | Whether the article is featured or not. | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `order` | `int32` | | ☐ | Article ordering weight. | | `order` | `int32` | | ☐ | Article ordering weight. | | `published_at` | `datetime` | | ☐ | Article publication timestamp. | | `published_at` | `datetime` | | ☐ | Article publication timestamp. | | `status` | `varchar2` | | ☑ | Status of the article; one of published and draft. | | `status` | `varchar2` | | ☑ | Status of the article; one of published and draft. | | `title` | `varchar2` | | ☑ | Title of the article. | | `title` | `varchar2` | | ☑ | Title of the article. | | `updated_at` | `datetime` | | ☑ | Article update timestamp. | | `updated_at` | `datetime` | | ☑ | Article update timestamp. | | `url` | `varchar2` | | ☐ | Public URL of the article when published. | | `url` | `varchar2` | | ☐ | Public URL of the article when published. | | `visibility` | `varchar2` | | ☐ | Visibility of the article when published; one of visible and hidden. | | `visibility` | `varchar2` | | ☐ | Visibility of the article when published; one of visible and hidden. | | `visits` | `int64` | | ☐ | Number of times the article has been visited. | | `visits` | `int64` | | ☐ | Number of times the article has been visited. |# HelpdeskArticleContents: Crisp Helpdesk Article Contents - Catalog: `Crisp` - Schema: `Views` - Label: Helpdesk Article Contents This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `HelpdeskArticleContents` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `article_id` | `varchar2` | | ☑ | Article identifier. | | `article_id` | `varchar2` | | ☑ | Article identifier. | | `content` | `varchar2` | | ☐ | Text content of the article. | | `content` | `varchar2` | | ☐ | Text content of the article. | | `created_at` | `datetime` | | ☑ | Article creation timestamp. | | `created_at` | `datetime` | | ☑ | Article creation timestamp. | | `description` | `varchar2` | | ☐ | Description of the article (if any). | | `description` | `varchar2` | | ☐ | Description of the article (if any). | | `featured` | `char` | | ☐ | Whether the article is featured or not. | | `featured` | `char` | | ☐ | Whether the article is featured or not. | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `order` | `int32` | | ☐ | Article ordering weight. | | `order` | `int32` | | ☐ | Article ordering weight. | | `published_at` | `datetime` | | ☐ | Article publication timestamp. | | `published_at` | `datetime` | | ☐ | Article publication timestamp. | | `status` | `varchar2` | | ☑ | Status of the article; one of published and draft. | | `status` | `varchar2` | | ☑ | Status of the article; one of published and draft. | | `title` | `varchar2` | | ☑ | Title of the article. | | `title` | `varchar2` | | ☑ | Title of the article. | | `updated_at` | `datetime` | | ☑ | Article update timestamp. | | `updated_at` | `datetime` | | ☑ | Article update timestamp. | | `url` | `varchar2` | | ☐ | Public URL of the article when published. | | `url` | `varchar2` | | ☐ | Public URL of the article when published. | | `visibility` | `varchar2` | | ☐ | Visibility of the article when published; one of visible and hidden. | | `visibility` | `varchar2` | | ☐ | Visibility of the article when published; one of visible and hidden. | | `visits` | `int64` | | ☐ | Number of times the article has been visited. | | `visits` | `int64` | | ☐ | Number of times the article has been visited. |