Members
Create, update, delete, and list the Members of the website.
Table Specific Information
SELECT
The add-in uses the WordPress API to process some of the filters. The add-in processes other filters client-side within the add-in.
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. |