ODBC Driver for Salesforce

Build 26.0.9770

ActionableList

Represents a curated, filterable list of records surfaced to users for follow-up action.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the record.

OwnerId String False

ID of the user or queue that currently owns the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin (true) or not (false).

Name String False

Name of the record.

CurrencyIsoCode String False

ISO code for the currency in which the record's currency fields are expressed.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

LastViewedDate Datetime True

Date and time when the record was last viewed by a user.

LastReferencedDate Datetime True

Date and time when the record was last referenced, such as through a lookup.

ObjectName String False

API name of the object associated with this record.

Description String False

Description of the record.

Status String True

Current status of the record.

ActionableListDefinitionId String False

ActionableListDefinition.Id

ID of the actionable list definition that this actionable list is based on.

ActionableListType String True

Type classification of the actionable list.

Priority String False

Priority level assigned to the actionable list.

OmniScriptKey String False

Key identifying the OmniScript associated with the actionable list.

ListStatus String False

Current status of the actionable list.

AssigneeType String False

Type of the assignee, such as a user or queue, for the actionable list.

AssignmentStatus String True

Current assignment status of the actionable list.

MemberSortOrder String False

Sort order applied to members of the actionable list.

AssigneeId String False

ID of the user or group assigned to the actionable list.

DefaultSortMemberField String False

Field used by default to sort members of the actionable list.

CompletionDate Datetime False

Date and time when the actionable list was completed.

DefaultMemberStatusId String False

ActionableListMemberStatus.Id

ID of the default status assigned to new members of the actionable list.

MemberCount Int True

Number of members included in the actionable list.

MemberCountLastModDtTime Datetime True

Date and time when the member count was last recalculated.

IsAutoAssignmentAllowed Bool True

Indicates whether automatic assignment of members is allowed for the actionable list.

SourceType String True

Type of source used to populate the actionable list.

IsActionableListConfigured Bool True

Indicates whether the actionable list has been fully configured.

AutomaticAssigneeId String False

ID of the user or group automatically assigned to new members of the actionable list.

AutomaticAssigneeType String False

Type of the automatic assignee for the actionable list.

LastMemberAddDateTime String True

Date and time when a member was last added to the actionable list.

SynchronizationOperationType String False

Type of synchronization operation last performed on the actionable list.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

Pseudocolumns

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
OwnerIdType String

Specifies the type of the 'OwnerId' polymorphic field to use in the statement.

OwnerIdExternalFieldName String

Specifies the external field name of the 'OwnerId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

AssigneeIdType String

Specifies the type of the 'AssigneeId' polymorphic field to use in the statement.

AssigneeIdExternalFieldName String

Specifies the external field name of the 'AssigneeId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

AutomaticAssigneeIdType String

Specifies the type of the 'AutomaticAssigneeId' polymorphic field to use in the statement.

AutomaticAssigneeIdExternalFieldName String

Specifies the external field name of the 'AutomaticAssigneeId' 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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770