Vote

Stores votes cast on Chatter posts and comments, allowing users to indicate approval or agreement.

Table Specific Information

The Salesforce provider 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'


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.
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.
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.

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
ParentIdType	String	Specifies the type of the 'ParentId' polymorphic field to use in the statement.
ParentIdExternalFieldName	String	Specifies the external field name of the 'ParentId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement
SOQL	String	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	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	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.