Query UserRelatedInformation in Zendesk.
Table Specific Information
SelectThe 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.
|UserId||Long||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).|