JDBC Driver for Act-On

Build 20.0.7655

Programs

Query the available programs on 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.

For example, the following queries are processed server side:

SELECT * FROM Programs WHERE Type = 'RACK'
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 program.
Name String The name of the program.
IsFavorite Bool Flag denoting if the program is among the 'favorite' ones.
Description String The description of the program.
SrcIds String Ids of the lists involved in the program.
SrcNames String Name of the lists involved in the program.
MessageIds String Ids of the messages sent within the program.
Created Datetime When the program was created.
Modified Datetime When the program was last modified.
NextRun Datetime When the program is going to run again.
State String The state of the program.
Running Bool Flag denoting if the program is running or not.
Active Int Flag denoting if the program is active or not.
Scheduled Bool Flag denoting if the program is scheduled or not.
TagNames String List of tags related to the program.
Valid Bool Flag denoting if the program is valid or not.

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 Type of the program, used for filtering.

The allowed values are RACK, EVENT, LIST_MAINT.

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