JDBC Driver for Zendesk

Build 22.0.8462

UserRelatedInformation

Query UserRelatedInformation in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the driver.
SELECT * FROM UserRelatedInformation

SELECT * FROM UserRelatedInformation WHERE UserId = '123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name Type References Description
UserId Long

Users.id

The id of the user.
AssignedTickets Integer Count of assigned tickets.
RequestedTickets Integer Count of requested tickets.
CcdTickets Integer Count of collaborated tickets.
OrganizationSubscriptions Integer Count of organization subscriptions.
Topics Integer Count of topics (Web portal only).
TopicComments Integer Count of comments on topics (Web portal only).
Votes Integer Count of votes (Web portal only).
Subscriptions Integer Count of subscriptions (Web portal only).
EntrySubscriptions Integer Count of entry subscriptions (Web portal only).
ForumSubscriptions Integer Count of forum subscriptions (Web portal only).

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462