Deal Activities Query

Deal Activities Query

I found this Deal Activities query in analytic. Apparently, it ran a long time ago, but now does not find a table called "Activities."

This would be a highly useful query table for me. Can it be revised to work with however CRM stores the underlying "activities" associated with a Deal?


  1. SELECT
  2. p."Id" "POTENTIALID",
  3. p."Deal_Name" "Potential Name",
  4. p."Owner.full_name" "Potential Owner",
  5. p."Owner" "Potential Owner Id",
  6. p."Created_Time" "Potential Created Time",
  7. p."Closing_Date" "Potential Closing Date",
  8. p."Type" "Potential Type",
  9. p."Stage" "Stage",
  10. p."Amount" "Amount",
  11. a."Activity Id" "ACTIVITYID",
  12. a."Activity" "Activity",
  13. a."Subject" "Subject",
  14. a."Activity Owner" "Activity Owner",
  15. a."Created Time" "Activity Created Time",
  16. a."Modified Time" "Activity Modified Time",
  17. a."Due Date" "Due Date",
  18.  
  19. case
  20. when p."Stage"  = 'Closed Won' then p."Deal_Name"
  21. else null
  22. end "Won Potential",
  23. datediff(a."Due Date", p."Created_Time") AS "Days to Respond"
  24. FROM  "Deals" p
  25. INNER JOIN "Activities" a ON a."POTENTIALID"  = p."Id"