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 adapter will use the Salesforce Chatter API to filter the results. The = operator is allowed.
Other filters are processed client side within the adapter. 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'
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. |