Bookmarks
Create, Delete and Query the Bookmarks in Zendesk.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the 本製品.SELECT * FROM Bookmarks
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.
Insert
The TicketId field is required to insert. Allowed for agents.
INSERT INTO Bookmarks (TicketId) VALUES ('4')
Delete
You must specify the Id of the Bookmark to delete it. Allowed for agents.
DELETE FROM Bookmarks WHERE Id = '19152874442641'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
Automatically assigned when the bookmark is created. | |
Ticket | String | True |
The ticket object. | |
url | String | True |
The API url of this bookmark. | |
CreatedAt | Datetime | True |
The time the bookmark was created. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
TicketId | Integer |
The time the bookmark was created. |