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'
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. |