Retrieve the Comments feed.
Table Specific Information
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 provider will use the Salesforce Chatter API to filter the results. The = operator is allowed.
Other filters are processed client side within the provider. 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.
|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 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.
|FeedType||String||Specifies the feed type. The default value is Groups. Valid values are Groups, News, User, or Company.|