JDBC Driver for Zendesk

Build 24.0.8963

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 本製品.
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.

使用できる値は次のとおりです。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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963