DeletedEntities
Query deleted Entities.
Table Specific Information
Select
The Reckon component requires filtering on ListDelType in order to perform the query, for example:
SELECT * FROM DeletedEntities WHERE ListDelType='Account'
Columns
| Name | Type | References | Description |
| ListID [KEY] | String | The unique identifier. | |
| ListDelType | String | The owner of a data extension. | |
| FullName | String | The entity full name. | |
| TimeCreated | Datetime | The time the object was created. | |
| TimeDeleted | Datetime | The time the object was deleted. |
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 | |
| StartModifiedDate | String | Earliest modified date to search for. | |
| EndModifiedDate | String | Latest modified date to search for. |