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.