Skip to main content
Hi all! I have a request from one of our business owners to run a report to see all files that exist in Chatter. After doing some research it looks like I'd need to look at the ContentDocument object, but I'm only pulling back Documents, not necessarily Chatter files. What object (or objects) do I need to look at for Chatter files? Thanks in advance!
11 commenti
  1. 15 gen 2015, 18:44
    Hi @Rebecca Glasser

    The ContentVersion object will help you figure out if a File is a Chatter file or a file in Content/Libraries. Here is a link to the documentation:

    https://www.salesforce.com/developer/docs/api/Content/sforce_api_objects_contentversion.htm

    Look up the 'Origin' field. Here is the description:

    The source of the content version. Valid values are:

    C—This is a Content document from the user's personal library. Label is Content. The FirstPublishLocationId must be the user's ID. If FirstPublishLocationId is left blank, it defaults to the user's ID.

    H—This is a Chatter file from the user's My Files. Label is Chatter. The FirstPublishLocationId must be the user's ID. If FirstPublishLocationId is left blank, it defaults to the user's ID. Origin can only be set to H if Chatter is enabled for your organization.

    This field defaults to C. Label is Content Origin.

    Each ContentVersion is part of a ContentDocument: the ContentDocumentId on the ContentVersion object will expose this relationship.

0/9000