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. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data.
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 | Description |
| Id [KEY] | Integer | True |
Unique identifier for the post |
| Date | Datetime | False |
The date the post was created in the site's timezone |
| DateGMT | Datetime | False |
Date in the GMT format |
| Slug | String | False |
Slug Type |
| Status | String | False |
A named status for the post |
| Title | Object | False |
The title for the post |
| Link | String | False |
Member link |