FireDAC Components for Act-On

Build 20.0.7654

Messages

Query the available messages in ActOn.

View Specific Information

The component 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 component.

  • Type supports the '='operator.
For example, the following query is processed server side:
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.

Columns

Name Type Description
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-Columns

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.

Name Type Description
Type String Used as a filter to retrieve different types of messages.

The allowed values are SENT, DRAFT, TEMPLATE, TRIGGERED, FAILED, SCHEDULED.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654