JDBC Driver for Oracle Service Cloud

Build 22.0.8462

TasksNotes

The note text associated with the objects such as contacts and organizations.

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

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