Members
Create, update, delete, and list the Members of the website.
Table Specific Information
SELECT
The connector uses the WordPress API to process some of the filters. The connector processes other filters client-side within the connector.
For example, the following queries are processed server side.
SELECT * FROM Members WHERE Id = 10
Update
To update a member you must specify the following column: Id.
UPDATE Members SET Title = 'updatedName' WHERE Id = '139'
Delete
To delete a member you must specify the following column: Id.
DELETE FROM Members WHERE Id = '139'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the member record in WordPress. | |
| Date | Datetime | False |
The date and time when the member record was created, recorded in the site's local timezone. | |
| DateGMT | Datetime | False |
The date and time when the member record was created, recorded in Greenwich Mean Time (GMT). | |
| Slug | String | False |
The URL-friendly version of the member name, used to create clean and readable links. | |
| Status | String | False |
Indicates the current status of the member record, such as active or inactive. | |
| Title | Object | False |
The display name or title assigned to the member. | |
| Link | String | False |
The direct URL linking to the member's public profile or related content. |