Advance Reporting on Next Step text field not updated in the last 30 days

Hi Anthony Seghetti 

It is possible through Advanced Report.

In order to fetch such data you must set field next_step on Opportunities as Audited.

Regarding the Report query you have to join tables opportunities and opportunities_audit:

SELECT
   o.id,
   o.name,
   (
      SELECT MAX(DATEDIFF(NOW(), oa.date_created)) days
      FROM opportunities_audit oa
      WHERE oa.parent_id = o.id AND oa.field_name = 'next_step'
   ) next_step_days_last_change
FROM opportunities o
WHERE o.deleted = 0
HAVING next_step_days_last_change IS NULL OR next_step_days_last_change > 30
ORDER BY next_step_days_last_change DESC;

Regards

This is great! - Is there any way to just include specific sales stages or exclude specific sales stages?

For example, if I did not want to see Inactive, or anything Closed? 

Yes, you just need to place the sales_stage conditions just after "WHERE o.deleted = 0".

Regards

Yes, you just need to place the sales_stage conditions just after "WHERE o.deleted = 0".

Regards