Create, update, delete, and query information regarding notes.

Table-Specific Information

Select

This table supports COQL for filtering, meaning that most filters comparing columns to values are submitted server-side.

SELECT * FROM Notes WHERE Id = '3152079000000153079'

Insert

INSERT INTO Notes(ParentID_Id, ModuleName, NoteContent) VALUES('3276571000000184007', 'Leads', 'Janet converted this lead.') 

Required fields:

• ParentID_Id (the Id of the item in which you are inserting the note to)
• ModuleName (the API name of the module you are inserting the note to)
• NoteContent

You can insert any field which is not read-only (ReadOnly = false in the table below).

Delete

Specify the Id in the WHERE clause when executing a delete in this table.

DELETE FROM Notes WHERE Id = '3152079000000488014'

Update

Specify the Id in the WHERE clause when executing an update in this table.

UPDATE Notes SET NoteTitle = 'Changed from the API.' WHERE Id = '3152079000000304003'

Required fields: Id.

You can update any field which is not read-only (ReadOnly = false in the table below).

Columns

Pseudo-Columns

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