JDBC Driver for WooCommerce

Build 24.0.9062

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 本製品 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

SettingGroups.Id

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062