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 add-in 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. |