JDBC Driver for Salesforce Chatter

Build 21.0.7930

Comments

Retrieve the Comments feed.

Table Specific Information

Select

By default, queries to this table return Comments from all Groups the context user either owns or is a member of. When FeedType or Id are specified, the driver will use the Salesforce Chatter API to filter the results. The = operator is allowed.

Other filters are processed client side within the driver. For example, the following queries are processed server side.

  • Return a list of Groups Comments:

    SELECT * FROM Comments

  • Return a list of Comments matching the FeedType:

    SELECT * FROM Comments WHERE FeedType = 'Company'

  • Retrieve a Comment by specifying its Id:

    SELECT * FROM Comments WHERE Id = '0D740000005cQ8MCAU'

You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria on other columns will cause an error.

Columns

Name Type Description
Id [KEY] String 18-character ID of the comment.
Text String Message text for the comment.
AttachmentAggregate String If the comment does not contain an attachment returns null.
ApplicationName String Name of the connected app used for authentication.
ApplicationUrl String Value from the Info URL field of the connected app used for authentication.
CreatedDate Datetime ISO8601 date string, for example, 2011-02-25T18:24:31.000Z.
UserId String The ID of the user that commented.
UserDisplayName String The name of the user that commented.
UserPhoto String The photo of the user that commented.
UserTitle String The title of the user that commented.
FeedElementId String The ID of the record being referenced, which could be an 18-character ID or some other string identifier.
FeedElementUrl String The URL to the resource endpoint.
IsDeleteRestricted Boolean Returns true if a comment cannot be deleted by the context user. If it returns false, possibly the context user can delete the comment.
LikesUrl String URL to the current page of likes.
LikeItemsAggregate String Collection of likes.
TotalLikes Integer Total number of likes for the item.
LikesMessageAggregate String A message body that describes who likes the comment.
MyLikeId String The ID of the record being referenced, which could be an 18-character ID or some other string identifier.
MyLikeUrl String The URL to the resource endpoint.
ParentId String The ID of the record being referenced, which could be an 18-character ID or some other string identifier.
ParentUrl String The URL to the resource endpoint.
Type String Indicates the type of comment. Valid values are ContentComment or TextComment.
Url String URL to this comment.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
FeedType String Specifies the feed type. The default value is Groups. Valid values are Groups, News, User, or Company.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930