Skip to main content

Hello, 

 

I need to find all cases that have had their status at 'on hold' at any time during the previous month - is there a way to do this? 

 

Status' do change frequently so running a report for all on hold cases won't capture those that were on hold last month...

 

Thanks, 

 

#Fields & Relationships  #Reports & Dashboards

1 Antwort
  1. 22. Feb. 2024, 00:44

    Hi Taylor,

     

    Assuming your Org has Field History Tracking enabled already for the Case object, you should be able to pull this info from the database from the CaseHistory associated object that SF creates for all objects that have Field History Tracking enabled.

     

    Learn more on how to pull the data at: 

    https://help.salesforce.com/s/articleView?id=sf.tracking_field_history.htm&type=5

     

    Hope this helps!

0/9000