UserProfileFeed

Represents a user profile feed, which tracks all actions by a user on records that can be tracked in a feed. This feed is displayed on the user profile page. A user can subscribe to a record so that changes to the record are displayed in the Chatter feed on the user's home page, which is a useful way to stay up-to-date with changes made to records in Salesforce. Feeds are available in API version 18.0 and later.

Supported Calls

delete(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve()

Fields

Field	Details
Body	Type textarea Properties Create, Filter, Nillable, Sort Description The content of the FeedItem. Required when Type is `TextPost`. Optional when Type is `ContentPost` or `LinkPost`. This is the message that appears in the feed.
CommentCount	Type int Properties Filter, Group, Sort Description The number of FeedComments associated with this feed item.
ContentData	Type base64 Properties Create, Nillable Description The file uploaded to the feed. Required if Type is `ContentPost`. Encoded file data. Cannot be 0 bytes. Can be any format. Setting this field automatically sets Type to `ContentPost`.
ContentDescription	Type textarea Properties Create, Nillable, Sort Description The description of the file specified in ContentData.
ContentFileName	Type string Properties Create, Group, Nillable, Sort Description The file uploaded to the feed. Required if Type is `ContentPost`. The name of the file uploaded to the feed. Setting ContentFileName automatically sets Type to `ContentPost`.
ContentSize	Type int Properties Group, Nillable, Sort Description Read only. Automatically determined during insert. The size of the file (in bytes) uploaded to the feed.
ContentType	Type string Properties Group, Nillable, Sort Description Read only. Automatically determined during insert. The MIME type of the file uploaded to the feed.
CreatedDate	Type dateTime Properties Defaulted on create, Filter, Sort Description Date and time when this record was created. This is a standard system field. Ordering by `CreatedDate DESC` sorts the feed by the most recent feed item.
FeedPostId	Type reference Properties Filter, Group, Nillable, Sort Description This field was removed in API version 22.0, and is available in earlier versions for backward compatibility only. ID of the associated FeedPost. A FeedPost represents the following types of changes in an FeedItem: status updates, changes to tracked fields, text posts, link posts, and content posts.
InsertedById	Type reference Properties Filter, Group, Nillable, Sort Description ID of the user who added this object to the feed. For example, if a client application migrates multiple posts and comments from another application into a feed, then InsertedById is set to the ID of the logged-in user.
IsDeleted	Type boolean Properties Defaulted on create, Filter, Group, Sort Description Indicates whether the record has been moved to the Recycle Bin (`true`) or not (`false`). This is a standard system field.
LastModifiedDate	Type dateTime Properties Defaulted on create, Filter, Sort Description Date and time when this record was last modified by a user. This is a standard system field. When a feed item is created, LastModifiedDate is the same as CreatedDate. If a FeedComment is inserted on that feed item, then LastModifiedDate becomes the CreatedDate for that FeedComment. Deleting the FeedComment does not change the LastModifiedDate. Ordering by `LastModifiedDate DESC` sorts the feed by both the most recent feed item or comment.
LikeCount	Type int Properties Filter, Group, Sort Description The number of FeedLikes associated with this feed item.
LinkUrl	Type url Properties Create, Filter, Nillable, Sort Description The URL of a `LinkPost`.
ParentId	Type reference Properties Filter, Group, Sort Description ID of the user profile that is tracked in the feed. The feed is displayed on the detail page for this record.
RelatedRecordId	Type reference Properties Create, Group, Nillable, Sort Description ID of the ContentVersion object associated with a `ContentPost`. This field is null for all posts except `ContentPost`. For example, set this field to an existing ContentVersion and post it to a feed as a FeedItem object of Type`ContentPost`.
Title	Type string Properties Create, Filter, Group, Nillable, Sort Description The title of the FeedItem. When the Type is `LinkPost`, the LinkUrl is the URL and this field is the link name.
Type	Type picklist Properties Create, Filter, Group Description The type of FeedItem: `UserStatus`—automatically generated when a user updates their status `TrackedChange`—a change or group of changes to a tracked field `TextPost`—a direct text entry on a feed `LinkPost`—a URL posting on a feed `ContentPost`—an uploaded file on a feed `DashboardComponentSnapshot`—a posting of a dashboard snapshot on a feed. `ApprovalPost`—automatically generated by a feed query on an approval item. The following values appear in the Type picklist for all feed objects but apply only to CaseFeed: `CaseCommentPost`—generated event when a user adds a case comment for a case object. `EmailMessageEvent`—generated event when an email related to a case object is sent or received. `CallLogPost`—generated event when a user logs a call for a case through the user interface. This event is also generated by CTI calls. `ChangeStatusPost`—generated event when a user changes the status of a case. `AttachArticleEvent`—generated event when a user attaches an article to a case. `ActivityEvent`—generated event when a user adds or updates an Event or a Task. Note If you set Type to `ContentPost`, you must specify ContentData and ContentFileName.

Usage

Use this object to query and retrieve record changes tracked in a user profile feed. Note the following when working with user profile feeds:

This object is read only in the API.
Queries retrieve feed items that include mentions from other users. A mention is the @ symbol followed by a person’s name, for example, @Bob Smith. You can mention people in Chatter posts and comments. When you mention someone, the mention links to their profile, the post or comment displays in their feed, and they are emailed a notification.
You must include a WITH clause and specify the UserId of the user whose profile you want to query. The WITH clause must come after a WHERE clause.

Users that do not have the “View All Data” permission have the following limitations when querying records:

Must specify a LIMIT clause and the limit must be less than or equal to 1000.
May include a WHERE clause that references UserProfileFeed fields, but may not include references to fields in related objects. For example, you can filter by CreatedDate or ParentId, but not by Parent.Name.
May include an ORDER BY clause that references UserProfileFeed fields, but may not include references to fields in related objects. For example, you can ORDER BYCreatedDate or ParentId, but not by Parent.Name.

Tip

To query for the most recent feed items, you should ORDER BY CreatedDate DESC, Id DESC.

You can’t query FeedTrackedChange and FeedComment records that are a child of a UserProfileFeed record directly. They can only be queried via the UserProfileFeed. For example, the following query returns information, including child FeedTrackedChange records:

SELECT ID, CreatedDate, CreatedById, CreatedBy.FirstName, CreatedBy.LastName, ParentId, Parent.Name,
        (SELECT ID, FieldName, OldValue, NewValue FROM FeedTrackedChanges ORDER BY ID DESC)
      FROM UserProfileFeed
      WITH UserId = '005D0000001AamR'
      ORDER BY CreatedDate DESC, Id DESC
      LIMIT 20

Note the following SOQL restrictions.

No SOQL limit if logged-in user has “View All Data” permission. If not, specify a LIMIT clause of 1,000 records or fewer.
SOQL ORDER BY on fields using relationships is not available. Use ORDER BY on fields on the root object in the SOQL query.