# WebsiteSettingsById ## Documentation Website settings. - Catalog: `Crisp` - Schema: `Crisp` - Primary Keys: `website_id` - Retrieve: True - Insert: True - Update: False - Delete: False ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `WebsiteSettingsById`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `website_id` | `varchar2` | ☑ | | The website identifier. | ## Columns of Table Function The columns of the table function `WebsiteSettingsById` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `audit_log` | `char` | | ☐ | Whether audit log is enabled or not. | | `chatbox_activity_metrics` | `char` | | ☐ | Whether to show activity metrics in chatbox or not. | | `chatbox_availability_tooltip` | `char` | | ☐ | Whether to show availability tooltip or not. | | `chatbox_check_domain` | `char` | | ☐ | Whether to check website domain before creating sessions or not. | | `chatbox_color_theme` | `varchar2` | | ☐ | Which color theme to use. | | `chatbox_email_visitors` | `char` | | ☐ | Whether to ask for visitor email or not. | | `chatbox_file_transfer` | `char` | | ☐ | Whether to show the file upload tools in chatbox. | | `chatbox_force_identify` | `char` | | ☐ | Whether to force visitor to identify or not (requires at least email or phone ask enabled). | | `chatbox_helpdesk_link` | `char` | | ☐ | Whether to show a link to helpdesk in chatbox (if helpdesk is configured). | | `chatbox_helpdesk_only` | `char` | | ☐ | Whether to restrict the chatbox to show the helpdesk view only, and disable chat (if helpdesk is configured). | | `chatbox_hide_on_away` | `char` | | ☐ | Whether to hide chatbox on away or not. | | `chatbox_hide_on_mobile` | `char` | | ☐ | Whether to hide chatbox on mobile devices or not. | | `chatbox_hide_vacation` | `char` | | ☐ | Whether to place website support in vacation or not (this hides the chatbox). | | `chatbox_ignore_privacy` | `char` | | ☐ | Whether to disable privacy filters and ignore user choices (eg. user Do Not Track value). | | `chatbox_last_operator_face` | `char` | | ☐ | Whether to show last operator face in chatbox button or not. | | `chatbox_locale` | `varchar2` | | ☐ | Which locale to enforce (can be blank for auto-detect, ISO 639-1). | | `chatbox_ongoing_operator_face` | `char` | | ☐ | Whether to show ongoing operator face in chatbox button or not. | | `chatbox_operator_privacy` | `char` | | ☐ | Whether to enable operator privacy options or not. | | `chatbox_overlay_mode` | `char` | | ☐ | Whether to restrict the chatbox to show search via Crisp Overlay before the user can contact support. | | `chatbox_overlay_search` | `char` | | ☐ | Whether to show a button to search in all support resources via Crisp Overlay. | | `chatbox_phone_visitors` | `char` | | ☐ | Whether to ask for visitor phone or not. | | `chatbox_position_reverse` | `char` | | ☐ | Whether reverse chatbox position or not. | | `chatbox_status_health_dead` | `char` | | ☐ | Whether to show status banner, when status page reports as dead (if Status Page plugin is used). | | `chatbox_text_theme` | `varchar2` | | ☐ | Which text theme to use. | | `chatbox_tile` | `varchar2` | | ☐ | Which tile to use for messages view background in chatbox (set to blank value for none). | | `chatbox_visitor_compose` | `char` | | ☐ | Whether to show visitor compose preview or not (MagicType from visitor). | | `chatbox_wait_game` | `char` | | ☐ | Whether to suggest user to play a wait game or not (if operators do not reply fast enough). | | `chatbox_website_logo` | `char` | | ☐ | Whether to show website logo in chatbox button or not. | | `chatbox_welcome_message` | `varchar2` | | ☐ | Which welcome message to display on chatbox open. | | `contact_email` | `varchar2` | | ☐ | Contact email (can be blank). | | `contact_instagram` | `varchar2` | | ☐ | Contact handle on Instagram (can be blank). | | `contact_messenger` | `varchar2` | | ☐ | Contact handle on Messenger (can be blank). | | `contact_phone` | `varchar2` | | ☐ | Contact phone (can be blank). | | `contact_telegram` | `varchar2` | | ☐ | Contact handle on Telegram (can be blank). | | `contact_twitter` | `varchar2` | | ☐ | Contact handle on Twitter (can be blank). | | `contact_whatsapp` | `varchar2` | | ☐ | Contact number on WhatsApp (can be blank). | | `domain` | `varchar2` | | ☑ | Website domain. | | `emails_enrich` | `char` | | ☐ | Whether to enable profile enrichment based on email or not. | | `emails_junk_filter` | `char` | | ☐ | Whether to enable the junk filter or not. | | `emails_rating` | `char` | | ☐ | Whether to ask users to rate support or not. | | `emails_transcript` | `char` | | ☐ | Whether to notify users of transcript records for conversation or not. | | `inbox_force_operator_token` | `char` | | ☐ | Whether to force operators to use Two Factor Authentication or not. | | `inbox_lock_removal` | `char` | | ☐ | Whether to prevent non-owner operators to remove data or not. | | `logo` | `varchar2` | | ☐ | Logo. | | `name` | `varchar2` | | ☑ | Name. | | `website_id` | `varchar2` | | ☑ | Website ID. |