Query UserRelatedInformation in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the adapter.

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).