SSIS Components for WordPress

Build 25.0.9434

AuditHistoryforComments

Returns a history of changes and status updates for comments in WordPress.

Table Specific Information

SELECT

The component uses the WordPress API to process some of the filters. Note: Events with status-trash or status-unapproved will not populate using simple SELECT, respective CommentId will be required to populate the values for those Events.

  • CommentId supports the '=' comparison.

The component processes other filters client-side within the component.

For example, the following queries are processed server side.

SELECT * FROM AuditHistoryforComments WHERE CommentId = 10

Columns

Name Type References Description
CommentId Int

Comments.Id

Specifies the identifier of the comment whose changes are recorded in the audit history.
Event String The type of action recorded for the comment, such as create, update, or delete.

The allowed values are check-ham, status-approved, status-trash, status-unapproved.

Time Timestamp The timestamp when the event related to the comment occurred.
User String The user who performed the action recorded in the audit log.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434