Open Calls

SugarCRM

 

SugarCRM is a cloud CRM from the SugarCRM software company, that includes sales force automation, marketing campaigns, customer support, collaboration, reporting, etc. features.

Open Calls в течение последних двух лет по определенному пользователю

Query Text

SELECT Calls."name" AS "Subject", Calls."status", Calls."date_entered" AS "Date Created", "calls_assigned_user"."user_name" AS "Assigned User"
  FROM Calls
LEFT OUTER JOIN Users AS "calls_assigned_user" ON Calls."assigned_user_id" = "calls_assigned_user"."id"
WHERE (Calls."date_start" >= '2014-01-01 00:00:00' AND (Calls."status" = 'Planned' OR Calls."status" = 'Not held'))
  

Open Query