SuspendedTickets
Returns tickets that have been suspended and are pending review or deletion.
Table-Specific Information
Select
The following queries are processed server-side while other filters are processed client-side within the provider.
SELECT * FROM SuspendedTickets WHERE Id = '123'
SELECT * FROM SuspendedTickets ORDER BY AuthorEmail
SELECT * FROM SuspendedTickets ORDER BY Cause
SELECT * FROM SuspendedTickets ORDER BY Subject
SELECT * FROM SuspendedTickets ORDER BY CreatedAt
Delete
You must specify the Id of the suspended ticket to delete it. This operation is allowed for logged-in users with the "unrestricted agent" role.
DELETE FROM SuspendedTickets WHERE Id = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
The unique Id of the suspended ticket, automatically assigned when the ticket is created. | |
| TicketId | Integer | True |
Tickets.Id |
The ticket ID this suspended email is associated with, if available. |
| MessageId | String | True |
The ID of the email, if available. | |
| BrandId | Long | True |
Brands.Id |
The Id of the brand this ticket is associated with, applicable only for enterprise accounts. |
| Recipient | String | True |
The original recipient e-mail address of the ticket. | |
| Subject | String | True |
The value of the subject field for this ticket. | |
| Content | String | True |
The content that was flagged. | |
| AuthorId | Long | True |
The Id of the author who sent the suspended ticket. | |
| AuthorName | String | True |
The name of the author. | |
| AuthorEmail | String | True |
The email of the author. | |
| Cause | String | True |
Why the ticket was suspended. | |
| CreatedAt | Datetime | True |
The date and time when this record was created. | |
| UpdatedAt | Datetime | True |
The date and time when this record was last updated. | |
| ViaChannel | String | True |
The channel through which the ticket was suspended. | |
| ViaSourceFromId | Long | True |
The Id of the source from which the ticket was suspended. | |
| ViaSourceFromTitle | String | True |
The title of the source from which the ticket was suspended. | |
| ViaSourceTo | String | True |
The destination of the source from which the ticket was suspended. | |
| ViaSourceRel | String | True |
The relationship of the source from which the ticket was suspended. | |
| Url | String | True |
The API URL of this ticket. |