ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData JDBC Driver for Zendesk ビュー
Name | Description |
AccessLogs | Query access logs in Zendesk. |
ActivityStream | Query ActivityStreams in Zendesk. |
AppLocations | Query AppLocations in Zendesk. |
Apps | Query Apps in Zendesk. |
Attachments | Show ticket attachments in Zendesk. |
AuditLogs | Query audit logs in Zendesk. |
Calls | A complete list of information on inbound and outbound calls from your Zendesk Talk instance |
Collaborators | Query Collaborators in Zendesk. |
CustomObjectField | The view specifies all the attributes of a custom object property. |
JobStatus | A status record is created when somebody kicks off a job such as updating multiple tickets. You can access the job status data for an hour after a particular job is created, after which the data is no longer available. |
Locales | Query Locales in Zendesk. |
MonitoredTwitterHandles | Query Monitored Twitter handles in Zendesk. |
OrganizationFieldsRelationshipFilterAll | Query OrganizationFields RelationshipFilterAll Filter with Logical AND. |
OrganizationFieldsRelationshipFilterAny | Query OrganizationFields RelationshipFilterAny Filter with Logical OR. |
Requests | Query Requests in Zendesk. |
Requests_Collaborators | The Collaborator ids of users currently CC'ed on the ticket. |
ResourceCollections | Query Resource Collections in Zendesk. |
SatisfactionReasons | Query the Satisfaction Reasons in Zendesk. |
SideConversationEvents | Query Side Conversations events in Zendesk. The messages that make up a side conversation are recorded as events. |
SideConversationEventsMessage | Query Side Conversations events message in Zendesk. |
SideConversationEventsMessageTo | Query the list of participants, the message was sent to. |
SideConversationParticipants | Query Side Conversation Participants in Zendesk. |
SlaPoliciesFilterAll | Query SlaPolicies Filter with Logical AND. |
SlaPoliciesFilterAny | Query SlaPolicies Filter with Logical OR. |
SlaPoliciesMetrics | Query SlaPoliciesMetrics that describes the metric targets for each value of the priority field. |
TargetFailures | Query Target failures in Zendesk. |
TicketEmailCCs | Query any users cc'd on the ticket in Zendesk. |
TicketFieldsRelationshipFilterAll | Query TicketFields RelationshipFilterAll Filter with Logical AND. |
TicketFieldsRelationshipFilterAny | Query TicketFields RelationshipFilterAny Filter with Logical OR. |
TicketRelatedInformation | Query Ticket related information in Zendesk. |
UserEvents | Query events for a given Zendesk user. |
UserFieldsRelationshipFilterAll | Query UserFields RelationshipFilterAll Filter with Logical AND. |
UserFieldsRelationshipFilterAny | Query UserFields RelationshipFilterAny Filter with Logical OR. |
UserRelatedInformation | Query UserRelatedInformation in Zendesk. |
UserSubscriptions | Query the user subscriptions in Zendesk. |
ViewsConditionsAll | Query Views Conditions with Logical AND. |
ViewsConditionsAny | Query Views Conditions with Logical OR. |