Vote
Stores votes cast on Chatter posts and comments, allowing users to indicate approval or agreement.
Table Specific Information
Select
The Salesforce connector requires filtering on ParentId, Type, or Id in order to perform the query.
For example:
SELECT * FROM Vote WHERE ParentId = 'your_value' SELECT * FROM Vote WHERE Type = 'your_value' SELECT * FROM Vote WHERE Id = 'your_value'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier for the vote record. | |
| IsDeleted | Bool | True |
Indicates whether the vote has been deleted from the system. | |
| ParentId | String | False |
Identifier of the record that the vote is associated with, such as an Idea or FeedItem. | |
| ParentIdType | String | False |
Specifies the type of the 'ParentId' polymorphic field to use in the statement. | |
| ParentIdExternalFieldName | String | False |
Specifies the external field name of the 'ParentId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| Type | String | False |
Specifies the type of vote, such as Up or Down. | |
| CreatedDate | Datetime | True |
Date and time when the vote was created. | |
| CreatedById | String | True |
User.Id |
Identifier of the user who cast the vote. |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the record. |
| SOQL | String | False |
Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. | |
| ExternalIdColumn | String | False |
Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. | |
| FilterScope | String | False |
Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. | |
| SystemModstamp | Datetime | True |
System-generated timestamp indicating the most recent change to the vote record. | |
| LastModifiedDate | Datetime | True |
Date and time when the record was last modified. |