Follow

Valid values for Activity.Type and Activity.SubType

Overview

This article provides a list of each of the valid values for both the Activity.Type and Activity.SubType columns in the Pulse database. Many customers have asked for this information when they create their own custom reports. Here are the values

Activity.Type

The following lists the valid values for the Type column the Activity table

  • Message = 1
  • Comment = 2
  • Like = 3
  • Vote = 4
  • Question = 5
  • Answer = 6
  • AccountRelatedActivity = 7 
  • PageRelatedActivity = 8 
  • ListRelatedActivity = 9 
  • BadgeRelatedActivity = 10
  • Task = 11
  • Custom = 12
  • History = 13
  • Share = 14

Activity.SubType

The SubType column is used only when the Type column is either AccountRelatedActivity(7), PageRelatedActivity(8), ListRelatedActivity(9), BadgeRelatedActivity(10) and History(13).

 

When Type is AccountRelatedActivity(7), PageRelatedActivity(8), ListRelatedActivity(9), or BadgeRelatedActivity(10) the following are valid SubType values

  • Followed = 0
  • Unfollowed = 1
  • Created = 2

 

When Type is History(13) the following are value SubType values

  • TaskAssignedNotification = 16
  • TaskAcceptedNotification = 17
  • TaskDeclinedNotification = 18
  • TaskCompletedNotification = 19
  • TaskFieldChangedNotification = 21
  • TaskCreatedNotification = 22
  • TaskUnassignedNotification = 25
  • TaskReopenedNotification = 26

 

The complete list of possible SubType values is as follow but the items above are the expected values.

  • Unknown = 0
  • GainedFollower = 1
  • LostFollower = 2
  • CommentNotification = 3
  • LikeNotification = 4
  • SubscribeNotification = 5
  • TextPostNotification = 6
  • LinkPostNotification = 7
  • MentionNotification = 8
  • CommentMentionNotification = 9
  • AnswerNotification = 10
  • AnswerMentionNotification = 11
  • AskToAnswerNotification = 12
  • PageInviteNotification = 13
  • FilePostNotification = 14
  • ArticlePostNotification = 15
  • TaskAssignedNotification = 16
  • TaskAcceptedNotification = 17
  • TaskDeclinedNotification = 18
  • TaskCompletedNotification = 19
  • FeedSubscriptionNotification = 20
  • TaskFieldChangedNotification = 21
  • TaskCreatedNotification = 22
  • AccountInviteNotification = 23
  • ListInviteNotification = 24
  • TaskUnassignedNotification = 25
  • TaskReopenedNotification = 26
  • TaskReminderNotification = 27
  • TaskPostNotification = 28
  • ImagePostNotification = 29
  • QuestionNotification = 30
  • VideoPostNotification = 31
  • FileUpdatedNotification = 32
  • ShareNotification = 33
  • PageAccessRequestNotification = 34

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk