ActivityPointer (activity) table

Note

Unsure about entity vs. table? See Developers: Understand terminology in Microsoft Dataverse.

The activity pointer (activity) table represents any activity or task that is performed, or to be performed by a user. An activity is any action for which an entry can be made on a calendar.

Whenever you create an activity record in Microsoft Dataverse, a corresponding activity pointer record is created. This indicates that the activity record and the corresponding activity pointer record have the same value for the ActivityId column. For example, if you create an Email record, the column values of Email.ActivityId and the corresponding ActivityPointer.ActivityId will be the same.

The ActivityPointer.ActivityTypeCode column defines the type of the activity. The possible values for this column are defined in activitypointer_activitytypecode global option set.

Control how activities are sorted by date

Whenever you display a list of activity entities and order them by date, you can only use the common date columns defined in the activitypointer table. However, sometimes you want different sorting behaviors depending on the type of activity. For example, with the email table you might want to sort by the senton column value rather than the modifiedon column value.

Use the sortdate column to control how activities are sorted by date. By default, the sortdate column value is null. You must include business logic to populate the date value that will be set for this column and then use the sortdate column within the query defined for the view. You can set the sortdate column value using a workflow or a plugin. For consistent results you should set this value for every type of activity and any existing activity data in the system.

See also

Activity tables
ActivityPointer table