Tasks

The information about an action or an activity scheduled to be completed within a specified time.

Table-Specific Information

SELECT

The 本製品 will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the 本製品.

SELECT * FROM Tasks WHERE id = 12
SELECT * FROM Tasks WHERE id > 15
SELECT * FROM Tasks WHERE lookUpName LIKE '%test'
SELECT * FROM Tasks WHERE id IN (12, 23, 123)
SELECT * FROM Tasks WHERE lookUpName IS NOT NULL

INSERT

Insert can be executed by specifying the name column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Tasks (name) VALUES ('Organize PO for Initech')

UPDATE

Update can be executed. The columns that are not read-only can be Updated.

UPDATE Tasks SET percentComplete = '60' WHERE name = 'Organize PO for Initech'

DELETE

Delete can be executed by specifying id in the WHERE Clause. For example:

DELETE FROM Tasks WHERE id = '7'

Columns


Name	Type	ReadOnly	Description
AssignedToAccountId	Long	False	Id of assignedToAccount. The assigned staff account.
AssignedToAccountlookUpName	String	False	LookUpName of assignedToAccount. The assigned staff account.
CompletedTime	Datetime	False	The date and time when the task was completed.
ContactId	Long	False	Id of contact. The associated contact.
ContactlookUpName	String	False	LookUpName of contact. The associated contact.
CreatedTime	Datetime	True	The date and time when the task was created. This attribute is read-only.
DueTime	Datetime	False	The date and time when the task is due.
Id [KEY]	Long	True	The unique identifier of the task.
LookupName	String	True	The name used to look up the task.
Name	String	False	The name used to describe the task.
OrganizationId	Long	False	Id of organization. The associated organization.
OrganizationlookUpName	String	False	LookUpName of organization. The associated organization.
PercentComplete	Int	False	The percentage of work completed.
PlannedCompletionTime	Datetime	False	The date and time when the task is planned for completion.
PriorityId	Long	False	Id of priority. The relative priority.
PrioritylookUpName	String	False	LookUpName of priority. The relative priority.
StartTime	Datetime	False	The date and time when the task started.
TaskTemplateId	Long	False	Id of taskTemplate. The template for the business process.
TaskTemplatelookUpName	String	False	LookUpName of taskTemplate. The template for the business process.
TaskTypeId	Long	False	Id of taskType. The identifier of the task type, such as incident task. This works in conjunction with the inherit options to determine which associated object to inherit the data from.
TaskTypelookUpName	String	False	LookUpName of taskType. The identifier of the task type, such as incident task. This works in conjunction with the inherit options to determine which associated object to inherit the data from.
UpdatedTime	Datetime	True	The date and time when the task was last updated. This attribute is read-only.
InheritinheritContact	Bool	False	Indicates whether the task inherits contact value from the associated object. The default value is false.
InheritinheritOrganization	Bool	False	Indicates whether the task inherits organization value from the associated object. The default value is false.
InheritinheritStaffAssignment	Bool	False	Indicates whether the task inherits account value from the associated object. The default value is false.
MarketingSettingscampaignId	Long	False	Id of campaign. The associated campaign.
MarketingSettingscampaignlookUpName	String	False	LookUpName of campaign. The associated campaign.
MarketingSettingsdocumentId	Long	False	Id of document. The associated marketing document.
MarketingSettingsdocumentlookUpName	String	False	LookUpName of document. The associated marketing document.
MarketingSettingsmailingId	Long	False	Id of mailing. The associated mailing.
MarketingSettingsmailinglookUpName	String	False	LookUpName of mailing. The associated mailing.
MarketingSettingssurveyId	Long	False	Id of survey. The associated survey.
MarketingSettingssurveylookUpName	String	False	LookUpName of survey. The associated survey.
SalesSettingsopportunityId	Long	False	Id of opportunity. The associated opportunity.
SalesSettingsopportunitylookUpName	String	False	LookUpName of opportunity. The associated opportunity.
ServiceSettingsanswerId	Long	False	Id of answer. The associated answer.
ServiceSettingsanswerlookUpName	String	False	LookUpName of answer. The associated answer.
ServiceSettingsincidentId	Long	False	Id of incident. The associated incident.
ServiceSettingsincidentlookUpName	String	False	LookUpName of incident. The associated incident.
StatusWithTypestatusId	Long	False	Id of status. The current status.
StatusWithTypestatuslookUpName	String	False	LookUpName of status. The current status.
StatusWithTypestatusTypeId	Long	True	Id of statusType. The associated status type. This attribute is read-only.
StatusWithTypestatusTypelookUpName	String	True	LookUpName of statusType. The associated status type. This attribute is read-only.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
fileAttachments	String	The list of file attachments.
notes	String	The list of discussion threads.

ODBC Driver for Oracle Service Cloud