Tasks
The information about an action or an activity scheduled to be completed within a specified time.
Table-Specific Information
SELECT
The adapter will use the 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 adapter.
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. |