JDBC Driver for Act! CRM

Build 21.0.8137


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  ;


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

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137