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 | References | Description |
| Id [KEY] | String | True |
A unique identifier for the setting. | |
| SettingId [KEY] | String | False |
Id of the setting group. | |
| 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. | |
| Options | String | True |
Array of options (key value pairs) for inputs such as select, multiselect, and radio buttons. |