SettingOptions
View and manage settings options.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query.
These columns support only the = comparison, unless stated otherwise. The available columns for this
table are: Id, SettingId. All other columns are processed client side. If the 'SettingId' filter is
not specified, the adapter will fetch a list of all the settings and perform a request for each setting in the list.
SELECT * FROM SettingOptions WHERE Id = 'woocommerce_excluded_report_order_statuses'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
A unique identifier for the setting. |
| Label | String | True |
A human readable label for the setting used in interfaces. |
| Description | String | True |
A human readable description for the setting used in interfaces. |
| Value | String | False |
Setting value. |
| Default | String | True |
Default value for the setting. |
| Tip | String | True |
Additional help text shown to the user about the setting. |
| Placeholder | String | True |
Placeholder text to be displayed in text inputs. |
| Type | String | True |
Type of setting. Options: text, email, number, color, password, textarea, select, multiselect, radio, image_width and checkbox. |
| GroupId | String | True |
An identifier for the group this setting belongs to. |
| SettingId | String | True |
Id of the setting group. |