invantive documentation
Forum di supporto InvantiveAccedi / Registrati

HelpdeskArticles: Crisp Helpdesk Articles

read only

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

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella HelpdeskArticles. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: