[SalesForce] block Chatter Free users from seeing specific posts

We want to bring additional users into our Chatter with Chatter Free licenses, but realized that some sensitive posts have been made outside of bespoke private groups. This is causing a problem since we don't want the new users to see those posts. I can't solve this with Visualforce and Chatter does not support blocking users.

Short of deleting dozens of posts, are there any ways around this? Can posts and their comments be moved into private groups after the fact?

Update

A quick test in the Developer Console shows that you cannot UPDATE FeedItem so these posts cannot be re-parented.

Best Answer

There is no way to restrict visibility of individual posts bar putting them in private groups or a community.

You can "move" the posts to the new private group by recreating them and deleting the public messages. There is a profile permission that can be granted to users called "Insert System Field Values for Chatter Feeds". This will allow you to re-create the post, comments and likes and set the CreatedById and CreatedDate for those records, so they will appear as having been posted by the user at the original time. The objects you need are FeedItem, FeedComment and FeedLike

You could either do this by writing apex code, or via the api / dataloader.

You will not be able to migrate chatter polls until winter 14 goes live.

Related Solutions

[SalesForce] Query Chatter Feed, Topics, and Groups

Trusty old ChildRelationship to the rescue:

for (ChildRelationship relation : SObjectType.Topic.getChildRelationships())
    system.debug(relation);

Relevant relationships and properties:

[getChildSObject=FeedComment;getField=ParentId;getRelationshipName=null;]
[getChildSObject=FeedItem;getField=ParentId;getRelationshipName=null;]

You should just be able to do:

SELECT Body, BestCommentId, CommentCount, LikeCount, Type,
    (SELECT CommentBody FROM FeedComments)
FROM FeedItem WHERE ParentId = '<topic_id_here>'

If you want to filter on multiple Topic parents, you could change your WHERE clause to:

ParentId IN ('<topic1_id>', '<topic2_id>', 'etc.')

You can also do a Left Inner Join to see which records have a relevant TopicAssignment:

SELECT ... FROM FeedItem WHERE Id IN (
    SELECT EntityId FROM TopicAssignment
    WHERE EntityType = 'FeedItem'
    AND TopicId IN ('<id1>', 'etc.')
)

Best Answer

Related Solutions

[SalesForce] Query Chatter Feed, Topics, and Groups

Related Topic