Stuck Opportunities



Salesforce is the most popular cloud CRM with a focus on sales and support. Skyvia requires Salesforce Enterprise edition or higher.

Where are the opportunities getting stucked ?

Query Text

SELECT "Owner"."Name" AS "Opportunity Owner", Account."Name" AS "Account Name", Opportunity."Name", Opportunity."StageName", Opportunity."Fiscal", Opportunity."Probability", Opportunity."CloseDate", Opportunity."Type", Opportunity."Amount"
  FROM "Opportunity"
INNER JOIN User AS "Owner" ON Opportunity."OwnerId" = "Owner"."Id"
LEFT OUTER JOIN Account ON Opportunity."AccountId" = Account."Id"
WHERE (date(date(Opportunity."CloseDate"), 'start of year') = date('now', 'localtime', 'start of year') AND Opportunity."IsClosed" = False)
ORDER BY Opportunity."StageName", Opportunity."Fiscal"

Open Query