Query the available messages in ActOn.
View Specific Information
The driver will use the Act-On API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.
- Type supports the '='operator.
SELECT * FROM Messages WHERE Type = 'SENT'Type can be one of: SENT, DRAFT, TEMPLATE, TRIGGERED, FAILED, SCHEDULED
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will result in unfiltered data being pushed.
|Id [KEY]||String||The Id of the message.|
|Timestamp||Datetime||When the message has been sent.|
|Title||String||Title of the message.|
|FolderName||String||The folder where the message is contained.|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|Type||String||Used as a filter to retrieve different types of messages.
The allowed values are SENT, DRAFT, TEMPLATE, TRIGGERED, FAILED, SCHEDULED.