OpportunityNotes
Query the Notes for a given Act! CRM Opportunity.
Table Specific Information
Select
- OpportunityId supports the '=' operator.
- ManageUserID supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- CreateUserID supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- IsPrivate supports the '=' operator.
- NoteText supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- DisplayDate supports the '<=,<,=,!=,>,>=' operator.
- AttachmentDisplayName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- AttachmentFileName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
- AttachmentLastModified supports the '<=,<,=,!=,>,>=' operator.
- AttachmentPersonal supports the '=' operator.
SELECT * FROM OpportunityNotes WHERE OpportunityId = '12345'
Columns
Name | Type | Description |
Id [KEY] | String | The unique identifier (id) for a given note. |
OpportunityId [KEY] | String | The unique identifier (id) for the opportunity included in the note. |
ManageUserID | String | The unique identifier (id) of the user managing the note. |
CreateUserID | String | The unique identifier (id) of the user who created the note. |
IsPrivate | Boolean | Indicator if the note is private. |
NoteText | String | Descriptive text of the note. |
NoteTypeID | Long | The id of the type of the note. |
DisplayDate | Datetime | Display date of the note. |
Created | Datetime | Datetime of the note creation. |
Edited | Datetime | Datetime of the last edit of the note. |
AttachmentDisplayName | String | Display name of the attachment. |
AttachmentFileExtension | String | File extension of the attachment. |
AttachmentFileName | String | File name of the attachment. |
AttachmentFileSize | Long | File size of the attachment. |
AttachmentFileSizeDisplay | String | Display file size of the attachment. |
AttachmentFileType | String | Type of the attachment file. |
AttachmentLastModified | Datetime | Last modified datetime of the attachment. |
AttachmentPersonal | Boolean | Indicator if the attachment is personal. |