--- schema_version: "1" id: f336858ffd37417cd893cf9f0037aeeb427b9155d344578d3ce0ea6c0a37295a title: Examples of Classic Approval History Reports collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/approval_history_reports_examples.md canonical_url: https://help.salesforce.com/s/articleView?id=platform.approval_history_reports_examples.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 5940ba337914affd88bdb0dfb9567917e0dff322a9efe85d728ed5a3e0f8e382 description: See sample reports to learn how you can obtain approval history data. products: - Flow Builder - Salesforce Platform release: "264" --- # Examples of Classic Approval History Reports See sample reports to learn how you can obtain approval history data. ### Required Editions
Available in: both Salesforce Classic and Lightning Experience
Available in: Enterprise, Performance, Unlimited, and Developer Editions
![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-platform_automation-264-0-0-production-enus/60568438-ec7e-4665-acd1-7c80dcbe60d5/images/icon_important.png) Important Try [Flow Approval Processes](https://help.salesforce.com/s/articleView?id=platform.automate_automated_approvals.htm&release=264.0.0&type=5 "As your company grows, so does the complexity of your approvals, often requiring input from multiple people in different departments across different time zones. This complexity can mean that you spend more time waiting for each person to complete their review in the right order. Flow Approval Processes helps you coordinate multistep reviews that involve users, systems, and conditional paths."), a modern alternative to Classic Approval Processes. This new feature provides a more flexible, user-friendly flow-based interface, and it can trigger on record changes, supporting Apex extensibility and detailed logging for compliance and audit trails. It supports dynamic routing based on data and business rules, unlike Classic Approval Processes, which are tied to specific objects and offer limited support for processes by using conditions. With Flow Approval Processes, you can monitor submitted records and quickly identify bottlenecks, giving you unprecedented visibility into approval workflows. And, like Classic Approval Processes, Flow Approval Processes don’t consume automation credits or orchestration runs. ## Report Example: Opportunity Approvals Submitted Within a Date Range This sample report displays classic approval process instances that were submitted within a specified date range (1) for the Opportunity object (2). The results are sorted by status (3) and include the last actor (4), submitted date (5), completed date (6), record name (7), classic approval process instance ID (8), and classic approval process name (9). ![Sample classic approval history report for the Opportunity object](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-platform_automation-264-0-0-production-enus/60568438-ec7e-4665-acd1-7c80dcbe60d5/platform_automation/images/approval_history_report_example_oppty_date_range.png) ## Report Example: Approvals—Elapsed Times This sample report displays all classic approval process instances (1) and groups results by the classic approval process name (2). The results include the record name (3), classic approval process instance ID (4), status (5), submitted date (6), elapsed minutes (7), and completed date (8). ![Sample classic approval history report for all process instances grouped by approval process name](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-platform_automation-264-0-0-production-enus/60568438-ec7e-4665-acd1-7c80dcbe60d5/platform_automation/images/approval_history_report_all_grouped_by_name.png) ## Report Example: Approval Steps—Elapsed Times This sample report displays all classic approval process instances (1) and groups results by classic approval process name (2) and record name (3). The results are sorted by step name (4) and include step status (5), step start date (6), step elapsed minutes (7), step completed date (8), and classic approval process instance ID (9). ![Sample classic approval history report for all process instances and step info](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-platform_automation-264-0-0-production-enus/60568438-ec7e-4665-acd1-7c80dcbe60d5/platform_automation/images/approval_history_report_all_steps.png) Notice that the previous sample report doesn't include the approvers for each step and the elapsed time for each approval request. To get this information, run a SOQL query by using the classic approval process instance ID from the report. The following sample SOQL query obtains the ActorID (user or queue that received the approval request) and the ElapsedTimeInHours (elapsed time since the approval request was sent) for the first pending step in the report. ```sql SELECT ActorId,ElapsedTimeInHours FROM ProcessInstanceWorkitem where processInstanceId = '04gD0000000LvIV' ``` ![Sample SOQL query and results](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-platform_automation-264-0-0-production-enus/60568438-ec7e-4665-acd1-7c80dcbe60d5/platform_automation/images/approval_history_report_soql_query_supplement.png) The sample query has only one result, and you can view that approver's user profile page by appending the resulting ActorID to the organization's base URL (https://MyDomainName.my.salesforce.com/005D00000015vGGIAY), which gets redirected to the user profile page. ![User profile page after redirect](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-platform_automation-264-0-0-production-enus/60568438-ec7e-4665-acd1-7c80dcbe60d5/platform_automation/images/approval_history_report_user_profile_page.png) #### See Also - [Classic Approval Process History Reports](https://help.salesforce.com/s/articleView?id=platform.approval_history_reports.htm&release=264.0.0&type=5 "If you create a custom report type for classic approval process instances, users can view the historical details of completed and in-progress classic approval processes and their individual steps.")