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