JDBC Driver for Act-On

Build 22.0.8462

Spamcomplaint

Query records of a Spamcomplaint list.

View Specific Information

Select

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.

  • Timestamp supports the '>=' , '>' , '<=' and '<' operator.

For example:

SELECT * FROM Spamcomplaint

SELECT * FROM Spamcomplaint WHERE Timestamp >= '2022-09-15 08:53:50.111' AND Timestamp <= '2022-09-16 00:30:33.14'

SELECT * FROM Spamcomplaint WHERE Timestamp > '2022-09-15 08:53:50.111' AND Timestamp < '2022-09-16 00:30:33.14'

Columns

Name Type Description
Email String Email of the user.
Origin String Origin.
Timestamp Timestamp When the user joined the list.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462