# HelpdeskFeedbacks: Crisp Helpdesk Feedbacks - Catalog: `Crisp` - Schema: `Views` - Label: Helpdesk Feedbacks 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 `HelpdeskFeedbacks` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `article_id` | `varchar2` | | ☐ | Identifier of the article the feedback belongs to. | | `article_id` | `varchar2` | | ☐ | Identifier of the article the feedback belongs to. | | `article_title` | `varchar2` | | ☐ | Title of the article the feedback belongs to. | | `article_title` | `varchar2` | | ☐ | Title of the article the feedback belongs to. | | `article_url` | `varchar2` | | ☐ | Public URL of the article when published. | | `article_url` | `varchar2` | | ☐ | Public URL of the article when published. | | `comment` | `varchar2` | | ☐ | Comment left with the feedback (if any). | | `comment` | `varchar2` | | ☐ | Comment left with the feedback (if any). | | `created_at` | `datetime` | | ☑ | Feedback creation timestamp. | | `created_at` | `datetime` | | ☑ | Feedback creation timestamp. | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `rating` | `varchar2` | | ☑ | Rating of the feedback; one of helpful and unhelpful. | | `rating` | `varchar2` | | ☑ | Rating of the feedback; one of helpful and unhelpful. | | `session_assigned_user_id` | `varchar2` | | ☐ | Operator user identifier assigned to the session (if any). | | `session_assigned_user_id` | `varchar2` | | ☐ | Operator user identifier assigned to the session (if any). | | `session_avatar` | `varchar2` | | ☐ | Avatar of the author of the feedback. | | `session_avatar` | `varchar2` | | ☐ | Avatar of the author of the feedback. | | `session_email` | `varchar2` | | ☐ | Email of the author of the feedback. | | `session_email` | `varchar2` | | ☐ | Email of the author of the feedback. | | `session_geolocation_city` | `varchar2` | | ☐ | City name. | | `session_geolocation_city` | `varchar2` | | ☐ | City name. | | `session_geolocation_country` | `varchar2` | | ☐ | Country code. | | `session_geolocation_country` | `varchar2` | | ☐ | Country code. | | `session_geolocation_region` | `varchar2` | | ☐ | Region code. | | `session_geolocation_region` | `varchar2` | | ☐ | Region code. | | `session_id` | `varchar2` | | ☐ | Session identifier of the author of the feedback (if any). | | `session_id` | `varchar2` | | ☐ | Session identifier of the author of the feedback (if any). | | `session_nickname` | `varchar2` | | ☐ | Nickname of the author of the feedback. | | `session_nickname` | `varchar2` | | ☐ | Nickname of the author of the feedback. |# HelpdeskFeedbacks: Crisp Helpdesk Feedbacks - Catalog: `Crisp` - Schema: `Views` - Label: Helpdesk Feedbacks 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 `HelpdeskFeedbacks` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `article_id` | `varchar2` | | ☐ | Identifier of the article the feedback belongs to. | | `article_id` | `varchar2` | | ☐ | Identifier of the article the feedback belongs to. | | `article_title` | `varchar2` | | ☐ | Title of the article the feedback belongs to. | | `article_title` | `varchar2` | | ☐ | Title of the article the feedback belongs to. | | `article_url` | `varchar2` | | ☐ | Public URL of the article when published. | | `article_url` | `varchar2` | | ☐ | Public URL of the article when published. | | `comment` | `varchar2` | | ☐ | Comment left with the feedback (if any). | | `comment` | `varchar2` | | ☐ | Comment left with the feedback (if any). | | `created_at` | `datetime` | | ☑ | Feedback creation timestamp. | | `created_at` | `datetime` | | ☑ | Feedback creation timestamp. | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `rating` | `varchar2` | | ☑ | Rating of the feedback; one of helpful and unhelpful. | | `rating` | `varchar2` | | ☑ | Rating of the feedback; one of helpful and unhelpful. | | `session_assigned_user_id` | `varchar2` | | ☐ | Operator user identifier assigned to the session (if any). | | `session_assigned_user_id` | `varchar2` | | ☐ | Operator user identifier assigned to the session (if any). | | `session_avatar` | `varchar2` | | ☐ | Avatar of the author of the feedback. | | `session_avatar` | `varchar2` | | ☐ | Avatar of the author of the feedback. | | `session_email` | `varchar2` | | ☐ | Email of the author of the feedback. | | `session_email` | `varchar2` | | ☐ | Email of the author of the feedback. | | `session_geolocation_city` | `varchar2` | | ☐ | City name. | | `session_geolocation_city` | `varchar2` | | ☐ | City name. | | `session_geolocation_country` | `varchar2` | | ☐ | Country code. | | `session_geolocation_country` | `varchar2` | | ☐ | Country code. | | `session_geolocation_region` | `varchar2` | | ☐ | Region code. | | `session_geolocation_region` | `varchar2` | | ☐ | Region code. | | `session_id` | `varchar2` | | ☐ | Session identifier of the author of the feedback (if any). | | `session_id` | `varchar2` | | ☐ | Session identifier of the author of the feedback (if any). | | `session_nickname` | `varchar2` | | ☐ | Nickname of the author of the feedback. | | `session_nickname` | `varchar2` | | ☐ | Nickname of the author of the feedback. |