Get all the history related to an activity.

View Specific Information

Select

• ActivityId supports the '=' operator.

The driver uses the Act! CRM API to process search criteria that refer to the supported fields. The driver processes other filters client-side within the driver. For example, the following queries are processed server side:

SELECT * FROM ActivityHistories
SELECT * FROM ActivityHistories WHERE ActivityId = '12345'

Columns

Name	Type	Description
Id [KEY]	String	Id of the history item created
ActivityId [KEY]	String	Id of the activity
AttachmentDisplayName	String	Name of the attachment related to a history
AttachmentFileExtension	String	FileExtension of the attachment related to a history
AttachmentFileName	String	FileName of the attachment related to a history
AttachmentFileSize	Integer	File Size of the attachment related to a history
AttachmentFileSizeDisplay	String	File Size Display of the attachment related to a history
AttachmentFileType	String	FileType of the attachment related to a history
AttachmentLastModified	Datetime	File Last Modified date of the attachment related to a history
AttachmentPersonal	Boolean	Attachment Personal
CompaniesAggregate	String	Companies associated with a history
ContactsAggregate	String	Contacts associated with a history
Created	Datetime	The datetime when history was created
CreateUserID	String	User Id of the user who created the history
Details	String	Details of history
Duration	String	Duration
Edited	Datetime	Datetime when history was last edited
EndTime	Datetime	End Time of history
GroupsAggregate	String	Groups associated with history
HistoryTypeDescription	String	Description of the type of history
HistoryTypeId	Integer	History Type ID
HistoryTypeName	String	Name of history type
IsPrivate	Boolean	Indicates whether history is private or not
ManageUserID	String	User Id of manager
OpportunitiesAggregate	String	Opportunities associated with history
OutlookID	String	Outlook Id
RecordManager	String	Record Manager
RecordManagerID	String	Id of Record Manager
Regarding	String	Tells what history is about
StartTime	Datetime	Start Time
ContactCompany	String	The company of the contact associated with this history.
ContactEmail	String	The email of the contact associated with this history.
ContactPhone	String	The phone number of the contact associated with this history.
ContactPhoneExt	String	The phone extension of the contact associated with this history.
CreateUserName	String	The username of the user who created this history.
EditUserID	String	The ID of the user who last edited this history.
EditUserName	String	The username of the user who last edited this history.
HistoryTypeActivityTypeName	String	The activity type name of the history type.
HistoryTypeActivityTypeId	Integer	The activity type ID of the history type.