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