CustomTicketStatuses
Represents the custom ticket statuses available in the account.
Table-Specific Information
Select
The following queries are processed server-side, while other filters are processed client-side in the provider.SELECT * FROM CustomTicketStatuses WHERE Id = 9930628462492
Insert
INSERT INTO CustomTicketStatuses (active,agentlabel,description,enduserdescription,enduserlabel,statuscategory) VALUES ('true', 'Try to Respond quickly', 'Customer needs a response quickly', 'Your ticket is being responded to', 'Urgent processing', 'open')
Update
UPDATE CustomTicketStatuses SET description = 'Customer needs a response quickly.' WHERE Id = 9930628462492
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
The Id of the custom ticket status, automatically assigned when it is created. | |
| Active | Boolean | False |
Indicates whether the custom status is active. | |
| URL | String | True |
The API URL of this custom ticket status. | |
| AgentLabel | String | False |
The label displayed to agents. Maximum length is 48 characters. | |
| Default | Boolean | False |
Indicates whether this is the default custom status. | |
| Description | String | False |
The description of when the user should select this custom ticket status. | |
| StatusCategory | String | False |
The status category the custom ticket status belongs to. The allowed values are new, open, hold, pending, solved. | |
| EndUserLabel | String | False |
The label displayed to end users. Maximum length is 48 characters. | |
| EndUserDescription | String | False |
The description displayed to end users. | |
| RawAgentLabel | String | True |
The dynamic content placeholder. If the dynamic content placeholder is not available, this is the agent_label value. | |
| RawDescription | String | True |
The dynamic content placeholder. If the dynamic content placeholder is not available, this is the raw_description value. | |
| RawEndUserLabel | String | True |
The dynamic content placeholder. If the dynamic content placeholder is not available, this is the raw_end_user_label value. | |
| RawEndUserDescription | String | True |
The dynamic content placeholder. If the dynamic content placeholder is not available, this is the raw_end_user_description value. | |
| CreatedAt | Datetime | True |
The date and time when the custom ticket status was created. | |
| UpdatedAt | Datetime | True |
The date and time when the custom ticket status was last updated. |