Open Activities

Dynamics CRM


Dynamics CRM is a widely used cloud CRM from Microsoft, focused on Sales, Marketing, and Service (help desk) sectors.

List of CRM Activities (Phone Call, Task, Appointment, Email etc)

Query Text

SELECT activitypointer."subject", activitypointer."activitytypecode" AS "ActivityType", activitypointer."statecode" AS "ActivityStatus", activitypointer."prioritycode" AS "Priority", activitypointer."scheduledend" AS "DueDate"
  FROM "activitypointer"
INNER JOIN owner AS "owner_activitypointers" ON activitypointer."ownerid" = "owner_activitypointers"."ownerid"
WHERE ("owner_activitypointers"."name" = 'Devart Corp' AND activitypointer."isregularactivity" = True AND (activitypointer."statecode" = 'Open' OR activitypointer."statecode" = 'Scheduled'))
ORDER BY activitypointer."subject"

Open Query