ClearActivity
Clears an activity.
Stored Procedures Specific Information
Process of clearing an activity
Act! CRM allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only = comparision. The available columns for ClearActivity are ActivityId and other activity information. For example:
EXEC ClearActivity ActivityId = '123456', IsPrivate = true
Input
Name | Type | Description |
ActivityId | String | The unique identifier (id) for a given activity |
HistoryTypeId | String | The unique identifier of the history type |
HistoryTypeName | String | The name of the history type |
HistoryTypeDescription | String | The description of the history type |
StartTime | Datetime | The time the activity is to begin |
EndTime | Datetime | The time the activity is to end |
IncludeDetailsToHistory | Boolean | Indicates whether the details will be included to activity history |
Details | String | Additional detailed information about the activity |
Subject | String | A description of the action to be completed |
IsPrivate | Boolean | Indicates elevated security that only the creator/owner has access to this activity |
AttachmentDisplayName | String | The presentation name of the attachment |
AttachmentFileExtension | String | The extension of the attachment |
AttachmentFileName | String | The directory's full path |
AttachmentFileSize | Integer | The size (bytes) of the attachment |
AttachmentFileSizeDisplay | String | The displayable text representation of the attachment |
AttachmentFileType | String | The system file type name of the attachment |
AttachmentPersonal | Boolean | Indicates whether the attachment is bound for the personal supplemental files or the workgroup supplemental files |
Result Set Columns
Name | Type | Description |
Status | String | Stored Procedure Execution Status |