JDBC Driver for Oracle Service Cloud

Build 22.0.8462

Tasks

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

Table-Specific Information

SELECT

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

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

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

The list of file attachments.

notes String

The list of discussion threads.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462