cancel
Showing results for 
Search instead for 
Did you mean: 

Alter SQL for Graph on Dashboard

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Alter SQL for Graph on Dashboard

I need to alter the SQL (or the filter) for the Graph on Magento Dashboard.

Currently it only shows orders with state "completed" and I need to change that. A customer wants to include orders with state "processing" to the Graph.

Where do I change the Graph function?

 

Info ... I use Magento 1.9.2.0

1 REPLY 1

Re: Alter SQL for Graph on Dashboard

The dashboard uses the Mage_Reports plugin. The product collection is here: app/code/core/Mage/Reports/Model/Resource/Order/Collection.php. There is a configuration setting which chooses whether live data or aggregated is used. 

 

It's probably around this line you'll want to adapt: https://github.com/OpenMage/magento-mirror/blob/505e8e982ad5f4fd22005060564cad210aab7b6f/app/code/co...

----
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution" as appropriate. Thanks!