Views

Query and delete Views in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side by the driver. Allowed for agents.

SELECT * FROM Views

SELECT * FROM Views WHERE Id = '123'

SELECT * FROM Views WHERE GroupId = '123'

SELECT * FROM Views WHERE Access = 'Shared'

SELECT * FROM Views WHERE Active = true

SELECT * FROM Views Order By CreatedAt

SELECT * FROM Views Order By UpdatedAt

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.

Delete

You must specify the Id of the view to delete it. Allowed for agents.

DELETE FROM Views WHERE Id='123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		Automatically assigned when the ticket is created.
Title	String	False		The title of the view.
Active	Boolean	False		Useful for determining if the view should be displayed.
SlaId	Long	False	SlaPolicies.Id	If the view is for an SLA, shows the id.
RestrictionId	Long	False		The id of the restricion (who may access this account. Will be null when everyone in the account can access it).
RestrictionType	String	False		The type of the restricion (who may access this account. Will be null when everyone in the account can access it).
RestrictionIds	String	False		The numeric IDs of a single or more groups. Recommended for 'Group' type.
Position	Integer	False		The position of the view.
ExecutionGroupBy	String	False		Execution is an object describing how the view should be executed.
ExecutionGroupOrder	String	False		Execution is an object describing how the view should be executed.
ExecutionSortBy	String	False		Execution is an object describing how the view should be executed.
ExecutionSortOrder	String	False		Execution is an object describing how the view should be executed.
ExecutionGroup	String	False		Execution is an object describing how the view should be executed.
ExecutionSort	String	False		Execution is an object describing how the view should be executed.
ExecutionColumns	String	False		Execution is an object describing how the view should be executed.
ExecutionFields	String	False		Execution is an object describing how the view should be executed.
ExecutionCustomFields	String	False		Execution is an object describing how the view should be executed.
ConditionsAll	String	False		Logical AND. Tickets must fulfill all of the conditions to be considered matching.Conditions is an object describing how the view is constructed.
ConditionsAny	String	False		Logical OR. Tickets may satisfy any of the conditions to be considered matching.Conditions is an object describing how the view is constructed.
CreatedAt	Datetime	False		The time the view was created.
UpdatedAt	Datetime	False		The time of the last update of the view.
Access	String	False		Only views with given access. May be personal, shared, or account
GroupId	Long	False	Groups.Id	The group id the view belongs to. Used to query the table

JDBC Driver for Zendesk

Views

Table Specific Information

Select

Delete

Columns