Returns counts of tickets, subscriptions, and other items associated with a user.

View-Specific Information

Select

The following query is processed server-side while other filters are processed client-side within the provider:

SELECT * FROM UserRelatedInformation WHERE UserId = '123'

Columns

Name	Type	References	Description
UserId	Long	Users.id	The Id of the user.
AssignedTickets	Integer		The number of tickets assigned to the user.
RequestedTickets	Integer		The number of tickets requested by the user.
CcdTickets	Integer		The number of tickets on which the user is CC'd.
OrganizationSubscriptions	Integer		The number of organization subscriptions.
Topics	Integer		The number of topics (Web portal only).
TopicComments	Integer		The number of topic comments (Web portal only).
Votes	Integer		The number of votes (Web portal only).
Subscriptions	Integer		The number of subscriptions (Web portal only).
EntrySubscriptions	Integer		The number of entry subscriptions (Web portal only).
ForumSubscriptions	Integer		The number of forum subscriptions (Web portal only).