Dashboard for: 
You have 0 TASKS for today
| Due Date | Account - Lead Company | Subject | Status | Priority | Related To | Name | City | Delay |
|---|---|---|---|---|---|---|---|---|
|
Today TASKS: 0
|
||||||||
Your 20 past due Tasks
SELECT TASKS.*, ACCOUNTS.Name AS ACCName, CONCAT(ACCOUNTS.BillingCity, ', ', ACCOUNTS.BillingState, ' (', ACCOUNTS.BillingStateCode, ')') AS ACCCity FROM TASKS LEFT JOIN ACCOUNTS ON TASKS.AccountId=ACCOUNTS.Id WHERE TASKS.OwnerId='' AND TASKS.Status NOT LIKE 'Completed' AND TASKS.ActivityDate < '2024/05/03' ORDER BY TASKS.ActivityDate DESC
| Due Date | Account - Lead Company | Subject | Status | Priority | Related To | Name | City | Delay |
|---|---|---|---|---|---|---|---|---|
|
Older Open TASKS: 2
|
||||||||
| 2021-02-03 | Amec Foster Wheeler Engineering Svs | JV:called to setup event no response | In Progress | Normal | Account - Amec Foster Wheeler Engineering Svs | Contact - Karen Kramer | Houston, Texas (TX) | |
| 0000-00-00 | - | - | ||||||
Your future Tasks (7 Days)
SELECT TASKS.*, ACCOUNTS.Name AS ACCName, CONCAT(ACCOUNTS.BillingCity, ', ', ACCOUNTS.BillingState, ' (', ACCOUNTS.BillingStateCode, ')') AS ACCCity FROM TASKS LEFT JOIN ACCOUNTS ON TASKS.AccountId=ACCOUNTS.Id WHERE TASKS.OwnerId='' AND TASKS.Status NOT LIKE 'Completed' AND TASKS.ActivityDate > '2024/05/03' AND TASKS.ActivityDate <= '2024-05-09' ORDER BY TASKS.ActivityDate DESC
| Due Date | Account - Lead Company | Subject | Status | Priority | Related To | Name | City |
|---|---|---|---|---|---|---|---|
|
7 days TASKS: 0
|
|||||||
Your 0 open Opportunities
SELECT * FROM `OPPORTUNITIES` WHERE `OwnerId`='' AND `IsClosed`=0 ORDER BY CloseDate DESC
| Close Date | Opportunity Name | Description | Stage Name | Type | Lead Source | Amount |
|---|---|---|---|---|---|---|
| Open Opportinities for : 0 | fin Opps | |||||
You have 2 OPEN TASKS
