CustomTicketStatuses
Create, update, and query custom ticket statuses in zendesk.
Table Specific Information
Select
The following queries are processed server-side, while other filters are processed client-side in the connector.SELECT * FROM CustomTicketStatuses 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 |
Automatically assigned when the custom ticket status is created. | |
| Active | Boolean | False |
If true, the custom status is set to active, If false, the custom status is set to inactive. | |
| URL | String | True |
The label displayed to agents. Maximum length is 48 characters. | |
| AgentLabel | String | False |
The label displayed to agents. Maximum length is 48 characters. | |
| Default | Boolean | False |
If true, the custom status is set to default. If false, the custom status is set to non-default. | |
| 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 the custom ticket status was created. | |
| UpdatedAt | Datetime | True |
The time of the last update of the ticket field. |