TasksNotes
The note text associated with the objects such as contacts and organizations.
Table-Specific Information
SELECT
The component 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 component.
SELECT * FROM TasksNotes WHERE id = 12 SELECT * FROM TasksNotes WHERE id > 15 SELECT * FROM TasksNotes WHERE text LIKE '%test' SELECT * FROM TasksNotes WHERE id IN (12, 23, 123) SELECT * FROM TasksNotes WHERE text IS NOT NULL
DELETE
Delete can be executed by specifying the tasksId in the WHERE Clause.
For example:
DELETE FROM TasksNotes WHERE tasksId = '1'
Columns
| Name | Type | Description |
| TasksId | Long | Id of Tasks. |
| ChannelId | Long | Id of channel. The channel through which the note was created. |
| ChannellookUpName | String | LookUpName of channel. The channel through which the note was created. |
| CreatedByAccountId | Long | Id of createdByAccount. The staff member account that created the note. |
| CreatedByAccountlookUpName | String | LookUpName of createdByAccount. The staff member account that created the note. |
| CreatedTime | Datetime | The date and time when the note was created. This attribute is read-only. |
| Id [KEY] | Long | The unique identifier of the note. |
| Text | String | The text content in the note. |
| UpdatedByAccountId | Long | Id of updatedByAccount. The staff member account that updated the note. |
| UpdatedByAccountlookUpName | String | LookUpName of updatedByAccount. The staff member account that updated the note. |
| UpdatedTime | Datetime | The date and time when the note was last updated. This attribute is read-only. |