Active Cases

Dynamics CRM

 

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

Active cases list

Query Text

SELECT  inc."title" 'Case Title', inc."ticketnumber" 'Case Number', inc."prioritycode" 'Priority', inc."caseorigincode" 'Origin',
        c."fullname" 'Customer', su."fullname" 'Owner', inc."statuscode", inc."createdon"
  FROM "incident" inc, "systemuser" su, "contact" c
  WHERE inc."createdby" = su."systemuserid" AND 
        inc."customerid"= c."contactid" AND
        inc."statecode" = 'Active'
UNION 
SELECT  inc."title" 'Case Title', inc."ticketnumber" 'Case Number', inc."prioritycode" 'Priority', inc."caseorigincode" 'Origin',
        a."name" 'Customer', su."fullname" 'Owner', inc."statuscode", inc."createdon"
  FROM "incident" inc, "systemuser" su, "account" a
  WHERE inc."createdby" = su."systemuserid" AND 
        inc."customerid"= a."accountid" AND
        inc."statecode" = 'Active'
  

Open Query