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 |