SiteWidgets
Query and update the active and inactive widgets for a site.
Table-Specific Information
SELECT
The connector uses the WordPress API to process the following filter server-side. Other filters are processed client-side within the connector.
- Id supports the = operator.
For example, the following query is processed server-side.
SELECT * FROM SiteWidgets WHERE Id = 'text-5'
UPDATE
To update a site widget, you must specify the following column: Id.
UPDATE SiteWidgets SET Sidebar = 'sidebar-2' WHERE Id = 'text-5'
DELETE
To delete a site widget, you must specify the following column: Id.
DELETE FROM SiteWidgets WHERE Id = 'text-5'
Note: Deleting a site widget follows a two-step process. The first delete deactivates the widget. A second delete on the same Id permanently deletes it. If the widget is already deactivated, the delete will permanently remove it.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique identifier assigned to the widget instance. | |
| IdBase | String | True |
The base identifier shared by all instances of this widget type. | |
| Position | Integer | False |
The widget's display order within its assigned sidebar. | |
| Sidebar | String | False |
The identifier of the sidebar where the widget is currently active. | |
| SettingsAggregate | String | False |
A collection of configuration settings that define the widget's behavior and appearance. |